I am working on creating an inventory management app and the main thing we wanted to accomplish was automation of an “Order” column which is where our store managers can input the quantity of a item they need at the store. We deliver their order the following morning, and usually we (at the office) reset their order column on the Google Sheet. The issue is sometimes we forget to reset it and the store managers are not able to re-order on time.
Is it possible to create a workflow that is scheduled, instead of triggered by an event, that can change the data of the “Order” column at a specific time? It looks like Workflows are only event triggered, and Reports cannot change data.