Discussions

Change status field after review time expired

  • 1.  Change status field after review time expired

    Posted 16 days ago
    Edited by Syaeful Bahri 16 days ago

    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
    ------------------------------