Data collection from web form works but not 100%

My Goal Get information from several webforms which represent different subscription plans
I have 3 webforms we can call them plan 1, plan 2, plan 3

The forms all have exact same information except for a button with a label of the plan name. I have created a filter to select each plan name and to go into my google sheet. EVERYTHING works fine except the label does show plan name in the spreadsheet only the other details. what I want is the plan text to end up in the plan field of my spreadsheet.

namest

any guidance would be appreciated
Regards

Hi @chaka,

Are you saying the Plan Name is not in the webhook’s payload, so you cannot map it to column A when writing the row to Google Sheets?

If you are able to show your entire scenario, or even the blueprint, and some more information about the forms, I hope you will be able to get some more help here.

3 Likes

@Donald_Mitchell another screenshot for clarity
cap2
Here is the payload, you can see the plan name is included however this is not translating over on the google sheet side. the rest of the payload is however transferring over as expected.

the form was created using a website builder , and im using its submit form to url feature. everything functions as it should with the exception of the

Plan

"plan name " portion
Regards.

You should be able to map over that variable. It may look weird, but should still work. What happens when you drop the <p>Plan</p> variable into the Plan Name field in the Google Sheets module?

3 Likes