Does the quantity gift registry integrate with airtable?

  • Profile Image
    kadampa
    Asked on February 06, 2021 at 11:52 PM

    Hi There

    Does the quantity gift registry integrate with airtable?

    Thanks



    This is a re-post of a comment on How to integrate Jotform with Airtable

  • Profile Image
    Patrick_R
    Answered on February 07, 2021 at 03:26 AM

    Hello! Kindly note that it is not possible to map a Quantity Gift Registry field to any field of Airtable directly.

    But passing this widget's data is still possible. You need to simply create a Long Text Field and using condition map the Gift Registry field data to this Long Text field.

    Then, while integrating, you can map Long Text field to the appropriate field in Airtable.

    This is it. Following is the screencast that shows how this can be set up:

    https://shots.jotform.com/patrick/Screencast%202021-02-07%2013-47-23.webm

    In this demo, I have kept the Long Text field visible; you can hide it on your form.

    I hope this helps. If you have any questions or if this doesn't solve your purpose, let us know.

    Thank you!

  • Profile Image
    kadampa
    Answered on February 07, 2021 at 12:05 PM

    Thank you, it does the job very well

    I need something that will control the quantity I have in stock = The gift registry is perfect.

    But I want to know which item they have chosen to go into airtable

    Any suggestions?

    Thanks

  • Profile Image
    Ariel_P
    Answered on February 07, 2021 at 02:07 PM

    Hello there,

    Are you referring to your https://form.jotform.com/210343997701356 form?

    Have you tried my colleague's suggestion? He has a screencast on how to set it up here.

  • Profile Image
    kadampa
    Answered on February 07, 2021 at 02:16 PM

    Yes thats correct but it only takes the amount, not the item?

  • Profile Image
    Ariel_P
    Answered on February 07, 2021 at 03:36 PM

    You'd have to set the widget's Calculate Total to "No".

    161273015020210208-043408.jpg

    Give it a try and let us know how it goes.

  • Profile Image
    kadampa
    Answered on February 08, 2021 at 02:44 AM

    Yes I did that, it is set to yes and its giving me a result = 1

    I want the result to be the item they have chosen not the quantity

  • Profile Image
    Sara_G
    Answered on February 08, 2021 at 05:20 AM

    Hi,

    Apologize for the issue.
    On the Gift Registry widget you can see only the quantity of items booked.
    If you wish to see which product/class has been booked, please go to Tables to view all the submissions entries included the selected product/class:

    126286_Screen%20Shot%202021-02-08%20at%2Please check this link for further details: https://www.jotform.com/help/269-how-to-view-form-submissions
    Hope this would help.

    If you require further support, please let us know.
    Thanks.

  • Profile Image
    kadampa
    Answered on February 08, 2021 at 06:09 AM

    Thanks for your reply

    I would like to transfer the info from the form to airtable?

  • Profile Image
    Kenneth_C
    Answered on February 08, 2021 at 07:58 AM

    Hi there,

    As my colleague, Patrick_R suggested, you use conditions to pass the input data from the Widget to a Long Text field, then map that text field with Airtable, the integration will only work with matching Field Data Types of both platforms: https://support.airtable.com/hc/en-us/articles/203229705-Guide-to-the-basic-field-types, that is why this workaround should work.

    Here is the guide to Insert values into another field: https://www.jotform.com/help/268-how-to-insert-text-or-calculation-into-a-field-using-conditional-logic.

    Let us know if you have any further questions.

    Best.