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 Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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.
    Like
  • 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
    Like
  • 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?
    Like
  • 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
    Like
    • Allen
    • Allen
    • 6 yrs ago
    • Reported - view
    How would I extract the last 4 characters of a variable-length text-string?
    Like
  • 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
    Like
    • Thosbryan
    • Thosbryan
    • 6 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
    Like
  • 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
    Like
  • Gibt es eine Übersicht der Erweiterungen der Scriptsprache in Ninox 1.7?
    Like
  • Hallo ThorsProvoni, wir haben diese Seite soeben aktualisiert, sie enthält jetzt alle neuen Funktionen. Viele Grüße, Frank
    Like
    • jgrozev
    • jgrozev
    • 6 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.
    Like
  • 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
    Like
    • jgrozev
    • jgrozev
    • 6 yrs ago
    • Reported - view
    Thank you Alex,

    This helped.

    Kind regards:

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

    you can apply a filter in the date2 column:

    =null

    Best regards, Alex
    Like
    • Min Oo
    • Min_Oo
    • 6 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
    Like
  • 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
    Like
    • Min Oo
    • Min_Oo
    • 6 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.
    Like
  • 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
    Like
    • jonfusa
    • jonfusa
    • 6 yrs ago
    • Reported - view
    Is there a command to open a table in the form view to add a new record to the table
    Like
    • Temp
    • Temp
    • 6 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
    Like
    • Temp
    • Temp
    • 6 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
    Like
Like Follow
  • 4 yrs agoLast active
  • 51Replies
  • 19453Views