Hello,

Is it possible to have a message with a choice if one wants to create a new record or not?

Thanks.

Pascal P. I try this:

if count(ID) > 1 then alert(“message”), but it does not work. Nor if sum(Id) > 1.

Pascal P. Is this in a button? Is this in a dashboard? Or in a data table? Are you checking another table or the current table?

Fred «Trigger on new record» of the current table.

Pascal P. It seems like it is a bit late to pop up a message after the new record is created, but let me answer your question.

Be aware that once you move your DB into the cloud for multi-user access then you need to know when and where actions execute. This page from Ninox shows you when and where actions execute. For your case, with the iPad app and a "local" DB, the Trigger on new record happens in your app. But if you move the DB to the public cloud then the actions happen on Ninox's server so you won't see any alerts() or dialogue().

Your script:

if count(ID) > 1 then alert(“message”) end

Doesn't work because

1. I'm not sure what ID is?
2. you are not counting the entire table only the current record

You can try:

let allRecs := select tablename;
if length(allRecs) > 1 then alert("message") end

But then you will always see this message when you create a new record. And it is after the new record has been created so it is too late.

You should look into dashboards/pages. If you want to control user actions you need to create a UI that allows you to take control.