Update request deadline

Options

Hello everyone,

Do you know if there is a time limit or expiration time to answer an update request ? Is it possible to set up this expiration time ?

Thank you very much !

Corentin

Answers

  • Thinh Huynh
    Thinh Huynh ✭✭
    edited 10/16/20
    Options

    Hi @Corentin Dal Farra,

    I got an idea that you may use lock row feature to stop user from editing after expiration date

    Step 1 : create a Due date in your sheet

    Step 2 : create an automation workflow to lock rows that reach the due date.

    In the below, you can see i will lock rows at 18:00 on due date

    After 18:00 on due date, users wil not be able to change the data on rows. They can view but can not edit the data in the update requests

    Hope it helps!

  • Corentin Dal Farra
    Corentin Dal Farra ✭✭✭✭✭✭
    Options

    Hi @Thinh Huynh

    Thank for your solution, I will try it to manage the update request expiration date limit.

    Corentin