Jump to content
  • 0

Stamp time and users


Kuroshi

Question

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?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...