Uploading to a Column in Sheets

  • Profile Image
    MlemusEE
    Asked on March 25, 2020 at 08:08 PM

    Hi,

    I have several forms created and would like to know if I have a unique ID in the forms if it is possible to upload from an existing excel document where there is a match on the unique ID.  Could I add a column with a dollar amount on the sheets that is only added if there is a match?

  • Profile Image
    Sonnyfer
    Answered on March 25, 2020 at 10:21 PM

    Hi,

    Thanks for reaching out.

    I believe our Spreadsheet to Form Widget will help you achieve that. The said widget has the ability to pull existing records and display them on your form.

    Guide: How-to-Use-the-Spreadsheet-to-Form-Widget

    Kindly give it a try and let us know if you need further assistance.

  • Profile Image
    MlemusEE
    Answered on March 25, 2020 at 11:29 PM
    Yeah Ii don’t want it to affect my form I want the data I have in my excel sheet to match to the unique In my form and a new column with the dollar amount populated for those that matched.
    Thanks,
    Manny Lemus
    Director of Billing Operations
    Manuel.Lemus@EmeraldX.com
    Office: (949) 226-5703
    www.emeraldx.com
    [Emerald_Email_Sig_Logo-174x40]
    *please excuse any typos, this was sent from my iPhone/iPad.
    ...
  • Profile Image
    KrisLei
    Answered on March 26, 2020 at 02:42 AM

    Hi Manny,

    You can try to use the import data application: http://import.jotform.io/

    This will let you import your existing data to your form: Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm

    But using this app you have to verify that the fields and the column titles matched with your existing data. 

    Let us know if it didn't meet your requirements.