Answered

send custom answer to sheets

  • 26 January 2022
  • 4 replies
  • 36 views
L

Hy all,

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.

icon

Best answer by john.desborough 26 January 2022, 12:57

View original

4 replies

john.desborough
Userlevel 7
Badge +6

@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

that might work for you

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
L

@john.desborough Thanks,

It’s sound good to me.

If someone wants “this cool cargo bike” i can replace that answer by “cargoByke_ModelXYZ” as the database calls it.

 

I’ll try that out. I’ll let you know how it went !

john.desborough
Userlevel 7
Badge +6

good luck with the test @LukeVideo .. let us know how it goes!

 

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
picsoung
Rank
Userlevel 7
Badge +5

Hi @LukeVideo 

For this usecase you might be interested to play around what we call “block reference”: https://www.typeform.com/help/a/block-reference-format-restrictions-360050447552/

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.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs