0

Restrict Duplicate entry

Hello,

I need help from you people. I have a code in a field (Record ID) in "trigger after update". It works to delete a new entry if it has the same ID. Code is given below: 

let myField := 'Record ID';
if cnt((select 'References to Nethunt Deals')['Record ID' = myField]) > 1 then
delete this
end

The strange thing is it is working for other tables but in this table, it is not working. If you need more info then I am available for that.

2 replies

null
    • Dev_twentyZen
    • 2 yrs ago
    • Reported - view

    Is there ANyone who can help me with this issue?

    Waiting for a reply in this forum.

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Hmm...  if you say it is working on other tables but not just one of them.. 

    I would suggest you send it into support@ninox.com and ask them to do a dial in to look at?

Login to reply

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 190Views