I have a requirement to track job done by workers

  • Profile Image
    billmy
    Asked on February 24, 2021 at 03: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


  • Profile Image
    EltonCris
    Answered 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!