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:

When a client stops using a machine:

• Machine ID
• Old Client ID
• Rental End Date

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