Thank Matias for your reply.
Yes , i was checking for mutation also.
We could not mutate mirror columns, but we can read mirror column values . But when i tried to add mirror column in custom action fields for custom recipe, field as column & restrict as mirror, it doesn’t show any column while adding recipe.
Could you suggest some thing about this?
Hi Matias,
Some day before i have also raised ticket about same (ticket id:#3338191).
They suggest then to check in developer community, so created topic.
But today I got a response from them as currently it’s not possible.
One option to do this would be to have a custom field of type list that has the boardId as a dependency. When the user clicks on the field, an endpoint on the app’s end is called and the board ID is sent there. With that board ID, the app can query for the mirror columns in the board and display them in the list.
@Matias.Monday I also have this issue when configuring my input fields of a custom action.
When adding automation of my feature, when selecting the column from the sentence builder, there’s no available columns, even though the board contains mirror columns from other board, in the following screenshot the “ffffff” (sorry for the name…) is the input column with allowed column types “Mirror”:
You can use the “column” field with multiple other columns like a people column, status, date, and many more.
But I believe you want to use a different field for the mirror columns, correct? If so, what do you need from them? If you need to get the ID of the selected mirror column (like you would with a regular “column” field), you can use a custom field of type “list” that comes from an endpoint on your end. You would need to make that custom field dependent on “boardId”. Then when the user clicks on this custom field while configuring the recipe, your endpoint would be called and we would send you the ID of the board. You can then use the API to query for all the columns (of type mirror, other types, or all of them) and display them as options for the user to choose from.
My specific need is to get the value from a mirror column “pointing” to a column of type Email.
Your suggestion is doable, but require some work, which for me should be “out of the box” Monday behavior.
It also not flexible, because I would like the user have the option of picking a column of type Email, mirror or regular one.
You can use the mentioned flow and only show the columns of those specific types when you send the list to the user.
Then when the recipe triggers, you would get the item ID of the item that triggered the recipe. And then you can use that item ID and the selected column ID to get or change the column value!
Hey @Matias.Monday,
I’m trying to do this but can’t get the boardId. How can I get it? Must use it in the trigger to succeed in doing it?
I want my trigger to be: When status changes to something.
Thank you very much!!
Hello there @Liam_Yep and welcome to the community!
If you need to get the ID of the selected mirror column (like you would with a regular “column” field), you can use a custom field of type “list” that comes from an endpoint on your end. You would need to make that custom field dependent on “boardId”. Then when the user clicks on this custom field while configuring the recipe, your endpoint would be called and we would send you the ID of the board. You can then use the API to query for all the columns (of type mirror, other types, or all of them) and display them as options for the user to choose from.