New to Monday and trying to automate some of my processes. Many thanks in advance for any help.
I have a board that captures information from subcontractors via a form. Its pretty comprehensive and captures things like dietary requirements, qualifications etc. It also captures email and contact numbers.
I’m trying to create board to manage booking these contractors hotels and an automation that pulls in this data - name & email. and then use an automation to send these contractors details of their hotel booking.
Here’s where I get stuck - because the board pulls in the email from another board (crew email) - the automation tags don’t appear for these fields (crew email etc).
We’ve actually been dealing with this same issue with one of our clients, and just yesterday figured out a way around it without Zapier or Make.com. Here’s what we did:
Mirror the booking status column onto your Contacts board. Create one more status column on your Contacts board with “booked” as an option. Then, you can use this pre-built automation:
Make sure it is this pre-built one that says “Support subitems” underneath it, because it is the only one I’ve found that works with mirror columns. What you can do is use the automation to say “when [mirrored column] changes to booked, change [contact column] to booked.”
The next automation would live on the Contacts board, and would be the “when [contact column] changes to “booked”, send email to [email column].”
Let me know if that makes sense! We’d be happy to help set it up if you need.