Thanks guys, this is where I’m stuck. I’m not totally sure how to move all of this to Appsheet without completing revising the app.
Essentially we enter a purchase order in Appsheet, and it adds a new row to a Purchase orders sheet in Google Sheets.
We have a PO Received column that populates Yes or No based on the spreadsheet equation:
=IF(NOT(ISBLANK(G133)), IF(AND((G133=H133),(J133=K133),(M133=N133),(P133=Q133),(S133=T133),(V133=W133),(Y133=Z133),(AB133=AC133),(AE133=AF133),(AH133=AI133)),“Yes”,“No”), “No”)
The receiver receives parts tied to the PO number and when all of the columns in the Purchase Orders sheet match, the value of PO Received changes to Yes.
When it does this, Appsheet doesn’t pick it up in order to generate a workflow. I know that I can use a report to get around this.
Now that issue I have is that I need to add a date received in order to filter my reports by date by Google Apps Script can run a trigger properly from a Yes value calculated from a formula.
All I want to do is generate a report once per day showing which POs have been received in the preceding 24 hours.
Any ideas of how to do this without completely revising the app structure?