Submissions Completed

  • cobc
    Asked on October 27, 2020 at 12:08 PM

    Is there a way using Jotform Tables to have a table with list of people names and somehow cross reference completed forms or submissions to show who hasn't complete the form?

  • Dagmar_B
    Replied on October 27, 2020 at 1:41 PM

    Hello,

    I am happy to help you explore the new tables view.

    If you have two tables you can connect them and crossreference the submissions.

    Let's say you have table A - the list of names (for this example a tables template I imported from https://www.jotform.com/table-templates/) and a form that Users fill out.

    You can connect the Name field of the form to table A as a new column and select from the name fields so you can match each name- That way if you do not find a match you know there is a submission missing.

    Here is how:

    1. Add a new column in your Table A
    2. Choose Connection
    3. Choose connect a table, click next
    4. Name the new column
    5. Choose the table, then the tab and the column to be connected 1603820190 5f985a9ebb5c1  Screenshot 10
    6. By clicking on a field in the new column you can add the name from the list you just connected.

    Here is a screencast to help understand it better:

    Excuse the searching in the middle. Of course my names do not match in this instance- only test names in the connected table , but the way to create the connection should become clear.

    1603820339 5f985b3348d45  Screenshot 21

    Feel free to contact us if you need further assistance.