Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Inherit data from selected record into a new record

Topic Labels: Base design Data
Solved
Jump to Solution
1891 3
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.