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.

51 replies

null
    • peru1_ordinaryorg
    • 8 yrs agoMon, April 18, 2016 at 1:38 PM UTC
    • 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 agoMon, April 18, 2016 at 2:07 PM UTC
    • 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 agoMon, April 18, 2016 at 5:32 PM UTC
    • 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 agoTue, April 19, 2016 at 7:34 AM UTC
    • 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 agoMon, July 4, 2016 at 7:31 PM UTC
    • Reported - view
    How would I extract the last 4 characters of a variable-length text-string?
    • Alexander_Koenig
    • 8 yrs agoTue, July 5, 2016 at 5:52 AM UTC
    • 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
    • 8 yrs agoThu, September 22, 2016 at 1:25 PM UTC
    • 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
    • 8 yrs agoThu, September 22, 2016 at 3:29 PM UTC
    • 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
    • 8 yrs agoFri, September 23, 2016 at 8:12 AM UTC
    • Reported - view
    Gibt es eine Übersicht der Erweiterungen der Scriptsprache in Ninox 1.7?
    • Frank_Bohmer
    • 8 yrs agoMon, September 26, 2016 at 7:51 AM UTC
    • Reported - view
    Hallo ThorsProvoni, wir haben diese Seite soeben aktualisiert, sie enthält jetzt alle neuen Funktionen. Viele Grüße, Frank
    • jgrozev
    • 8 yrs agoSun, October 23, 2016 at 9:39 AM UTC
    • 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
    • 8 yrs agoMon, October 24, 2016 at 7:19 AM UTC
    • 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
    • 8 yrs agoThu, October 27, 2016 at 8:30 AM UTC
    • Reported - view
    Thank you Alex,

    This helped.

    Kind regards:

    Jack.
    • Min_Oo
    • 8 yrs agoSun, October 30, 2016 at 9:45 AM UTC
    • 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
    • 8 yrs agoMon, October 31, 2016 at 11:32 AM UTC
    • Reported - view
    Hello Min Oo,
    try: year(now()) * 12
    Best regards, Alex
    • Min_Oo
    • 8 yrs agoMon, October 31, 2016 at 2:02 PM UTC
    • Reported - view
    Thanks, Alex.
    It helped me.
    • Min_Oo
    • 8 yrs agoWed, November 2, 2016 at 6:02 PM UTC
    • 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
    • 8 yrs agoThu, November 3, 2016 at 10:03 AM UTC
    • Reported - view
    Hello Min Oo,

    you can apply a filter in the date2 column:

    =null

    Best regards, Alex
    • Min_Oo
    • 8 yrs agoSun, November 6, 2016 at 3:23 PM UTC
    • 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
    • 8 yrs agoMon, November 7, 2016 at 10:23 AM UTC
    • 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
    • 8 yrs agoMon, November 7, 2016 at 4:53 PM UTC
    • 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
    • 8 yrs agoTue, November 8, 2016 at 9:02 AM UTC
    • 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
    • 8 yrs agoWed, November 9, 2016 at 9:08 AM UTC
    • Reported - view
    Is there a command to open a table in the form view to add a new record to the table
    • Temp
    • 8 yrs agoSat, November 26, 2016 at 3:44 PM UTC
    • Reported - view
    Hi,

    Hopefully someone can help me here.

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

    thanks
    • Temp
    • 8 yrs agoSat, November 26, 2016 at 5:17 PM UTC
    • 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