
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 29, 2021 08:13 PM
Try the following method using Automations.
- Add a number field.
- Create an Automation that is set to run when
{Customer}
is not empty, or when the value of{Customer}
changes. - Add an
Find records
action step that looks for records in the same table with the same{Customer}
field value - Add an
Update record
action step that fills in the{Number}
field with the “List properties - length” of theFind records
step’s return value
