Skip to main content
swapnar6405
Known Participant
Mar 8, 2023 2:13 PM UTC
Question

Looking to update status of the Master table Automatically.

Hi,

I have a database table called "Status" along with a CDT in Appian with the below list of values.

Also, I have an employee table with statuskey reference along with a CDT and while adding an employee using employee - add interface, I am saving the status as "1" (default). Also employee table is having loggedInDate.

statuskey status

1              Active

2              Inactive

3              Terminate

Can someone suggest what need to be done if I have to implement below requirement.

I have to mark the employee as “Terminate” if the employee is in inactive status for 30 days.

I have to mark the employee as “Inactive” if the employee is in active status for 15 days but not logged in(By looking into loggedInDate.

1 reply

stefanhelzle0001
Brainy
Mar 8, 2023 3:01 PM UTC

Interesting use case. Create a process model that starts once a day, checks records in that table, and updates them if needed.