Automation to Copy a Parent Record Value to Child Table Field

For the following simple database example:

Table called EMPLOYER with the following fields:
EmployerName, Employees, Country.

Table called EMPLOYEES with the following fields:
EmployeeName, Employer, Country.

Required AirTable automation:
When EMPLOYEE/Country is Empty, copy the EMPLOYER/Country value to the Employees of each EMPLOYER.

How would you setup the automation?

If they’re linked fields you could just use a lookup field to pull over the EMPLOYER/Country value into the EMPLOYEES table, and use a formula field to display the appropriate country, something like:

IF(
  {Employee Country},
  {Employee Country},
  {Employer's Country}
)
3 Likes

Thanks Adam.

In most cases the EMPLOYEE is at the same country of the EMPLOYER, and so your solution would work for most of them by displaying the country in common.

However, we just want that the EMPLOYEE (child record), inherits the CountryName when its CountryName record is Empty.

When the EMPLOYER is for example in the US, and the EMPLOYEE in India, we would like to be able to be able to manually amend the result of the automation from US to INdia.

Hmm, think we might be having a bit of a miscommunication. Here’s a screenshot of the setup I’m referring to:

1 Like

Hi Adam,

Many thanks for your help! :slightly_smiling_face:

I tried your solution above:
IF(
{Employee Country},
{Employee Country},
{Employer’s Country}
)

And it works well but it requires to “display” two fields on the table:

  • Employee Country (Manual input or Empty)
  • Employee Country Formula

Is there a way to do it with just one displayed field called “Employee Country” by using an automation?

I’ve tried but can’t find how to make it work…

If you’re really set on doing it via an automation, then you would preferably have a checkbox field that’s like “Set Country” or something.

You’d then link the employee to the employer record and then mark the checkbox. You’d make the automation trigger when the checkbox is marked AND the employee’s Country field is empty. The action would be to find the linked record, and then update the Country field with the employer’s country value

You can use other methods to trigger your automation if you’d like