0

# Function and Language Reference

Is it possible to create views called "This Month" and "Last Month"? The same formula could be used for "This Year" and "Last Year" as well as "This Week" and "Last Week". I'm trying to create views for donations received this month and last month.

## 51replies

• peru1_ordinaryorg
• 8 yrs ago
• Reported - view
I am trying to avoid using "hard" dates for my views (like 4/2016), but create views that show the current month and the past month, without having to change the date each month.
• Alexander_Koenig
• 8 yrs ago
• Reported - view
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
• peru1_ordinaryorg
• 8 yrs ago
• Reported - view
Sorry to be a bother. I have tried several possibilities in the text side of the formula editor, but I can't get it to do the previous month. I tried yearmonth(Date) = yearmonth(now()) + -1 and the syntax was ok but the formal didn't return donations received last month. Any suggestions?
• Alexander_Koenig
• 8 yrs ago
• Reported - view
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
• Allen
• 8 yrs ago
• Reported - view
How would I extract the last 4 characters of a variable-length text-string?
• Alexander_Koenig
• 8 yrs ago
• Reported - view
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
• Thosbryan
• 7 yrs ago
• Reported - view
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
• Frank_Bohmer
• 7 yrs ago
• Reported - view
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
• ThorsProvoni
• 7 yrs ago
• Reported - view
Gibt es eine Übersicht der Erweiterungen der Scriptsprache in Ninox 1.7?
• Frank_Bohmer
• 7 yrs ago
• Reported - view
Hallo ThorsProvoni, wir haben diese Seite soeben aktualisiert, sie enthält jetzt alle neuen Funktionen. Viele Grüße, Frank
• jgrozev
• 7 yrs ago
• Reported - view
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.
• Alexander_Koenig
• 7 yrs ago
• Reported - view
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
• jgrozev
• 7 yrs ago
• Reported - view
Thank you Alex,

This helped.

Kind regards:

Jack.
• Min_Oo
• 7 yrs ago
• Reported - view
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,
• Alexander_Koenig
• 7 yrs ago
• Reported - view
Hello Min Oo,
try: year(now()) * 12
Best regards, Alex
• Min_Oo
• 7 yrs ago
• Reported - view
Thanks, Alex.
It helped me.
• Min_Oo
• 7 yrs ago
• Reported - view
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
• Alexander_Koenig
• 7 yrs ago
• Reported - view
Hello Min Oo,

you can apply a filter in the date2 column:

=null

Best regards, Alex
• Min_Oo
• 7 yrs ago
• Reported - view
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
• Alexander_Koenig
• 7 yrs ago
• Reported - view
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
• Min_Oo
• 7 yrs ago
• Reported - view
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.
• Alexander_Koenig
• 7 yrs ago
• Reported - view
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
• jonfusa
• 7 yrs ago
• Reported - view
Is there a command to open a table in the form view to add a new record to the table
• Temp
• 7 yrs ago
• Reported - view
Hi,

Hopefully someone can help me here.

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

thanks
• Temp
• 7 yrs ago
• Reported - view
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

## Content aside

• 6 yrs agoLast active
• 51Replies
• 19636Views