Submissions Completed

  • Profile Image
    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?

  • Profile Image
    Dagmar_B
    Answered on October 27, 2020 at 01: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_
    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_

    Feel free to contact us if you need further assistance.