How can I compare data from 2 forms?

  • Profile Image
    ballwegfamilypharm
    Asked on February 01, 2021 at 04:20 PM

    If I have a form with names of people that I need to give vaccine too, can I import a spreadsheet of completed (vaccinated) persons into a different column and then delete the duplicates to shorten my waiting list each week?

    I see how to import data to create a new table, I just can't seem to figure out how to take these 2 tables of patient names and quickly delete out the folks that I have completed.

  • Profile Image
    Jed_C
    Answered on February 01, 2021 at 10:28 PM

    You can try to import those that are on your tables and on your spreadsheet then use this app to delete duplicate data https://www.jotform.com/apps/duplicate-submissions-terminator.

    Would that work for you? Looking forward for your response.

  • Profile Image
    Jed_C
    Answered on February 01, 2021 at 10:30 PM

    It seems that the duplicate app has been discontinued. Unfortunately, I can't find any other apps or workaround other than manually deleting it. That app used to work for duplicates, but it seems to be disabled for some reason.