Populating Google Sheet from Drop Down menu in Gravity Forms

@katecard Can you provide screenshots of what’s not populating corrected vs the expected results in GSheets?

Sure thing. The form only has a few drop-down menus. Everything else they enter in text, or radio button choice, or upload. All of these other fields are working great with the zap as populating as expected. You can see in the spreadsheet the most recent entry is blank in these fields. The entry you see above this one was before I switched to drop down and had these as text fields. It was working fine. 

@katecard Since you changed the field type on the form from text to dropdown, I suggest you try remapping those fields in the Zap step and testing again.

If you see a gray icon next to the dynamically mapped data point, then it means the data point no longer exists.

Let us know how that goes.

Hi Troy- I did try that. Here’s what I’m seeing:

@katecard That looks to be mapped correctly.

Did you try turning the Zap ON and testing again by submitting a new real form?

Yep! Not working.

@katecard Have you checked the Zap Task History? https://zapier.com/app/history/

Did the Zap trigger?

Did the Zap result in an error on a step?

Check the DATA IN/OUT for each step.

Hi Troy-

The Zap triggers- all the other fields are populated. I do not get an error notification. The data out seems to show the data is being received, but not showing up on the sheet. So weird, yes?

Should I start fresh with a new Google Sheet? 

Kate

Hi Troy- that did it. I didn’t see the DATA IN in the history, and when I found it, there were the double brackets. Thanks so much for helping me.

Kate