SAVE button - Action

[jaichith]

Hi ,

Is it possible to check  a condition or run a action before saving the form and followed by action after saving ?

or

Is it possible join  an action along with form save event ? this should happen first and there after saving ? 

I need  the above functionalities for this post - How to avoid repeating/duplicates when multiple users use the app

Implementing the Locking Mechanism:

• Step 1: Create the LockTable

  CREATE TABLE LockTable ( Locked BOOLEAN DEFAULT FALSE );

• Step 2: Create an action to lock the table before saving

  appsheet

  UPDATE LockTable SET Locked = TRUE WHERE Locked = FALSE;

• Step 3: Create a conditional workflow that checks the Locked status before allowing the save

  appsheet

  IF( SELECT(LockTable[Locked], [Locked] = TRUE), WAIT, MAX(TEST[SL NO]) + 1 );