Skip to main content

Trying to auto create a unique key in a table used for tracking grazing on a cattle farm.

So my current formula is

“(Pasture & DATETIME_FORMAT(Date, ‘M/D/YYYY’)”

Where “Pasture” and “Date” are both fields in the table.

Any help?

By putting the whole formula in quotes you’re telling Airtable to literally type “DATETIME_FORMAT” and not process the function. If you take the quotes and parenthesis at the beginning away it should work:


Pasture & DATETIME_FORMAT(Date, 'M/D/YYYY')

If you want to add a space between the two:


Pasture & ' ' & DATETIME_FORMAT(Date, 'M/D/YYYY')

If needs unique number you can use recordID


Pasture&’ ‘&DATETIME_FORMAT(Date, ‘M/D/YYYY’)&’ - ID=’&RECORD_ID()

Reply


Terms & Conditions