Nick's Profile | Ninox community

Badges

Latest Posts

Re: Formula for age calculation
I had some time to kill, so I came up with this: Formula field (named Age Styled in the screenshot below) with this code: let age := year(today()) - BirthYear;if BirthYear != null and BirthYear !…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Your "BirthYear" field is a text field or number field?
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Hey Pierre, works for me... Number Field: BirthYear -> e.g. 1974 Formula Field -> Age -> year(today()) - BirthYear Result = 45
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
I hope it's OK for jumping in... Try this - BirthYear (number field) : 4 numbers - Age : a calculating field with this formula : year(today()) - BirthYear
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Problem with send mail script
From the manual: Functions to send e-mails ** ** (only available in Ninox Cloud/Ninox Server teams)
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
"Placeholder" does not work for Image fields also! Has only the options "Top" and "Hidden". It could have enough use there.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
Yep, Sean you are right! (Remember your joke about Esc key? So, don't use styles... lol) Maybe someone from the Ninox Team explain what happend. For Label position - "Placeholder" to work must the…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Print Layout Missing after update?
Email directly to support: support@ninoxdb.de
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Print Layout Missing after update?
Everything is fine here, Mac app, iPad app, iPhone app. Ninox v2.5.3
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Okay guys, I found something in Ninox that I think needs to be fixed, that's all.
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
...but maybe I wasn't clear NINOXUS wrote: "hitting the [Esc] button will take you back to the default table view" When you' re in a form view there isn't a default view...…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Thanks!
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Ahhh!! form editor = formula editor. 😬😬😬😬
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
From View = Form View. 😬
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Hi Sean, I think it's a bug since it does not make sense in the From View. For example, in the form editor screen that should cancel the process and close the window, Esc key does not work.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Form disappears with Escape key

When I'm in a form e.g. Invoice Form and hit escape key the content disappears. Is this a bug or a feature 🤪 I'm on Ninox Mac App
- Nick
- 6 yrs ago
- 16replies
- 3491
- Get help
Re: How can I add two arrays?
Hi Ιωάννη, get some ideas here: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/list-of-values-5c7e33c170047023951d2319 Νίκος
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Can I place a comment in a script?
I'm sorry but this is not good way for you? "------------This is a comment------------";let myId := Id; "------------This is a comment------------";let myCust := Customer;
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Is it possible to cancel the creation of a record in the "on create" trigger?
I don't know if it is possible to Cancel... I'm using this approach within a trigger: - if this = that then delete this end - This deletes the created record if all conditions are met.
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: capital letters
Trigger after Update to your field: YourField := lower(YourField)
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Formula to calculate the duration in Hours and minutes of a work
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Debt and credit
Running Balance? I'm interest in this, too.
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Formula to calculate the duration in Hours and minutes of a work
Try this formula WorkEnd - WorkStart
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: BH
sum((select TableName).FieldName)
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: formula creates a record ( which i don't need)
Hi, this line: **let z := (create ‘order');** creates a new order. Try to move this line after the if statements.
- Nick
- 7 yrs ago
- Get help
- Reported - view

1 19 20 21 22 23 29

Welcome to the Ninox community

Nick

Re: Formula for age calculation

Re: Formula for age calculation

Re: Formula for age calculation

Re: Formula for age calculation

Re: Problem with send mail script

Re: New formula field formatting

Re: New formula field formatting

Re: Print Layout Missing after update?

Re: Print Layout Missing after update?

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Form disappears with Escape key

Re: How can I add two arrays?

Re: Can I place a comment in a script?

Re: Is it possible to cancel the creation of a record in the "on create" trigger?

Re: capital letters

Re: Formula to calculate the duration in Hours and minutes of a work

Re: Debt and credit

Re: Formula to calculate the duration in Hours and minutes of a work

Re: BH

Re: formula creates a record ( which i don't need)

Overview