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

Topic Labels: Automations Data Formulas
208 0
Showing results for 
Search instead for 
Did you mean: 
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