Function and Language Reference

Hello,
show a new column with a function. Apply the formula:
yearmonth(Date) = yearmonth(now())
All entries for the actual month will have yes. Now apply a filter for "yes".
Best regards, Alex

Hi, thanks for your request.
This formula helps to get the result:
year(Date) * 12 + month(Date) = year(now()) * 12 + month(now()) - 1
Kind regards, Alex

How would I extract the last 4 characters of a variable-length text-string?

Hi Allen,
this works with a negative start in substr(field,-4,4).
There will be also a new function length() to get the length of string coming with the next release.
Best regards, Alex

In your invoices template you make use of the Sum aggregate. I do not see this command as an option when building an equation. Also there are a number of other aggregates mentioned which I can't find

Hi Thomas,
in the visual formula editor you can simply follow the reference fields by clicking on them. When you finally hit the field you want to sum up, it will show you all possible aggregations.
In text mode you can enter directly something like sum('Invoice Items'.Price)
Regards, Frank

Gibt es eine Übersicht der Erweiterungen der Scriptsprache in Ninox 1.7?

Hallo ThorsProvoni, wir haben diese Seite soeben aktualisiert, sie enthält jetzt alle neuen Funktionen. Viele Grüße, Frank

Hi,

How would I go about implementing a mechanism to check if an entry being currently entered in a table already exists in that table - that is, preventing duplicate entries?

Also, is there a way of building query forms beyond what the simple search tool can do?
For instance - "Show all records in which field 'A'='xyz' ".

Thank you very much.

Kind regards:

Jack.

Hello Jack,

you can use a formula to check if a record has a duplicate:
let Z := Text_Field;
cnt((select Table_Name where Text_Field = Z).Text_Field)

Insert your table_name and Name of your Text_Field.
Best regards, Alex

Thank you Alex,

This helped.

Kind regards:

Jack.

I'm also interested in this issue.
I can try for the present month.
But , for the previous month, although I try your instructions, I can't.

When I do year(now)*12, "Error: Invalid operator: boolean *number" appeared and I cannot proceed.

Can you explain in detail?

Thanks,

Hello Min Oo,
try: year(now()) * 12
Best regards, Alex

Thanks, Alex.
It helped me.

I'm using Ninox to register my unit's patients. They are admitted on the column "Date1" and discharged on the next column "Date2".
In new view, I want to know the patients remaining in my unit, i.e. "Date2" is not yet entered.
Can I see those patients who are not yet discharged by using formula and how?

Best regards,
Min Oo

Hello Min Oo,

you can apply a filter in the date2 column:

=null

Best regards, Alex

Hello Alex,
Thanks for your kind attention.
My next question is :
My db have "Date" field and "Time" field. I want to count and group between 8 AM to next day 7:59 AM for everyday. Will it be possible?

Thank you in advance,
Min Oo

Hello,

add a new column and apply a formula to attribute a new date.

if Time < 28800000 then Date-1 else Date

where 28800000 is 07:59 in Milliseconds.

Best regards, Alex

Amazing. Ninox can do almost everything.
Thanks Alex.
Btw, my friends are asking me that " Is there Ninox version available for their Windows OS?" Please let us know.

Hello Min Oo, thanks for your feedback.

The team minded Ninox Cloud can be accessed from all platforms via web browser. This includes Windows.

app.ninoxdb.de

Best regards, Alex

Is there a command to open a table in the form view to add a new record to the table

Hi,

Hopefully someone can help me here.

I am trying to rank data based on the data's assigned date.

thanks

Sorry not very clear after reading my post again, example of what i mean is below

Date1
- data1
- data2
- data3
- data4

Date2
- data1
- data2
- data3
- data4

hope this makes it clearer