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

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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

    Like
    • André P.
    • Andre_P
    • 2 yrs ago
    • Reported - view

    Any news on the plans to implement this function?

    Like
    • info
    • info.22
    • 2 yrs ago
    • Reported - view

    +1

    Like
    • info
    • info.22
    • 2 yrs ago
    • Reported - view

    +1

    Like
    • erik
    • erik
    • 2 yrs ago
    • Reported - view

    +1

    Like
    • erik
    • erik
    • 2 yrs ago
    • Reported - view

    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

    Like
    • Tarek
    • e2e | dirkbraun.consulting
    • Tarek
    • 1 yr ago
    • Reported - view

    Any news on this?

    Like
    • Lisa Hinkel
    • Cascade Cuts
    • Lisa_Hinkel
    • 1 yr ago
    • Reported - view

    +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?

    Like
  • 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")
    end

    add code and exit cell 

    as said its far from perfect 

    I could refine it clear the cell after entry etc

    Like
Like Follow
  • 1 yr agoLast active
  • 9Replies
  • 1823Views