Question

Mapping two Gravity Forms fields to a single Google Sheets cell

  • 15 June 2021
  • 1 reply
  • 62 views

We  have  a  gravity  form the  has  two address field sections , one  for  domestic and one for international address.  They  are  hidden  and  displayed  conditionally based on a  check box.  We like  to map  them to  the  same  set of  cells in a  gsheet.

 

So for  example  city (domestic) and  city (international)  in gravity  forms  both  map to  city in gsheets

 

So  far  been unable  to  get this  to  work. It appears  that the  domestic addres fields  get mapped, but the international ones  do not.  If we  remove  the  conditional  logic from the  gravity forms  so we  can fill in data  for  both  address sections, we  get only  the international address data-  Not both sets as we would  expect.

 

Should  this  be  possible?  Before  we  spend any more time  testing  this.  If  so  any likely  gotchas?

 

Thanks

 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Eric Magers 

Try mapping both data output fields to the desired GSheet column.

You may have to change the trigger data to get the data points to come thru for each: domestic and intl

Help article about changing the trigger data: https://zapier.com/help/create/basics/set-up-your-zap-trigger

End result is you should have 2 data points from GF mapped to 1 GSheets column.

Make sure to test after you’ve been able to map both fields.