Hello,
I have a requests, for the Mail automatisation.
With a Google Mail, I would like to create this automatisation.
I would like to choose a Email ( Column ) , but I cannot selected the Miroir Column… Why ? it’s a big problem for my job.
Thank’s a lot.
Toma
@Tshoxoma Welcome to the Monday Community!
The ability for Mirror columns to be used in Automations have only recently been added, but its still a limited feature.
There is a simple workaround that I currently use for multiple automations identical to yours! You will need to install the app General Caster from the App Marketplace. It works similar to the formula column except it process outside of Monday and send the results to basic columns. So in this case, you will have the Integration send the email from your Mirror column to a text column of your choice and then you can use the Text column in your automation!
Hope that helps. If you need more info or help to set this up, just let me know!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
I think the workaround suggested by Andrew could also be achieved with the VLookup app as well.
Let me know what the formula would be to do this with General Caster, please!
If you are just casting an email from a Mirrored column to a Text Column, the formula field only needs to consist of the columns General Caster placeholder, no functions required.
There are three ways to refer to columns:
{pulse.columnId}{item.columnId}{item's Column Name}Hope this helps!
Hi @zacheryy – I am having some trouble figuring this out, but it’s exactly what I need!
I am trying to go from [mirrored column that includes an email] → Text Column copying that email into text form
Should I use the {item.columnID} here?