Hi @basdebruin
im seeing some kind of problem with the autoID app,
some of the created pulses on my board have the autoID and some other dont.
all of them are created via automations: in this case the last 3 created pulses.
NEW: As of December 24, 2020 you can enter fields in the text box (this text) in between curly brackets {}. Supported fields are:
{year} – the current year in 4-digit notation
{quarter} - the current quarter
{month} - the current month in 2-digit notation
{id} – the generated ID
When {id} is omitted the generated ID is appended to the end of the string specified in this text. This is the original behavior.
The field {columnid} can be used to replace this part of the string with the value found in the column with the entered columnid.
Warning : {columnid} needs to be the id of a text column (not the name of the column). You can find the columnids by activating Developer mode in monday.com. (Avatar > monday.labs > Developer mode > Activate).
Warning : the {columnid} field only works when the newly created item has a value in the specified column. This can be achieved with: using monday.com forms, using “Item default values” or by duplicating an existing item. When there is no value found in the specified column the field {columnid} will be ignored.
Another field added which you can put in the (this text) box
{no_overwrite}
This instructs the app to NOT overwrite existing items. It is created because in some use case this might be a good situation. Take care: this also implies that duplicating an item through the user interface will lead to duplicate ID’s.
There is also a new recipe for item creation, but existing users can still use the existing recipe for that. The difference is that both NEW recipes makes it easier for new user to backfill ID’s values to an existing board.
Forgive me if this has been addressed elsewhere but I feel like the next evolution of this tool is to incorporate an option to set the scope of the increment of the ID - i.e. Organisation VS Workspace VS Board VS Group.
Is this something the developers have considered?
I would just like to also re-iterate what all you have said, in that it seems pretty wild that Monday.com doesn’t already have a native solution for this feature request…
hi @peppinob do you need to just add the “link to item” column type as a field?
Remember that the {columnid} does only make sense when that column hold a value (text) at the time the AutoID is triggered. When the trigger is on new items and the {columnid} is not set with default values it won’t work.
Let me know what you exactly need and I will have a look.
Yes @basdebruin we have a “project types board” and a “customers board” linked to our high-level board with two “link to item” columns. In this latter board item name should be in the format:
hi @peppinob I did some checks and it is not possible to retrieve the data in a mirror column (type = lookup) by the API. So, there is no way an app “knows” the content of the mirror column. The reason is that the mirror column is “calculated” / rendered in your browser.
@basdebruin thanks for your check.
That’s true, i did also some test with integromat: retrieving the column value it just get “linkedPulseId” without text.
I see that if you query just the pulse id you get also “text” field for this type of column
But i can understand it could make everything pretty slow with a lot of unuseful data. As a workaround in integromat i found ok to get first “linkedPulseId” and then querying the text column value in the other board. Do you think it could work for our use case?
hi @peppinob We are talking different things here. What you show is the “board-relation” column type. That column holds the itemIds of the linked items, but it does not hold anything else then that relation. I was talking about the column type “lookup”. This column is a mirrored column that takes the itemIds from a “board-relation” column. It also holds a text value, which is indeed the name of the linked item / column. Let me try to explain:
The first one is the mirror column, the second one is the connected boards column. In this example the connected boards column has 2 linked items and the mirror column shows the content of the column values (comma separated) for the column specified in the mirror configuration and the linked items (2 in this case).
If you want just the text value as the field for the column “customer” (in the example above the first object) … this can be done.
I am just not sure we are talking the same things here
Then I changed the format to: {customer8}-{id} WHERE customer8 is a mirror column pointing to the connect boards column from above. Then I toggled the status to get fresh id from the new recipe and got this:
Remember: this won’t work on new item creation as at that moment your connect boards / mirror column is not filled in yet. You can still use it on new items if you set default column values (works for connect boards column, not for mirror obviously).
This sounds like something I’ve also requested a couple of times regarding job no. refs. It’s essential to be able to relay info, track jobs, invoices and so on. The Unique ID, which is always suggested to me is of no use at all, it might as well be a barcode!
The main criteria I suggested were:
Must ‘stick’ to an item/pulse for its lifespan
User-defined prefix/suffix
Incremental numbering from “1” or “00001” etc, we’d need several digit options or ability to choose a particular starting number like “Job_00357” (important for systems migrating to Monday, like ours)
This must be a free addition to the system (it’s a basic need)
This also allows users to sort columns on job number priority and the number refs could obviously have another use other than job refs.
Note. We migrated from Podio to Monday purely for ease of use and all the integration with popular apps. The previous system was great and did what I describe above with ease. This is only the really important ‘missing piece’ of an otherwise great system in Monday.com.