send custom answer to sheets | Community
Skip to main content
Answered

send custom answer to sheets

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.

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

that might work for you

 

des

View original

    4 replies

    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5268 replies
    • Answer
    • January 26, 2022

    @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...
    Gabi Amaral
    1 person likes this
    • Gabi Amaral
      Gabi Amaral
    L
    • LukeVideo
    • Author
    • Explorer
    • 2 replies
    • January 27, 2022

    @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
    1 person likes this
    • john.desborough
      john.desborough
    john.desborough
    Forum|alt.badge.img+6
    • john.desboroughCertified Partner
    • Certified Partner & Champion
    • 5268 replies
    • January 27, 2022

    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
    Typeform
    Forum|alt.badge.img+5
    • picsoung
    • Developer Advocate @ Typeform
    • 384 replies
    • January 27, 2022

    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