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.

Automatically combine multiple fields with linked records into 1 field (keeping linked records)

Topic Labels: Automations Data Formulas
532 0
cancel
Showing results for 
Search instead for 
Did you mean: 
MCcork
4 - Data Explorer
4 - Data Explorer

Hi, I'm sure this question has already been asked but still can't find an easy answer. It seems as though it should be quite simple but I can't wrap my head around it.

As per the screenshot, I would like to automatically combine Linked Record entries from multiple fields into 1 field. The 1 combined field needs to keep this data as Linked Records, and not as formula text.

The  Linked Records are from another Table in the same base.

Screenshot 2024-01-18 101633.png

So basically, if this automation or formula was setup properly - the "ALL COMPLETED PROJECTS" field would contain 3 Linked Records: "Pen", "Pal" and "Pol".

Is this possible?

0 Replies 0