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.
