Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: How to have a count based on the number of times the record is linked?

1405 0
cancel
Showing results for 
Search instead for 
Did you mean: 
ted_ellis
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m trying to set up a customer having multiple addresses.
So Table 1 is customer that contains the profile, then table 2 for addresses and I link the customer to it.

I want the primary record of Addresses to have a count based on how many same customers are linked to it.
image

Any leads?

1 Reply 1

Try the following method using Automations.

  1. Add a number field.
  2. Create an Automation that is set to run when {Customer} is not empty, or when the value of {Customer} changes.
  3. Add an Find records action step that looks for records in the same table with the same {Customer} field value
  4. Add an Update record action step that fills in the {Number} field with the “List properties - length” of the Find records step’s return value