Jotform Table: Pulling data from one table to another

  • Profile Image
    melreid20
    Asked on February 16, 2021 at 02: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.

  • Profile Image
    VincentJay
    Answered on February 16, 2021 at 06: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!

  • Profile Image
    melreid20
    Answered 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.
  • Profile Image
    VincentJay
    Answered on February 23, 2021 at 01: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?

  • Profile Image
    melreid20
    Answered on February 26, 2021 at 03: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.

  • Profile Image
    VincentJay
    Answered on February 26, 2021 at 05: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.gif