JotForm Table: Pulling data from one table to another

  • lreid13
    Asked on February 16, 2021 at 2:19 PM

    Hello,

    I have a Recruitment Tracker Table set up with some tabs. I'd like to be able to populate the tab "Do Not Hire" from information from the "Interview" tab once the "Approach" is set to Do Not Hire on the "Interview" tab.

  • VincentJay
    Replied on February 16, 2021 at 6:31 PM

    Hi,

    You can do that by following this guide: https://www.jotform.com/help/1002-how-to-get-data-from-other-forms-in-jotform-tables

    Please check it and let us know if you need further help. Thank you!

  • lreid13
    Replied on February 23, 2021 at 11:38 AM

    Hi,

    This isn't exactly what I am looking for. This I am aware of how to do, but I am looking for a way to connect information from one table TAB to another one that is already created once a field has been updated.

    Recruitment Tracker (most recent date)

    1. Interview Tab
    2. once the Approach field is set to DO NOT HIRE I'd like the following to happen..
    3. Do Not Hire Tab
    4. Will populate the fields in the sheet.
  • VincentJay
    Replied on February 23, 2021 at 1:59 PM

    Hello,

    Are you referring to this form?

    https://www.jotform.com/form/203017934735051

    https://www.jotform.com/form/203025555231040

    If yes, what form field you want to pass to another JotForm table? What form field you want to populate from the other form?

  • lreid13
    Replied on February 26, 2021 at 3:45 PM

    Sorry for the delay.

    Yes this is correct form(s). So I'd like the information from the Interview to auto populate into the Do Not Hire as follows:

    Name/Position Applied/Position Title/Notes ONLY based on if "Approach" from the Interview form is selected.

  • VincentJay
    Replied on February 26, 2021 at 5:16 PM

    Just to clarify, if the Interview - Approach column is the "Do Not Hire" option, you want to populate the Do Not Hire tab with the Name/Position Applied/Position Title/Notes column? Do you want to pass the data from the Interview form?

    I tested it and you need to do it manually. Here's a sample Name field that pulls it from the other form:

    1614377760 60397320476a4 vsad3523 Screenshot 10