I need to create a daily report form but the data needs to be editable

  • wendydroubay
    Asked on June 12, 2020 at 4:02 PM

    Each day we have our drivers fill out a report. we collect all kinds of information. One piece of that information is letting them know when they have returns they need to pick up. It has data like, where the return is, how many pieces there are, the tracking number, etc. Our dirvers need this information to know when and where to go in order to get the returns. Each day our office enters this information for them. I need to create a table at the top of the form that will show this information and allow them to report on it. Most of the data tables widgets dont work becasue they put all of this information into one cell when its exported. 

    I would like to use the spreadsheet to form widget, which would allow us to pre-popoulate fields based on a uniqe identifier. However, i would have to build the table using short text entry boxes. 

    Any suggestions on how we could accomplish this? Ive attached a snapshot of the google sheet each driver fills out each day.

    Jotform Thread 2386121 Screenshot
  • David JotForm Support Manager
    Replied on June 12, 2020 at 6:17 PM

    Thank you for contacting us. Short Text fields are not the only ones supported by the Spreadsheet to Form widget, please see this guide that shows the supported fields: 

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    If you want to position more than one field on the same line, please check the following guide: https://www.jotform.com/help/90-Form-Field-Positioning

  • David JotForm Support Manager
    Replied on June 12, 2020 at 6:23 PM

    Forgot to mention, if you create the form in the Classic layout, and you would like to position the fields to form a table layout, our forms allow CSS injection. If you hire a CSS developer, he should not have any issues styling the form. Unfortunately, we don't have such a service, but you can find and hire someone at Upwork.com.