Stamp time and users

[Kuroshi]

I have an application where a client enters data and then an admin approves and submits it to the vendor. So when I checked the approved checkbox, and submit it, it will populate the table with the approver's email and the time that it has been approved. However, the main problem is, I only checked the approved checkbox and not checked the submitted and deleted checkbox but it is also populated in the table. Any idea?

[Barbie]

Hi, 

This might be a possible workaround for your workflow, I suggest that you create a CASE statement. You need to set the form element of 'Deleted ' 'Approved', and 'Submitted' fields to Calculated value and paste the statements below.

For Deleted: 
CASE 
WHEN [@field:Deleted]= 1
THEN '[@authfield:Client_Email]'
ELSE ' ' 
END

For Approved:
CASE 
WHEN[@field:Approved]= 1
THEN '[@authfield:Client_Email]'
ELSE ' '
END

For Submitted:
CASE 
WHEN [@field:Submitted]= 1
THEN '[@authfield:Client_Email]'
ELSE ' ' 
END

Once the user did not check the check boxes, it will not stamp the user's email. 

I hope this works for you.
 

-Barbie

[ParkLoey]

You may also want to try using triggered actions. I think there are conditional blocks there that you can use for cases like this.

https://howto.caspio.com/tables-and-views/triggered-actions/

 

[Flowers4Algernon]

Hello, you might wanna check out these links for more information regarding functions and calculated values:

1. https://howto.caspio.com/datapages/datapage-components/calculated-values/

2. https://howto.caspio.com/function-reference/