Change status field after review time expired

  • 1.  Change status field after review time expired

    Posted 06-28-2020 09:05
    Edited by Syaeful Bahri 06-28-2020 09:06

    Hi all,

    I have table as below

    Text field: Request
    Multiple choice field: approved (no and yes)
    Date/time field: approved date (dynamic form > when the record is save and approved is equal to yes, change approved date to current date time

    Multiple choice field: Review status (expired review, successfully reviewed)

    When the approve field is approved and approved date change to current date/time for example 27 June 2020 07:00 AM, i want to setup 24 hours expiration for for review, so after 24 hours the status field is not changing, the review status will be expired status. Also if it’s possible to setup reminder for example 6 hours before expired?

    Many thanks

    Syaeful Bahri