Add row to other table is updating instead of adding!

[_Excelrati]

I have an events bookings table and I'm trying to create a log table that would document the user actions of add/update/delete to it.

This is the table I created for the LOG:

I'm trying to test this using a very simple action that is displayed prominently:

When I clicked on this action the first time, a new row is added to the LOG table which is fine.

But from there onwards, any additional click on the action, the same entry is updated. So basically the LOG table has a single row!

How can this be possible?

[scott_robinson · Accepted solution]

It's because you're using Today() as the Key field in your table.

This will always be the same value whereas you wish to have a different value.

Change the key to be datetime instead of date and use Now() as the default formula instead of today()

[_Excelrati]

Oops. My bad 🤦🏻

Thank you so much for the reply!