I am trying to automate the process of sending emails to contractor to invite them to tender for a project, however the contractors details are stored on an alternative board.
Currently I am try to use a connected board columns to select the contractors and then using the mirror fields to populate the email addresses however, In automations I have got as far as when a column is updated, send an email but there is no option to use the mirror field as the sender, yet it is available to add within the email body. The connected board field also doesn’t show up in the email body or email field.
Can anyone let me know of any work arounds for these issue.
In my opinion these are necessary features, as it is not feasible to store all this information in one board.
Hi. I advice you to consider VLOOKUP marketplace app - An alternative to monday mirror columns that can use for automations, reporting and more. You can see a comparison table here.
Glad to see you’ve had some help - how did you get on with VLOOOKUP? Did you try it?
I caught your post and thought I’d let you know about an app in the Marketplace called ‘Column Magic’. If you search for it, you’ll see you can use their free plan for up to 1000 actions/‘sparks’ per month, which should accommodate what you’re trying to do.
Essentially, this app would let you copy the content (reflection) of your mirror column and put it into a text column, which the automations can read. The recipe looks something like this:
I have implemented this but this doesn’t seem to be the best work around for me, as the target column needs to match the source column exactly to populate the target column value. This is unlike a connected board where it brings up a search bar and you are able to type a few letters before selecting the option you are looking for.
Being that i don’t always know the source column (item name) exactly, it relies on me looking up the fields within the source column board and if I am doing this, I may as well copy and paste it into the relevant fields.
Now I don’t know if I have implemented it wrong or if there is a work around but in its current state I don’t see this being usable for me unless I am able to pull the information from a connected board or it having the ability to provide the same function in some way.
