LinkedIn
Twitter
Hi Experts
Is there a feature in appsheet automation to update CAL CODE column to 3.1 base on the CALIBRATION TRIGGER ALERT DATE base on today date?
Solved
2 ACCEPTED SOLUTIONS
Your bots setting could be something like below.
Please set the Time Zone and bot schedule time as you want for the daily bot.
In place of Table setting , please add the table name you have.
In place of Filter condition , please add the slice expression you referred above or whatever different you desire. I have not exactly understood what records you need to select in the slice for changing [CAL Code]
AND(
DATE([CALIBRATION TRIGGER ALERT DATE]) <=TODAY(),
[CAL CODE]<>13.2
)
Your bot step could look something like below.
Set the value of [CAL CODE] as you wish.
True. I am thinking of that too. In fact I have done one similar to this just submit form and update column value. But in this case is a time base situation and this is the first time I do timebase automation. I need to understand properly. The slice I have completed and the slice is related to AlekSiaLkio CALIBRATION CONCLUSION="FAIL". And this FAIL is send to the current table we dicusss as code 13.2. I manage to filter that off. If you see source table row role 536 is filter in the slice. 13.2 code mean FAIL and they need to be removed in the process of list over over duel tool under the code 13.1. This is the slice expression AND(
DATE([CALIBRATION TRIGGER ALERT DATE]) <=TODAY(),
[CAL CODE]<>13.2
)
Slice
Your bots setting could be something like below.
Please set the Time Zone and bot schedule time as you want for the daily bot.
In place of Table setting , please add the table name you have.
In place of Filter condition , please add the slice expression you referred above or whatever different you desire. I have not exactly understood what records you need to select in the slice for changing [CAL Code]
AND(
DATE([CALIBRATION TRIGGER ALERT DATE]) <=TODAY(),
[CAL CODE]<>13.2
)
Your bot step could look something like below.
Set the value of [CAL CODE] as you wish.
Both, Suvrutt Gurjar & AleksiAlkio..... Than you both sooooo much. I pick the simpler direct Action and Bots method. I have 3,732 rows currently and this row will increase slowly. This is not an active database and probably increase 5-10 rows in 2 weeks. I pick 1am as my firing time because 1am the whole company is shutdown. I also change the filter expression. The expression written by me does not include those blank column. To the expression this is TRUE but to me its not true because 3,732 tools not every one of them need calibratrion. CAL CODE 13.2 is what I told AleksiAlkio in the easier post. CALIBRATION CONCLUSION='FAIL' is translated as a code to this database. 13.1 a code for overdue calibration date. 13.1 is to filtered the user from scanning tool bar code and 13.2 is to backfalsh tool to scrap system. This is the expression
AND(
ISNOTBLANK([CALIBRATION TRIGGER ALERT DATE]),
DATE([CALIBRATION TRIGGER ALERT DATE]) <=TODAY(),
[CAL CODE]<>13.2
)
I don't even need a slice !
