How can I include the number option and the input table, to get populat

  • Profile Image
    ViaInsideSales
    Asked on October 05, 2018 at 10:30 AM

    How can I include the number option and the input table, to get populated with spreadsheet to Form Widget?, or is there another option to get pre populated?



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    AshtonP
    Answered on October 05, 2018 at 11:59 AM

    Unfortunately, a spreadsheet to form widget cannot be used with Input Table field.

    The only other option could be to get the values populated in the other fields such as numbers and then Calculation to populate the numeric values to the input tablet.

    Please allow me some time so I can create a demo for you.

  • Profile Image
    AshtonP
    Answered on October 05, 2018 at 12:36 PM

    I worked on a demo form. You can populate values from Spreadsheet to Input table however it's not straightforward.

    You need to first create a short text box for each of the input table's cell. Then populate the value in the short text field and then user Conditional Logic to calculate the value inside the input table. 

    Here how you can create a condition to calculate the short text fields values into the respective cell of the input table.

    Here is my form - https://cms.jotform.com/uploads/image_upload/image_upload/AshtonP/69205_Selection_883.png

    69205_Selection_883.png

    You will have to create multiple conditions like these, one for each cell.

    69206_Selection_884.png

    You can take a look at my demo form - https://form.jotform.com/82774848482978. Use Unique1, Unique2 or Unique3 to prepopulate the data.

    I hope this helps. Let us know if you need more information.