Nick

Greece

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

My Posts

Latest Posts

Re: Newbie ... Define which field links tables
You can't do that. Ninox has a different way to relate data. Please read here how to import linked data: https://ninoxdb.de/en/manual/import-and-export/importing-linked-data I transfered all my…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Simple Log in system with date/Time registration.
Thank you Steven, Happy New Year!
- Nick
- 5 yrs ago
- Learn and 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
- 5 yrs ago
- Get help
- Reported - view
Re: Scegliere il Layout di stampa
printRecord(this, "Name of your Layout")
- Nick
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Formulas
- Nick
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Formulas
This is working: Weight / (Height / 100 * Height / 100)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Copy a reference field into another reference field
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Copy a reference field into another reference field
Sorry... Customers := Invoices.Customers
- Nick
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Set Background Color?
Steven...
- Nick
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: how to import an excel sheet
Save it as .csv file and then import to Ninox.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
Text
- Nick
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Formula for YTD Calculations
let y := year(today()); sum(Invoice where year('Date Completed' = y).'Invoice Sum')
- Nick
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for Date
You are right, try this --- let t := today();TextField := format(t, "MM.DD") ---
- Nick
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view

1 11 12 13 14 15 28

Welcome to the Ninox community

Nick

My Posts

Re: Newbie ... Define which field links tables

Re: Simple Log in system with date/Time registration.

Re: Calculo entre datas

Re: Scegliere il Layout di stampa

Re: Code Snippets Manager/Organizer - Any Preferences?

Re: Formulas

Re: Formulas

Re: Formulas

Re: Copy a reference field into another reference field

Re: Copy a reference field into another reference field

Re: Copy a reference field into another reference field

Re: Send an email with attachment without Button

Re: Draw records from a table based on selection criteria and summarize

Re: Set Background Color?

Re: Automatic updated field with date for each time I update something

Re: how to import an excel sheet

Re: Poll: are you using the visual or the text editor in formula editing?

Re: Formula for YTD Calculations

Re: Formula for YTD Calculations

Re: Formula for YTD Calculations

Re: Formula for Date

Re: Formula for Date

Re: Getting the Year & Month between two dates

Re: Duplicating records - Keep some data and clear/reset other data

Re: Duplicating records - Keep some data and clear/reset other data

Overview