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 agoWed, October 9, 2019 at 12:27 PM UTC
    • 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 agoWed, October 7, 2020 at 9:03 AM UTC
    • Reported - view

    Any news on the plans to implement this function?

    • info.22
    • 4 yrs agoFri, October 23, 2020 at 5:44 PM UTC
    • Reported - view

    +1

    • info.22
    • 4 yrs agoFri, October 23, 2020 at 5:44 PM UTC
    • Reported - view

    +1

    • erik
    • 4 yrs agoThu, November 5, 2020 at 6:38 PM UTC
    • Reported - view

    +1

    • erik
    • 4 yrs agoThu, November 5, 2020 at 6:50 PM UTC
    • 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 agoSun, May 2, 2021 at 5:18 PM UTC
    • Reported - view

    Any news on this?

    • Cascade Cuts
    • Lisa_Hinkel
    • 3 yrs agoSun, May 2, 2021 at 9:15 PM UTC
    • 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 agoMon, May 3, 2021 at 10:10 AM UTC
    • 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
    • 6 mths agoTue, September 17, 2024 at 5:28 AM UTC
    • Reported - view

    +1