Spreadsheet to form widget: What this is used for?

  • Profile Image
    info5058
    Asked on June 25, 2019 at 01:28 AM

    After my first reading of this, I don't yet understand what this is for. A video would be helpful.



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

  • Profile Image
    ashwin_d
    Answered on June 25, 2019 at 02:32 AM

    Please note that spreadsheet to form widget is used to search for a text and populate form fields. 

    If you have a data in excel file, you can upload that excel file in the widget. This excel file will have a unique code column and the other column heard should match the form field label. Then the user access form, input the unique code in the textbox and click on the button, it will search for that code in the uploaded excel file. If that code is available in the excel file, other column data of that row will be populated in the form fields. 

    I would suggest you to please try out the widget and get back to us if you have any questions.