pull data and populate the form fields

  • Profile Image
    Ear_Wonder
    Asked on December 03, 2020 at 11:03 AM

    We're using Airtable as our CRM choice, and as part of it, we manage our item returns there.

    Is it possible to have a customer input his order number in the first step of the Jotform, and on the second step - pull up all the items from his order number (we have it all stored on Airtable as well) and showcase it to him, giving him the option to choose which product he's looking to send back.


    I hope it's clear enough.


    Thank you.

  • Profile Image
    Richie_P
    Answered on December 03, 2020 at 12:33 PM

    It is possible to pull data from an excel file using the Spreadsheet to form widget.

    Guide:https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    However, if you would like to get the data from Airtable, it is not possible in JotForm.

    We can only forward the data to the Airtable integration.