Hello Guys
Need some help. I am trying to run a schedule in add row and copy value it does not seem to work however manually trigger actions it works.
This is the ACTION
This is the BOT
And this is the table. The key is [TIMESTAMP]
Is the app deployed? Scheduled bots won’t run if the app isn’t deployed.
What does the automation monitor tell you?
Does the slice have any rows at the scheduled run time?
1 Like
Ignore my previous reply.
Your use of a timestamp as key is the problem. Never use a timestamp as a key. Use UNIQUEID().
1 Like
When the bot runs, all rows are processed either at the same time or within a very short period of time, so every row added will have the same timestamp, overwriting each other. Only one new row will survive.
2 Likes
hi Steve
OK now I use the Report ID as unique Key and I manually run the action the first row shows actions is working. But running the schedule bot still nothing happen
1 Like
Then back to my original reply:
Is the app deployed? Scheduled bots won’t run if the app isn’t deployed.
What does the automation monitor tell you?
Does the slice have any rows at the scheduled run time?
The apps is deploy and the automation report is attach. I don’t know how to read this thing. But when I put a filter there is mysteriously become working. It working now and it append at the bottom nicely without delete any row
I don’t know what you mean by “I put a filter there”, but I’m glad it’s working!
1 Like
IF(
OR(
TIME(NOW()) >= “17:00:00”,
TIME(NOW()) <= “04:00:00”
),
AND(
[SHIFT CODE] = 12,
[LOCATION NAME] = “MY AT1”,
NOT(
IN(
[EMPLOYEE ID],
Clock In AT1[SCAN IN BADGE ID]
)
)
),
FALSE
)
Your earlier screenshot showed a filter condition of TRUE:
You’re telling me TRUE didn’t work but this new expression does?
Yup and I don’t know why and I also don’t what I am doing. I am not good in schedule BOT
Very weird! At least you’ve got something that works!
1 Like