How to integrate google sheets information in jotform element

  • negma1
    Asked on January 9, 2022 at 3:27 AM

    Hello Jotform,

    I have a few small questions,

    • Is it possible to import / upload information (room prices) from Google sheets to Jotform.
    • I use unique id in my form, and it has been working for a long time but the last year (sorry because of corona we dont receive many forms) the unique id does not work and gmail adds all the forms in one jotform email receipt. Can you please advise.
    • Is it possible in the new app that when people click on book this room, the form is automatically filled with the room name etc?

    Thank you very much,

    Best regards,

    Bedouin Star




  • Carrissa JotForm Support
    Replied on January 9, 2022 at 4:39 AM

    Hello there,

    Thanks for contacting Jotform.

    Unfortunately, that's not possible. I'm afraid we do not have that feature. You can however achieve what when you use your form source code and implement the function in the form source. 

    Here's how to get your form source code and here's how to pull data from Google Sheet and place it on a dropdown field: Watch the guide.

    I have move your other inquiries to get specific answer in each inquiries.

    Regards,

  • negma1
    Replied on January 9, 2022 at 4:44 AM

    Hi Carissa,

    Thank you for your fast reply, I will take a look in it.

    Best regards,