I am currently trying to create a automated Unique ID for our company’s project request and proposal workflow board. The problem is not being able to cast a unique ID which I’ve created using a formula to combine 3 columns together. None of the integrations I have tried let me cast into the first item column. Any Ideas?
Also, does anyone know if Monday plans on making and incorporating an intuitive Unique ID system that allows to be used as the item (first column). I find it silly that this isn’t already an option.
How are you generating the “unique” part of the value? Is it something you need to have generated or something you already have and just need to get put into the name column?
Column Magic has a “Text Builder” feature that can combine columns into the item name column (first column). You just pick your columns, and any dividers between them, and it will write the combined text pattern to the item name. It can be used in custom automations as well.
(Gilles Cavin - Reinventing Formulas in monday.com)
You can with the Advanced Formula Booster. It allows you to create a formula that targets the item name. You can combine 3 columns together easily. The AFB even offers an autonumber feature. If you need help settings this up, please let me know.
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
The unique ID comes from from answers filled out on a form that is submitted and then I use a formula to combine those 3 answers in the format of “Property Code-Suite/Unit-M&R001” The issue is taking the computed formula and making it the first column to be its unique identifier.
Using Text Builder by Column Magic to cast items in the first column. However I ran into another issue. When forms submit, its not always casting the full formula and sometimes leaving off the tail end “M&R0001”
set your automation up to trigger off changes of the Unique ID column instead. Whats likely happening is you’ve got the AutoID and Text Builder both using “when item created” as separate automations. The Text Builder is “faster” than AutoID sometimes, so it is reading before the Unique ID column gets, but not always.
“When Unique ID changes, write text pattern to item name” would be the recipe you want to create.