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

10 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    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

    • Andre_P
    • 4 yrs ago
    • Reported - view

    Any news on the plans to implement this function?

    • info.22
    • 4 yrs ago
    • Reported - view

    +1

    • info.22
    • 4 yrs ago
    • Reported - view

    +1

    • erik
    • 4 yrs ago
    • Reported - view

    +1

    • erik
    • 4 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

    • e2e | dirkbraun.consulting
    • Tarek
    • 3 yrs ago
    • Reported - view

    Any news on this?

    • Cascade Cuts
    • Lisa_Hinkel
    • 3 yrs 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?

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    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

    • Wolfgang_Hopfgartner
    • 2 mths ago
    • Reported - view

    +1

Content aside

  • 2 mths agoLast active
  • 10Replies
  • 1875Views
  • 1 Following