0

Reference of Functions and Language

Hi,

I understood the use of the select statement, but I need a confirmation, please...

1.
I can use the select statement with a not linked table too, from any table in the DB?
2.
The select statement run with data fields only, or with formula fields too?
3.
I have three tables; Table A, linked to Table B; Table B linked to Table C; I can use the select statement from the Table A to obtain the Table C data (the Tables A and C are not directed linked); is it correct?
4.
Can I receive a lot of example with a little DB, to understand better the "How to do", please?

Thanks for all
Best regards
Roberto
106replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi, is there a way to comment out some lines?
    Like
  • you can write e.g.
    ---
    let Comment: = "here is a comment"
    ---

    regards
    Leo
    Like
  • Hi all, is there a more complete function reference available? For example, I've seen an example with a Styled() function that I can't see documented anywhere. Thanks.
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    We are working on a new manual... At the moment find new features documented here https://ninoxdb.de/en/whatsnew

    Birger - Ninox Support
    Like
  • Many thanks. I'm loving the product so far and am astounded by its power considering how much it costs. :)
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    Hi, I wrote this function (it works) inserted in a function field called "Status Fattura" in a table called "Fatture" linked to a table called "Clienti":

    let a := text("EMESSA");
    let b := text("Inviata");
    let c := text("PAGATA");
    let d := text("SCADUTA");
    if 'Data invio a Cliente' = null and 'Data pagamento' = null and 'Data scadenza Fattura' > today() then
    styled(a, "", "", "printer")
    else
    if 'Data invio a Cliente' = null and 'Data pagamento' = null and 'Data scadenza Fattura' = today() then
    styled(b, "", "", "glider")
    else
    if 'Data pagamento' != null then
    styled(c, "green", "white", "moneybag")
    else
    if 'Data scadenza Fattura' < today() then
    styled(d, "red", "white", "warn2")
    end
    end
    end
    end
    end

    I would like to create in a new function field inserted in the "Clienti"(customers) table a code that "reads" the "SCADUTA" (expired) result of the previous function and makes the sum of all the records (connected to the same customer) that have the "Status Fattura" = SCADUTA (Status Invoice = expired). It's possible?
    Thx u so much
    Like
    • ideacco
    • ideacco
    • 4 yrs ago
    • Reported - view
    Hello, I really like this product.
    I am working on a database on currency exchange rates. You know, the exchange rate changes in real time, so I need to introduce an external API to adjust the exchange rate in real time. What should I do?
    Thank you
    Like
  • In the release notes I noticed a language function that you should be able to use...

    - Call REST services: http(method, url, header, body)

    There’s no other documentation than this I’m afraid, but it sounds like the beginnings of a possibility.
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    This is the first sign of bigger things to come :-)

    RESTful API coming to Ninox soon.

    Birger - Ninox Support
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    no reply?? :(
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    If you could send me ( support@ninoxdb.de ) a copy of the Ninox database you are working on (Main menu -> "Save Archvie as...") I'm sure that I can find a solution to your problem.

    Birger - Ninox Support
    Like
    • ideacco
    • ideacco
    • 4 yrs ago
    • Reported - view
    Very happy to know this news, the new version will be released at what time?
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    it will be released inside this half of the year.

    Birger - Ninox Support
    Like
    • jdub
    • jdub
    • 4 yrs ago
    • Reported - view
    Hi.

    now() returns UTC time and not my local time zone time. Is there a way to change this behavior?

    Best,

    John
    Like
    • jdub
    • jdub
    • 4 yrs ago
    • Reported - view
    Let me be more clear, when I use now( ) in a formula for setting field default values in a form it uses UTC. On a trigger:

    Time := now ( );

    That returns UTC. If I do the same thing in the "console" it returns local time.

    Best,

    John
    Like
  • Hi John,

    the now () function returns the current date and time. If you only need the time, you should use the formula

    Time := time (now ())

    Regards
    Leo
    Like
    • jdub
    • jdub
    • 4 yrs ago
    • Reported - view
    Leo,

    That did it for me, thank you! And thanks for the quick reply. Love your product.

    John
    Like
    • jasonacha
    • jasonacha
    • 4 yrs ago
    • Reported - view
    Hi. You may want to give me a helping hand with a puzzling behavior of 'like'.

    Here is a list of text records, say 'Dummy'
    1 AAR
    2 CBR
    3 AAR
    4 AAR:BZA
    5 NCG
    6 CBR:AAR

    Filtering the list in View:Filter 'like AAR' selects records 1-3-4-6, ie all records containing 'AAR'.

    This behavior is different when using 'like' in a Filtering Values context such as
    >Counting records 'cnt'
    cnt(Record[Dummy like 'AAR'].Any)
    this count records 1-3-4 but not 6
    >Selecting records
    select Record where Dummy like 'AAR'
    again, this selects records 1-3-4 but not 6

    Any thoughts? It looks as if the behavior of 'like' is inconsistent. I'd expect 'like' to behave like in View:FIlter, ie matching any record containing 'AAR' regardless of its text position within the record.

    Thank you for any help you may provide. Cheers, --Jaime
    Like
  • Hi Jaime,
    that's right, "like" in filters behaves differently than in triggers.
    Try this:
    Counting

    cnt(select Record[contains(Dummy, "AAR")])

    Selecting records

    select Record[contains(Dummy, "AAR")].Dummy


    regards
    Leo
    Like
    • jasonacha
    • jasonacha
    • 4 yrs ago
    • Reported - view
    Thanks a lot Leo! I was lost in Manual Woods btw, excellent db! Congrats, --Jaime
    Like
  • Hello,
    How can use REST services? ( http(method, url, header, body) )
    Have you a little sample?
    Thanks.
    Like
  • Hello,
    Have you planned a browser fields in Ninox?
    Thanks.
    Like
    • Andrea
    • Andrea
    • 4 yrs ago
    • Reported - view
    Hi,

    is there a function that can copy a text of a filed?

    thx
    Andrea
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Copy to where?

    Birger
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    Ninox Cloud can be accessed from any browser: https://app.ninoxdb.de/

    The abilty to connect Ninox with web forms (read and right) is in development at the moment.

    Birger Hansen
    Like
Like Follow
  • 4 yrs agoLast active
  • 106Replies
  • 35699Views