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

Automation copying only unique values from Table A into Table B

Topic Labels: Base design
354 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I’ve created a table that has a unique number for each Worker at each Site Visit working for each company. The unique number looks like this Wxxxx-SVxxx-Orgxxx.

I then have a formula field that removes the Worker ID and leaves SVxxx-Orgxxx.

I need to copy from that SV-Org field only the unique SV-Org numbers. I was trying to figure out a way to compare values across records, but I’m at wits end.

Any ideas? Could I do this via script?

Table A
image

Table B
image

0 Replies 0