0

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
Like Follow
9replies
-
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