Skip to main content
Solved

Inherit data from selected record into a new record

  • August 30, 2023
  • 3 replies
  • 52 views

Forum|alt.badge.img+6

Hi all

I hope I can explain my question clearly enough. 

I have three tables - Job List, Candidate List, Applications

From Job List, I want to select a job and create a new Application record which will inherit the selected job title into the job title field on the Application record. This would also be a parent-child relationship.

Can anyone tell me if this is possible to do?

Best answer by DLM

Hi Zack, thank you very much for your response! I do know I can do it that way but it adds extra steps that I was hoping to avoid so my question is if data 'inheritance' from a selected record in a linked table is possible in Airtable, either from the data table or interface?  I used to develop applications in Lotus Notes which had this inheritance functionality built in. 

Attachment:
Red comments are the steps to create the application record.
Black arrow is item that is 'inherited' from job record to application record.


I ended up using automation to imitate the 'inherit' functionality.

3 replies

Zack_S
Forum|alt.badge.img+17
  • Inspiring
  • August 31, 2023

Hi @DLM - Yes this is possible.

In the Applications table create a lookup field from the Job List and select the job title.

https://support.airtable.com/docs/lookup-field-overview


Forum|alt.badge.img+6
  • Author
  • Inspiring
  • September 11, 2023

Hi @DLM - Yes this is possible.

In the Applications table create a lookup field from the Job List and select the job title.

https://support.airtable.com/docs/lookup-field-overview


Hi Zack, thank you very much for your response! I do know I can do it that way but it adds extra steps that I was hoping to avoid so my question is if data 'inheritance' from a selected record in a linked table is possible in Airtable, either from the data table or interface?  I used to develop applications in Lotus Notes which had this inheritance functionality built in. 

Attachment:
Red comments are the steps to create the application record.
Black arrow is item that is 'inherited' from job record to application record.


Forum|alt.badge.img+6
  • Author
  • Inspiring
  • Answer
  • September 12, 2023

Hi Zack, thank you very much for your response! I do know I can do it that way but it adds extra steps that I was hoping to avoid so my question is if data 'inheritance' from a selected record in a linked table is possible in Airtable, either from the data table or interface?  I used to develop applications in Lotus Notes which had this inheritance functionality built in. 

Attachment:
Red comments are the steps to create the application record.
Black arrow is item that is 'inherited' from job record to application record.


I ended up using automation to imitate the 'inherit' functionality.