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

Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Using a formula field to create a unique identifier

I currently use the following formula to produce a unique identifier in my my primary field: "PHDEV-" & {Fx_Year} & "-" & REPT(0,3-LEN(CONCATENATE({Fx_Autonum}))) & Fx_Autonum This works as intended, but I'm at a loss understanding how I might expand...