0

Script: test for null or empty'

I want to say:

if This Field is empty

then do this

else do that

end

How do I test for 'empty' I thought I'd seen reference to 'null' in the manual but I'm learning about the manual....

11 replies

null
    • Davie
    • 2 yrs ago
    • Reported - view

    Think I worked it out

    if Folder.Book = null then
    " "
    else
    Folder.Book + "/" + Page
    end

    Seems to do what I wanted!

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Perfect

    or if folder.book != null then (note the pling!!)

    Null is essentially blank or " "

    Ninox is sometimes a bit funny in places

    so if Folder.Book = Null won't work try an alternative like if folder.book = " "

     

    You can also test other conditions ie if x is less than 0 etc. or less than or equal to zero

    if  x < 0 etc 

    if x <= 0 etc 

    You can use "void" which does nothing!

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    full blurb from master Ninox Ref

    Screenshot 2022-01-17 at 15.07.45

    • Davie
    • 2 yrs ago
    • Reported - view

    Silly question: Where do I find the Master Ninox Ref?

     

    Do I not have access because I'm not paying monthly?

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    you email support  - support@ninox.com

    and ask them to give you access to the Webinar EN2022 system

    there are manay user test Apps on there etc the main ref is called 0001_Ninox Reference (note it is a master so must not be altered - but you can download a copy)

    I don't know if it is for subscription members only as I have always been a paying memeber as I operate multi user and my business production systems are on Ninox cloud.

    • Davie
    • 2 yrs ago
    • Reported - view

    I've asked!

    • Davie
    • 2 yrs ago
    • Reported - view

    FFS

    • mail.3
    • 2 yrs ago
    • Reported - view

    Thanks for the top tip Mel, I now have a download of 0001_Ninox Reference. But don't think having this will stop my daft questions!

     

    [BTW sorry for the rude TLA above, support have deleted the very long spam posting it refered to.]

    • mail.3
    • 2 yrs ago
    • Reported - view

    User system here isn't great, is it! No wonder for all the spam posts...

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Davie - Now I know I am getting old - err what is FFS?

    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    Oh - I think I have worked it out !