Skip to main content

Ninox-Documentation

Nick

Nick

Greece

699
29
1

Joined: Wed Jan 01 00:00:00 UTC 2014

My Posts

Latest Posts

Re: Simple Log in system with date/Time registration.
Thank you Steven, Happy New Year!
- Nick
- 4 yrs ago
- Learn & Share
- Reported - view
Re: Calculo entre datas
Read here: https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/getting-the-year-and-month-between-two-dates-5dc7ad3739e54c3dd149d8b8
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Scegliere il Layout di stampa
printRecord(this, "Name of your Layout")
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Code Snippets Manager/Organizer - Any Preferences?
Karen, I'm using the Zoho Notebook for this purpose It's free (an account required) and syncs with all major platforms. https://www.zoho.com/notebook/ Happy New Year!
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formulas
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formulas
@Lucidio, working fine here... ...column 17 is your multiplication character (*). Maybe something with your keyboard? In general: Weight Field in Meters -> Metric BMI Formula = 39 / (1.42 × 1.42) =19.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formulas
This is working: Weight / (Height / 100 * Height / 100)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Copy a reference field into another reference field
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Copy a reference field into another reference field
Sorry... Customers := Invoices.Customers
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Copy a reference field into another reference field
In your 'Line Items' table put this code in the 'Trigger after update' box: Customers := Invoices.Customer
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Send an email with attachment without Button
Sending email function is only available in Ninox Cloud/Ninox Server teams...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Draw records from a table based on selection criteria and summarize
My model is New Table e.g. Report Reference to data table e.g. Category Date field: DateStart Date Field: DateEnd View: e.g. Results Code for Results: -- let t := this;let a := Category;…
- Nick
- 4 yrs ago
- Learn & Share
- Reported - view
Re: Set Background Color?
Steven...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic updated field with date for each time I update something
You set the trigger in a Field (Date) level. Set the trigger in a Table level.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: how to import an excel sheet
Save it as .csv file and then import to Ninox.
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
Text
- Nick
- 4 yrs ago
- Learn & Share
- Reported - view
Re: Formula for YTD Calculations
let y := year(today()); sum(Invoice where year('Date Completed' = y).'Invoice Sum')
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for YTD Calculations
Sorry... let d :=today(); sum(Invoice where year(Invoice.'Date Completed'=year(d)).'Invoice Sum')
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for YTD Calculations
let d :=today(); sum(Invoice where year(Invoice.'Date Completed'=year(d).'Invoice Sum'))
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for Date
You are right, try this --- let t := today();TextField := format(t, "MM.DD") ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for Date
Something like this? --- let t := today();let mm := month(t);let dd := day(t);TextField := mm + "." + dd ---
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Getting the Year & Month between two dates
Same here Halio :-( This is not my code. I'm not a programmer, just test and test and then test again... I can't remember where I found it, maybe in some database from Ninox folks.…
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicating records - Keep some data and clear/reset other data
@alejako, Great job!!! (I didn't put the ends at the end of the variables...)
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicating records - Keep some data and clear/reset other data
As I set I'm trying to find a way to insert filters in the loop, but no success until now...
- Nick
- 4 yrs ago
- Get help
- Reported - view
Re: Duplicating records - Keep some data and clear/reset other data
This will duplicate ALL records in a table. --- for i in select Table doduplicate(i) end --- I couldn't find a way to double only the selected/filtered entries, yet.
- Nick
- 4 yrs ago
- Get help
- Reported - view

1 11 12 13 14 15 28

Back to top

Ninox-Documentation

Overview

View all topics