Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Combine several records into one

Topic Labels: Automations
529 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone!
I need to combine several records into one so that records with the same key accumulated all linked records in one field. That is, the table looking like this:
2021-12-03_11h10_44
…would be transformed into this:
2021-12-03_11h08_16
Any advice is much appreciated.

2 Replies 2

Hi,

Create new empty table, link it to this table. Return here, and copy-paste primary field into new linked field here. Your empty table will be filled with the unique U1,U2… and links. Add “Elect…” field as lookup. Trasfer it to linked.

@Alexey_Gusev thanks for your suggestion, but I would like to avoid creating additional table. Actually, I already have a solution of my problem thanks to @JonathanBowen.