Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Apr 29, 2021 07:23 PM
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.
Any leads?
Apr 29, 2021 08:13 PM
Try the following method using Automations.
{Customer}
is not empty, or when the value of {Customer}
changes.Find records
action step that looks for records in the same table with the same {Customer}
field valueUpdate record
action step that fills in the {Number}
field with the “List properties - length” of the Find records
step’s return value