How can I set a field to automatically search existing records for possible duplicates of the record I'm about to create?
Ninox Profile

Sorry, it should be...

 

if duplicate = "Yes" then

Ninox Profile

Ok, my brain caught up. The record has already been created, but the code won't let the duplicate information be entered. Here's a solution...

 

if cntFirstName > 1 and cntLastName > 1 then
let duplicate := dialog("Attention", "Create a duplicate record?", ["Yes", "No"]);
if duplicate = "Yes" then
'First name' := myFirstName;
'Last name' := myLastName
else
'First name' := null;
'Last name' := null
end

Ninox Profile

Sorry again! Please use something other than "duplicate" because that is already command in Ninox. You could use "confirm" 

 

let confirm := dialog("Attention", "Create a duplicate record?", ["Yes", "No"]);
if confirm = "Yes" then

Ninox Profile

Thank you! I’ll see if I can make it work!

 

Cheerio

Alex

Ninox Profile

Hi again! It was actually simpler than you thought - I just had to change 

‘First name’ := null;

’Last name’ := null

end

 

to

 

’First name’ := myFirstName

’Last name’ := myLastName

end

 

Thanks again!!

1 2
Reply