- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2023 12:07 PM
I've read the solutions for how to update a multiple select field without overwriting via automation. However, I have a bit of a wrinkle—this doesn't seem to be possible when using a Repeating Group.
The background:
I have a list of live performances in a table called Shows. I have a list of performers in a table called Artists. The two tables are linked via a Linked Record field so that Artists (one or more) can be added to specific shows.
Some Artists perform on shows year after year. I have a multiple select field in the Artists table for "Years Active."
The desired automation:
When an Artist is attached to a show, I'd like the "Years Active" field in the Artist's record to update to include "2024" in addition to any existing years already in the field.
The issue:
Normally, I would insert the current value of "Years Active" followed by a comma and then "2024." However, the only two fields I can insert are the record ID and name field. This seems to be a limitation of working within a Repeating Group. I'm hoping someone smarter than I can figure out a different way to approach this issue, or point out what I'm doing wrong. Thanks for reading!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2023 12:14 PM
Within your repeating group, do a "Find Records" action to get the current record that you want to process. The easiest way to do this is have a formula field with RECORD_ID(), and then search based on that field. Finally, in your "Update Record" action, pull the existing multiple select value for the record from the "Find Records" result.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2023 12:14 PM
Within your repeating group, do a "Find Records" action to get the current record that you want to process. The easiest way to do this is have a formula field with RECORD_ID(), and then search based on that field. Finally, in your "Update Record" action, pull the existing multiple select value for the record from the "Find Records" result.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 04, 2023 12:23 PM
Brilliant, that worked like a charm. Thank you so much, @kuovonne !

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 08, 2024 07:55 PM
Super helpful, thank you so much!
