Auto-ID column (we need to be more useful)

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.

This items were created:
25/11 01:28PM
25/11 01:30PM
26/11 08:47AM

The item in the middle has no autoID value…

what could be happing… this is critical to us…

Happy holiday season :slight_smile:

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.

3 Likes

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.

1 Like

AutoID Column (https://auth.monday.com/oauth2/authorize?client_id=1b56a65b7fd999693e15d39973646c21&response_type=install) now supports an additional recipe which will generate an AutoID on status change.

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.

Have fun with it.

1 Like

For those who have previously installed and working this app.
These new recipes will be avaliable, i mean there is no need to install again dont?=

Correct, no need to reinstall… I know monday is working in app reinstall and version control but it is not there yet

1 Like

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 @basdebruin

Currently on trial mode with autoID app. Have you considered adding “link to item” column to {columnid} options?
It’s also basically a text column.

I’m afraid we are not able to use the app without this feature.

Thanks for your work

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:

{id}-{project-type}-{customer-name}-{year}

Let me know if you need more info

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

image

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:

          {
        "value": null,
        "id": "customer",
        "title": "Customer",
        "type": "lookup",
        "text": "Let's Do IT, ABC Company"
      },
      {
        "value": "{\"linkedPulseIds\":[{\"linkedPulseId\":600690019},{\"linkedPulseId\":600685009}],\"changed_at\":\"2021-02-19T19:16:30.893Z\"}",
        "id": "connect_boards0",
        "title": "xxx",
        "type": "board-relation",
        "text": "Consulting Service, 3 x laptop + accesories"
      }

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 :slight_smile:

Hi @basdebruin

yes i’m referring to “connect boards” column (as described [here])(Connect boards column (Previously Link to item column) – Support))

Here I made a mockup of what we need:

But we could also double the name in mirror columns if needed, as shown here:

Let me know if everything is clear now.