I donโt know what wrong I did
There is a comma after the second condition within the AND() statement that shouldnโt be there (since there is no third condition). Try removing the comma and see if it triggers successfully.
In fact, the comma is not present in the code, i just write it here by mistake
DAY(TODAY())
: Todayโs day of the month.
I would check if the week no is same and weekday(today())-weekday([Last_change_date])>4
I have tested the condition it works fine but still nothing happens I donโt know way
Please Help
I have attached a PDF with a detailed explanation of everything I have done
Automation.pdf (135.5 KB)
Table: S_Req
Req_id | First_useremail | Date | Req_status | R_end_userename | Last_change_date |
---|---|---|---|---|---|
123 | Benjamin @test.com | 24-3-2021 | Available | ||
124 | James@test.com | 28-3-2021 | In negotiation | 4-4-2021 | Ethan@test.com |
In 28-3-2021 the user(Ethan@test.com) logged in
and changed (record: 124) from Available to (In negotiation)
now the user(Ethan@test.com) have 4 Days to close the deal
if deal is not closed within 4 days the app automatically should change [Req_status] back to โAvailableโ
I tried to implement it through the following
Bots:
Schedule to first event
Events:
Schedule the change
Event type: Schedule
ForEachRowInTable: true
Table: S_Req
Filter Condtion
AND(
[Req_status] = โIn negotiationโ ,
(day(today())-day([R_end_userename]))>5
)
Schedule: Daily
Time : 12:00Am
Time Zone (Arabian Standard time)
Process:
Set [ Req_status ] to โ Available โ
Task to run: Change Data
Action to run: set row values
Set these columns: [ Req_status ] = โ Available โ
Tasks:
Set [ Req_status ] to โ Available โ
Task category: change Data
Task name: Set [ Req_status ] to โ Available โ
Table name: S_req
Data change action name: Set [ Req_status ] to โ Available โ
Note:
Test: Works Fine
Process: Works with no Errors
Can any of you tell me what I did wrong?
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |