Reference of Functions and Language

Hi, is there a way to comment out some lines?

you can write e.g.
---
let Comment: = "here is a comment"
---

regards
Leo

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.

We are working on a new manual... At the moment find new features documented here https://ninoxdb.de/en/whatsnew

Birger - Ninox Support

Many thanks. I'm loving the product so far and am astounded by its power considering how much it costs. :)

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

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

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.

This is the first sign of bigger things to come :-)

RESTful API coming to Ninox soon.

Birger - Ninox Support

no reply?? :(

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

Very happy to know this news, the new version will be released at what time?

it will be released inside this half of the year.

Birger - Ninox Support

Hi.

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

Best,

John

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

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

Leo,

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

John

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

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

Thanks a lot Leo! I was lost in Manual Woods btw, excellent db! Congrats, --Jaime

Hello,
How can use REST services? ( http(method, url, header, body) )
Have you a little sample?
Thanks.

Hello,
Have you planned a browser fields in Ninox?
Thanks.

Hi,

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

thx
Andrea

Copy to where?

Birger

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