Update a field in a record automatically

[Tyler_Jollymore]

So, I’m wanting to make an automation where when a new record is added, a custom ID is automatically assigned to that record that is prepended with a tag.

So for instance, when a new record is created, it will automatically get assigned an ID like “FR-[date][number]”. So if multiple records were created today, it would look like:

“FR-2022042601”
“FR-2022042602”
“FR-2022042603”

and so on.

not sure if this is possible, but any help would be immensely appreciated

[TheTimeSavingCo · Accepted solution]

Hi @Tyler_Jollymore, I’ve thrown something together here

I ran with the assumption that you needed it to be 1, 2, 3, 4 etc. Do let me know if I made the wrong assumption as I’ve set it up to get the number of records created today in order to generate that number, and removing that functionality would save us one automation run

Could you duplicate the base and see whether that’s what you’re looking for?

(You’ll notice there’s an issue with a leading 0, but I can’t think of a way to solve that issue without script functionality unfortunately)

[Tyler_Jollymore]

looking at the base you made, it does seem like it will be what im looking for. I’m just trying to figure out the “formula” part from your table so that I can include it to mine. Also, will hiding the “created date” field affect the automation?

[TheTimeSavingCo]

Ah, the formula’s just for changing the text display of the created date to look more like your example, which is in turn used by the automation.

–
re: hiding the “created date” field
Nah, hiding it won’t affect the automation