Help

Re: Inherit data from selected record into a new record

Solved
Jump to Solution
847 1
cancel
Showing results for 
Search instead for 
Did you mean: 
DLM
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
DLM
5 - Automation Enthusiast
5 - Automation Enthusiast

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

See Solution in Thread

3 Replies 3
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

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

DLM
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

DLM
5 - Automation Enthusiast
5 - Automation Enthusiast

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