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

3 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
      • 4 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
      • 4 days ago
      • Reported - view

      Can you post a sample DB with some sample data?

Login to reply

Content aside

Categories

View all topics
  • 4 days agoLast active
  • 3Replies
  • 40Views
  • 3 Following