Nick

Greece

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

My Posts

Latest Posts

Re: Fonts, Colors and Borders
Thanks for sharing Sean!
- Nick
- 3 yrs ago
- Learn and Share
- Reported - view
Re: What's with all the garbage
I do not know who will close first but I am sure that all will exceed 3000 posts. To better accomplishments
- Nick
- 3 yrs ago
- Learn and Share
- Reported - view
Re: What's with all the garbage
149 pages of garbage... Hello Ninox people!!!
- Nick
- 3 yrs ago
- Learn and Share
- Reported - view
Re: How do you get rid of the obnoxious background color in Ninox. That purple sucks. I am still using the older version because of it. Why not make it adjustable? Please!
Great! Thanks Sean for sharing.
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Help with an Excel like formula in Ninox
Maybe this thread helps? https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/like-countifs-in-excel-5e8cf4c35e353d53a6fa5b7e
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Help with last Formula...
Ooops! Sorry... let myCust := Customer;let xBeg := From;let xEnd := To; sum(Invoices['Date of Invoice'>= xBeg and 'Date of Invoice' <=xEnd and Customer = myCust].…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Help with last Formula...
Michael, it is just logic. Try to understand the code below. This way along with the date filter, we tell Ninox to filter with selected CUstomer i.e. 'Shop Sale'.…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Connected viewed records with a view - One Customer
Hi Michael, I have modified the '112-Print view element in dashboard' file. Now you can select a customer for the view. Click the link below to get it. https://1drv.…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Connected viewed records with a view - One Customer
I have a Invoice table connected with Invoices table. Let's say I want to see all the 2020 invoices for the current Customer.I create a formula field with the following code:…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
Thanks John
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: carriage return in alertbox
let txt := 'My Line 1' + "" + 'My Line 2';alert(txt)
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
Hi John, ...outside the earth or its atmosphere
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
Try it this way: let xBal := sum('UN On Hand' - 'UN to Distrib');styled(text(xBal), if xBal = 0 then"green"elseif xBal > 0 and xBal < 5 then"yellow"elseif xBal > 5 then "red" endendend)
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Returning values from a child table based on field value.
First of all, make sure that in the 'Inspection Form' table the reference Composition option is set to yes (It is easier this way). Then, in Colony Information table create two formula fields e.g.: 1.…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Norberto
Windows XP, is almost a decade old. Did you check Ninox system requirements? https://ninox.com/en/manual/system-requirements/system-requirements
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Short Contributors Bio
Hi John, I used Filemaker (since version 1.0, early 90's) for almost everything. Schools, medicine, finance, personal activities, etc. I was very happy when I found Ninox and saw that it would…
- Nick
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Visible Columns vs Available Columns
Click the wrench icon on the right to turn it red (activate administration mode). Make your changes. Click wrench icon again to save your changes (deactivate administration mode).
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Need to make Appointments showing in different colors in the calendar
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Need to make Appointments showing in different colors in the calendar
Hi, I am using this code for that: --- let displayText := "";let displayColor := "";let displayBackground := "";let displayIcon := "";if Office = Office1 then displayText := Calendar_Display;…
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: How do you know when your software (MAC) is updated?
How hard it is to add a menu About Ninox in the app or?
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Duplicate database for a new project from a windows computer
First, Create Backup and then use the Import Archive and select the downloaded backup.
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Database duplicate
This menu is from Ninox app for Mac. If you are using the browser version you need to Create Backup and then use the Import Archive and select the downloaded backup.
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: DOB > Age > Child, Adult or Senior
For age -> formula field with code: age(DOB) For grouping -> formula field with code: if 'Age' < 18 then "Child"else if 'Age' < 65 then "Adult" else if 'Age' > 65 then "Senior" end endend
- Nick
- 3 yrs ago
- Get help
- Reported - view
Re: Blog Post NINOX 3.3.0
- Nick
- 3 yrs ago
- Get help
- Reported - view

1 2 3 4 5 28

Welcome to the Ninox community

Nick

My Posts

Re: Fonts, Colors and Borders

Re: What's with all the garbage

Re: What's with all the garbage

Re: How do you get rid of the obnoxious background color in Ninox. That purple sucks. I am still using the older version because of it. Why not make it adjustable? Please!

Re: Help with an Excel like formula in Ninox

Re: Help with last Formula...

Re: Help with last Formula...

Re: Connected viewed records with a view - One Customer

Re: Connected viewed records with a view - One Customer

Re: Conditional Formatting Built into Formula Field

Re: carriage return in alertbox

Re: Conditional Formatting Built into Formula Field

Re: Conditional Formatting Built into Formula Field

Re: Conditional Formatting Built into Formula Field

Re: Returning values from a child table based on field value.

Re: Norberto

Re: Short Contributors Bio

Re: Visible Columns vs Available Columns

Re: Need to make Appointments showing in different colors in the calendar

Re: Need to make Appointments showing in different colors in the calendar

Re: How do you know when your software (MAC) is updated?

Re: Duplicate database for a new project from a windows computer

Re: Database duplicate

Re: DOB > Age > Child, Adult or Senior

Re: Blog Post NINOX 3.3.0

Overview