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: Frustrated with poor help guides- Is there a full guide to formulas anywhere?
@Richard, don't give up, we all went through this stage.Read here what I wrote about a year ago ...…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Update switch statement works fine with iPad and iPhone. The problem is with Mac app.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formatting a field
No problem @Joe. Here is the code for SSN field: --- let myNumber := trim(text(SSN));let p := length(myNumber);let myCars := "";var myStart := 0;var myEnd := 1;for i in range(0, p) dovar myNum :…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Nope! Nothing worked, but... Mac app - formula with 'switch' statement: Web app - formula with 'switch' statement: Mac app again: Web app again: I'm switching from 'switch' to multiply if's for now...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Thanks again!
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
@Sean, Explain your self goung man! ...rebuild????
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formatting a field
Hi Joe, what is SS#?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Switch statement stop working?
Thanks @Sean. There is something weird... Formulas with switch statement that produces English characters e.g. Monday, are OK. With Greek characters (e.g. Δευτέρα) are empty in one of my databases.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to calculate years and months from a date to the current date?
Hi, you can find a function to do that here: https://www.nioxus.com/VyDMC3jvft9c/post/275 You have to create an account, but it's free and they have a lots of stuff for Ninox.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Switch statement stop working?

I noticed that in the new version 2.6.0. (and 2.6.1.) the switch stetement is no longer working.Did anyone else notice this? Ninox Mac App
- Nick
- 5 yrs ago
- 10replies
- 2144
- Get help
Re: Formatting a field
Replace the last line with this: Phone := Area + "-" + Num + "-" + Num2
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formatting a field
For upper first letter: https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/first-letter-upper-case-5afad40d3940a83b6588f1ab For phone format use this code in the Trigger After Update box:…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: on click example please
Working for: alert, dialog and closeRecord(). I wanted to click on a formula field to drill down to a view in a differed tab but openTable("Table", "View") does nothing...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Just install Ninox 2.6 Desktop , impossible to make change in a rich texte field
Be patient,depending on your country App Store, it will probably be available in a few hours.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How do I do a text calculation (e.g., First Name & " " & Last Name)
sorry... 'First Name' + " " + 'Last Name'
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How do I do a text calculation (e.g., First Name & " " & Last Name)
Use this code: First Name + " " + Last Name
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How do I code the following: Select from a combo box, each item has a value, the value reflects in a different filed. If there is nothing selected then the value in the field must be 0?
Some screen shot would be nice. I need more details... what type of fields are you using etc.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How do I code the following: Select from a combo box, each item has a value, the value reflects in a different filed. If there is nothing selected then the value in the field must be 0?
Try this: if text('Year 1 2017') = "Council Reg" then 'Council Registration' := "1200"else if text('Year 1 2017') = false then "0"
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Save trial database work to my recently purchased Local Mac Ninox environment.
Click the little arrow next to the icon of your database and then click Create Backup. This opens a new window where you can download the backup of the database in your hard drive.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Checkbook
I'm using something like this, based on line id: Formula field (i.e. Running Balance) ---- let myID := Id; let previousB := sum((select Checkbook)[Id <= myID].…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Change field colour based on multiple if then else
Hi, try this: if 'Current Inventory' > 'Total Count' thenstyled("Inventory is SMALLER", "#ddeeff", "green", "dialog")elseif 'Current Inventory' < 'Total Count' thenstyled("Inventory is LARGER", "",…
- Nick
- 5 yrs ago
- 1
- Get help
- Reported - view
Re: Formula for Total Time
In one of my databases that i'm using duration summary, i have the gollowing setup I hope it helps...
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for Total Time
or let myStatus := Status;sum((select YourTableNameHere)[Status = myStatus].Duration) to view a duration summary for a Status that matches the current record.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for Total Time
Maybe something like this: Formula field that sums up the duration when the status is "Completed", sum((select YourTableNameHere)[Status = "Completed"].Duration)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Anybody else having issues logging into Ninox site using Chorme today?
Friday through Sunday I was not able to log in from Mac 10.13.6. I tried with Safari and Firefox without success. Today, Monday, I came to work where we have windows and managed to log in with…
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 15 16 17 18 19 28

Back to top

Ninox-Documentation

Overview

View all topics