step 1:
I have customer data in a google sheet where all of Column A is a ‘status’ field. I set the ‘status’ field to FALSE when I input data manually into the google sheet. My goal is to have the scenario automatically change the ‘status’ field to TRUE once the scenario is done. This scenario is scheduled to run once a day.
step 2:
Once the next day comes around and the scenario starts, I want be able to filter the google sheet document and ONLY fetch the data where the ‘status’ field is FALSE. This allows me to fetch and manipulate the data then repeat the process from step 1 which is to automatically change the ‘status’ field to TRUE once the scenario is done.
yes, this is how my scenario looks as of now. The problem i’m having is not being able to update the ‘status’ field in my google sheets once the google calendar event has been created. I only want to update the rows which have the FALSE ‘status’.
Is this a duplicate post from this thread?
I gave you a solution to bulk update fields there.
For step 2, you should think about adding additional search parameters for booth scenarios. When filtering only with status, scenario 1 and scenario 2 will use the same records without distinguishing which are from today and which are from yesterday.
