Create a File only once when condition is met

Good day,

I created a bot for an app that is scheduled every weekday to check data to see if a column is not blank (I have it set to trigger for each row in table because I need to change data in a following process). If it is not blank in a column, it creates a copy of the file and saves it, and the clears the data for the next day. If it is blank, it ends. 

However, it is creating a copy of the document every time the condition is met in each row. Is there a way to make it so that it  makes one copy after recognizing data in that column, and then stop after that? Or maybe another condition that works better? 

My goal is to only make one copy of the file if there is data present at all in a particular column (indicating that we used this app that day, and we can copy this file and clear it for the next day).

Thank you!

0 0 24
0 REPLIES 0
Top Labels in this Space