0

How to Track Client Changes in Ninox (Audit Log Table)

Hello everyone,

I am trying to create an Audit Log Table in Ninox to track changes made to a machine registry table.

Objective:

Every time the associated client changes for a machine (which I lend), I would like to record the following information in a separate table:

1️⃣ When a client stops using a machine:

  • Machine ID
  • Old Client ID
  • Rental End Date

2️⃣ When a new client starts using the same machine:

  • Machine ID
  • New Client ID
  • Rental Start Date

Additional Requirement:

If a record for the previous client already exists, I would like to update only the Rental End Date, avoiding duplicate entries.

Question:

What is the best way to implement this logic in Ninox? Has anyone encountered a similar situation and can share some advice?

I truly appreciate your support and the time you dedicate to helping.

Mauro

5 replies

null
    • Fred
    • 1 mth ago
    • Reported - view

    Are you doing the data entry in the machine registry table or in a dashboard?

      • mauro_ninox_user
      • 9 days ago
      • Reported - view

       

      Hi Fred,
      thanks for your reply!

      The data entry is done through a dashboard — specifically in a table called "Activities"
      Inside this table, we use subtables (subforms) where we select the machine from the "Machine Registry"

      So the client change doesn't happen directly in the machine table, but through the activity records.

      Do you have any advice on how to best trigger the audit log from this kind of structure?

      Thanks again!
      Mauro

      • Fred
      • 9 days ago
      • Reported - view

      Can you post a sample DB with some sample data?

    • Fred
    • 2 days ago
    • Reported - view

    Here is my take on your question. I think the trick here is to track the recordID of the Activities record and the Audit record. Why? So you don't have to do a select when you need to update the Audit record. You can just use the record() command. This will speed things up in the future when the Audit log is tens of thousands of records.

    MachineTracking.ninox
      • Fred
      • 2 days ago
      • Reported - view

      In the Date Entry page, there is a Check Out tab and a Check In tab.

      In Check Out, select a date, customer and machine then click the Check Out button. You will see the records are created in Activity and AuditLog.

      In Check In, you can select a date or leave it blank and it will use today's date. You can then select one or more of the checked out machines to check in. You will see the End date updated for the appropriate records.

Login to reply

Content aside

Categories

View all topics
  • 2 days agoLast active
  • 5Replies
  • 54Views
  • 3 Following