Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 26, 2022 08:20 AM
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
Solved! Go to Solution.
Apr 26, 2022 09:08 AM
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)
Apr 26, 2022 09:08 AM
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)
Apr 26, 2022 09:18 AM
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?
Apr 26, 2022 09:38 AM
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