Insert Data Into Log File (Table)

[bbeshlian]

Hello,

How would I capture the User ID from my Authorized User Table to insert into a log file (table)? When an authorized user Inserts, Updates or Deletes a record to table I need to capture their ID and the Time. I know how to set up the trigger for this. My issue is capturing the logged in User ID.

Thanks,

Bill 

[Glitch]

Yes, this would be doable via trigger. 

As you mentioned, you know how to set the trigger up. 

It should be something like this right? But you need to pass a value from the inserted to the log file table.

 

How about implementing this to your table?

https://howto.caspio.com/authentications-and-connections/authentication/stamp-a-record-with-user-profile-data/

https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/

Then you can easily pull up that stamped user ID and pass it via trigger?
Does that make sense?
Hope this helps 

 

 

[bbeshlian]

This is what I was looking for. Thanks!