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.
Hi Nir, I would love to have this app but unfortunately my company is severely restricting third-party apps because of security reasons. I heard that they have contacted the developer for this app but no one has responded.
In my main board, I have created a mirror column that has email addresses. The address will change according to the project (the email and the projects are on another board). I need to send automated emails to this mirror column but it looks like at this time there is no workaround at all, especially if I can’t use this app. Any ideas or insight would be helpful. I can’t imagine my group having to use a drop-down menu for every entry when in the past in Smartsheet all this would have been populated automatically.
