Jump to content
  • 0
Elderberg

Creating Audit Trail via Triggered Actions (inserting the auth user)

Question

Hi All,

i've created a Triggered Action based on insert/update to insert into an Audit_Trail_Log_tbl, but i'm stuck trying to figure out how to  include the user submitting the changes.

Im  stuck trying to figure out how to get the data that is suppose to go into "Updated_By_User" field.    I was hoping their would be an intuitive way to grab the Auth_User information.  Any suggestions would be appreciated.

image.thumb.png.6b58f87d9434c3c84cd504ae96edf57a.png

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

Hi @Elderberg,

 

As I understand, you want to get the name of the user who added or updated a certain record.  In order to get the information from the authentication, you must add another field in the Employees_tbl. On your DataPage, include the added field, set to Hidden and get the value from the Authentication details. Please see attached screenshots below: 

image.png.e7bb399a666646d5f41c432238e9b1ac.pngimage.png.5369d1f44f1b851895847a128b264421.png 

image.png.f79362d41ff3eadceefffcaaf599aba1.png

 

Hope this helps.

 

-kristina

Share this post


Link to post
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...