pull data and populate the form fields

  • Ear_Wonder
    Asked on December 3, 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.

  • Richie JotForm Support
    Replied on December 3, 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.