Alert in cloud version not working?
Im doing this at Table level update trigger, but there is no alert showing up. Whats the trick?
let checkthis := NameField;
if cnt((select Customers)[NameField = checkthis]) > 1 then
alert("Customer exists already.");
NameField := null
end
-
Hi Viggo,
The alert does only work in triggers after open in the Ninox App. We are already have planned to make it also work on the triggers in the browser version. Thank you for your patience.
Kind regards, Jörg
-
Any news on the plans to implement this function?
-
+1
-
+1
-
+1
-
you may add a free text layout element with the alert text, then make it visible if NameField=null. looks terrible but might be useful
-
Any news on this?
-
+1. I just ran across this in a trigger I created. Could we get a time line on when this will show up in the browser version?
-
Yes I badley need too
howver I do this as a work around for now - not perfect as it shows dup on blank record but...
my customer unique ref field is Custid
add a forumula field
let a := upper(Custid);
if cnt((select Customers)[upper(Custid) = a]) > 1 then
styled("A/c Code is in use !", "red")
endadd code and exit cell
as said its far from perfect
I could refine it clear the cell after entry etc