I’m working on a typform where custumers choose wich of our product they wish to rent.
The name in the typeform wich is “user readable” does not match our database naming convention, thus makes it tricky to get a match when calling our apps API with type form data.
Is there a way have a different answer displayed in the form and send the the google sheet i use.
I could do the check in the script in the google app but i’dd rather have it be done before it hit’s the google shheet.
Regards,
Luke.
Best answer by john.desborough
@LukeVideo - welcome to the community
you can use a variable to hold the ‘required’ value to be transferred and to set with logic rules. for example,
create a variable called v_transfer
in the logic rules, create one that does something like this:
if response to question N is A then replace v_transfer with ‘XD123’
if response to question N is B then replace v_transfer with “ABC45’
then you can map the variable to outbound field/API requirements
But in the google spreadsheet you will see the value of option and not it’s reference. If you want to use the reference you would have to call the API.
