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.

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

Topic Labels: Formulas
2041 1
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