How can I add a custom readonly column in the dynamic entity mapping(Like Jira column in Jira ticket)?

monday Apps & Developers
, ,
1

I would like to have a custom readonly field which will contain a link to an action item in our system. Similar to what Jira integration has with “Jira” column which contains Issue Id (See screenshot below).
How I can achieve that?

Jira field
Jira field801×809 30.7 KB

2

hi @Severyn

There is a “secret” column type that can not be added through the UI but only through the API. Example to create such column is:

mutation {
  create_column(board_id: 123456789, title: "Read only", column_type: integration) {
    id
  }
}

The columnId is returned. You need to refresh the board to see the new column.

Now, you can set the column value (only through the API) with

mutation {
change_column_value (item_id:987654321, board_id:123456789, column_id:"read_only", value:"{\"entity_id\":\"whatever you want\"}") {
  id
}
}

This will only work when there is no value in the column (aka write-once-read-many). The second attempt to write will not fail but the new value will not be written.

The user can’t change the column, but can clear its value. When the value is cleared a new value can be written through the API (once). I did not find a way to clear the column value through the API and I think that is intentional. The fact that the user can clear the column is in my opinion a bug.

DISCLAIMER: this is not documented and may change at any time :slight_smile:. I am not monday.com so use it at your own risk.

1 Like
3

@basdebruin Thanks for your answer!

4

This is very useful!! but the manual clearing should be clarified or fixed to avoid future surprises…