Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Superlog (audit trail system)

Featured Replies

Hello!!! Here I attach my table with a "custom function" (Superlog, by Nightwing) that logs all the changes I make in my table.

I have 2 questions:

1) How can I limit the log data? I mean, I only want to save the last 5 changes... I don't really know about this custom stuff... I'm too newbie :)

2) How can I set a calculation with the logged data... Here in my table I have a button that tells me the last modified record, and what was that change... but what I want to do is to find the changes I -the user I use is called Lucas- made, but not the changes done by the other user 'María' (I have this system in 2 computers)...

Well, I hope you can understand my bad English... Thanks a lot community, you're the best.

Base.zip

1) Why not just change the portal to only display the last 5 lines and sort by Date Mofified? You may have to remove the scroll bar if there is one.

2) Just do a multi field search. Date modified and Modified by.

Michael

Edited by Guest

  • Author

Thanks my friend for answering... but in the question 1, what I am looking for is to "not log" data, not only not showing it, because if it log all the changes, the size of the file.fp7 will be too big I guess... So what I want is to delete the change 5 (the oldest) when I make other change... do you understand me?

Thanks for trying to help.

Your file is password protected.

the name he used above will log in (María)

  • Author

Sorry... I have already changed the file... the users are 'lucas' -complete access- and 'maria' -only data entry-. Thanks for helping people!!!

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.