I have a requirement to track job done by workers

  • billmy
    Asked on February 24, 2021 at 3:55 PM

    I have a requirement to track job done by workers

    Using Jotform, is it possible to create this;


    Database 1 - ID, Name, Address, DOB (self explanatory)

    Database 2 - Name (which is link to the above database, lookup field), task

    The task field will include text movements


  • Elton Support Team Lead
    Replied on February 24, 2021 at 10:10 PM

    There's a workaround for that our Spreadsheet to Form Widget. You can use a spreadsheet file as your database then this is where you perform the lookup. Once the entered code matches on the spreadsheet file, it would populate the form fields with the data. Here's how: https://www.jotform.com/help/442-how-to-use-the-spreadsheet-to-form-widget

    Demo: https://www.jotform.com/71642066575965

    Aside from this workaround, you can use Tables to manage your submissions data.

    Regards!