I have a table in Airtable where I need to monitor changes in two specific columns
Currently, the automation is triggered when the Status column value changes to “Start.” Within the same automation, I have a route that needs to monitor the Review Status column. I want this route to activate when the Review Status value changes to “Reviewed,” and then proceed accordingly.
How can I set up two “Watch Records” in make.com to handle these scenarios simultaneously?
Just a few questions:
@LinkYourTech I am developing a proposal automation system using ChatGPT. When the status is set to “Start,” the automation begins. One path completes the proposal generation and saves it in the designated column, allowing the user to manually review it.
After the review, the user can update the “Review Status” column to “Reviewed.” Additionally, there is a “Need Revision” column where the user can enter any necessary revisions as long text. Based on this input, the system can generate new sections of the proposal and append them accordingly.
The router condition is based on the “Reviewed” status and the “Need Revision” column. If the proposal is marked as “Reviewed” and the “Need Revision” column is empty, it passes without changes. However, if the “Reviewed” status is set and there is text in the “Need Revision” column, the system will generate the required sections and add them to the proposal.
Sounds like you need to create two separate scenarios. There can only be one trigger per scenario so you can’t really have two different “Watch Records”. If you do however want two different triggers to be run into the same scenario you can create a scenario for each “Watch Record” and then use the HTTP module to make a request to a third scenario that will be triggered by a webhook to start the automation. But I think just building two scenarios makes the most sense in this situation. Hope this helps!
@LinkYourTech Thank you for your answer. It would be good if you could give me a demo scenario. I am currently unable to solve this problem.
Here is my Current Scenario which basically run automation for Status column value changes to “Start.”
I think the best thing to do for this scenario is to combine the “Status” and the “Review Status” columns into just “Status” with the selections being “Start”, “Needs Review”, and “Reviewed”. I shared a blueprint template for you to take a look at that outlines the basic structure you need to accomplish what you want. You might want to take a look into the training modules they have on Make to better learn all the tools available to you. Or maybe hire someone to help you build out what your looking for. Hope this helps!
blueprint (77).json (15.2 KB)
@LinkYourTech Thank you so the reply. Is there is an option to wait for some time in make.com?
Yes, its a “Sleep” module. But limited to 300 seconds. There are work around that let you delay it much longer that people have posted about it online. You can take a look at those videos/articles if you need a longer delay.
