Hello,
I'm facing a problem with my app:
My app is composed of 2 tables: requests and output. The relationship is 1:n between these two tables and is made on column called "ODI" on both tables. The table "Requests" is updated and managed trough the appsheet app while dhe "Output" table is updated and managed on google sheet and in appsheet is set to "read only".
The table "Requests" have a column called "Stato" containing a 3 state cell (Finished, Unfinished, Working).
When a request is added the default "Stato" is set to "Unfinished".
When a job is completed the "Stato" is changed trough action to finished.
The problem is in between. I want the app to change the "Stato" column when a new row in "output" is detected to "Working" since the operators compiling the "Output" table update add rows daily on google sheet.
Right now i've tried this approach using a bot and the condition: COUNT(THISROW_BEFORE.[REF_ROW])<COUNT(THISROW_AFTER.[REFROW]) but i guess this conditions are cheked when data is added or update trought the app and not when data are added directly on a sheet.
Thanks in advance
LinkedIn
Twitter
