Mirror column Api

Hello there @AartiKulkarni,

I am not sure I understand the question here, but mirror columns can not be updated via API.

Was that the main question?

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?

Hello again @AartiKulkarni,

Can you please show the configuration of your app and what you see in screenshots or a screen recording?

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.

Thanks for your support

I am glad our team could help you with the answer @AartiKulkarni !!

I would be glad if I could add a mirror column in custom action!! By the way, how do some other apps do this ?

like here they used a mirror column in custom action in a recipe.

Hello there @AartiKulkarni,

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.

Cheers,
Matias

Thanks for the tip!

Happy to help @AartiKulkarni 😀

@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”:

Hello there @eyalos,

Mirror columns are not supported by the native “column” field (source: Recipe sentence) from the integration recipes.

@Matias.Monday Hello,
Is it supported with other type of input?

Hello there @eyalos,

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.

What do you think?

Looking forward to hearing from you!

Cheers,
Matias

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.

Hello again,

Matias here!

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!

Thanks, @Matias.Monday for your detailed solution.

I’m replying here to monday.com team take Use mirrored columns for integrations/automation under consideration, as this would avoid misconceptions currently sentence-builders have.

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.

Is that the information that you needed?

Cheers;
Matias