Nick

Greece

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

My Posts

Latest Posts

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
Re: Why is Edit Field Missing?
From the manual: Ninox databases can only be modified on the device they have been created on. Ninox has this setting to avoid conflicts. With “reorganise” you can re-allocate the admin rights to…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Mac Application Slow Performance?
Update 2... The Web version of Ninox opens the same database, goes to "default" table (trigger after open) and starts the spinning circle. Forever!!! I got boring and quit it after 20 minutes...…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Mac Application Slow Performance?
Update... In a Macbook Pro with the older version of Ninox (2.5.6?) everything is fine. Ofcourse it's the same database stored in iCloud.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Mac Application Slow Performance?

Hi all, I have a database of my personal finances in which, along with the tables that hold the data, I have about 15 tables with reports (depending on the group and category of expenses).…
- Nick
- 5 yrs ago
- 3replies
- 1565
- Get help
Re: styled
Try this: styled(text('Net Total'), if 'Net Total' < 0 then"red"elseif 'Net Total' > 0 then "yellow" else "green" endend, "") *Note that the result will be text.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Calculate records with dropdown value
Try this: sum((select TableName)[text(Status) = "Sent"].Total)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to pass field name to a function that returns field value?
Ninox people explanation: "Ninox is a custom user-friendly english-like language to help users digitize their business processes."…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: select and sum only if and if
Try something like this: let begD:= 'Start Date';let endD := 'End Date'; let myName := Name; sum((select Subtable)['Start Date >= begD and 'End Date' <= endD and Name = myName].amount)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: App IOS crashes
I don't have this problem (iPhone - iOS 12.4).Maybe try uninstall and reinstall?
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to move rows from one table to another? Or can I lock a box when status is X for example?
This is what you need? let myField1 := TableA_Field1;let myField2 := TableA_Field2;let myB := (create 'Table B');myB.(TableB_Field1:= myField1);myB.(TableB_Field2:= myField2);delete this;…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How do I adjust the column widths of a referenced field when it pops up?
Switch to Admin mode before hit the referenced field. When the window pops up, adjust the desired column width and finaly make a selection. After that Ninox prompts you to save changes or revert them.…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: How to move from one table to another
You can use a button with this code... -----let reply := dialog("ATTENTION", "I will move this record to Table B. Are you sure?", ["Yes", "No"]);if reply = "Yes" thenlet myB := (create 'Table B');…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Printing multiple forms
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Printing multiple forms
Hi, if I understoond you correctly, click the sub-table in the print layout and then use the Edit Columns... to the right.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Templates and Manual
Lawrie, since I was the one who started this thread, I would like to inform you that I have not left Ninox.As Sean and Steven said, I found my way through the forum, the manual and the webinars.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Changing views on iPhone does not work
No, nothing wrong. We are waiting for a fix.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail?
Sending Email from Mac app is not available. (only available in Ninox Cloud/Ninox Server teams)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Database duplicate
First click the little down arrow next to db name and choose Duplicate database... In the next screen select No to the "Copy Records" choice
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: style() to a Number field
As far as I know, styled() does not work in numeric fields. Try a formula field (result will be text).
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Creating A invoice Number or Order Number
Hi, you can check the Invoices template for these calcs. (Click New Database -> Invoices)
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Button for Adding Records to Subtable with Numerical Increase
Ι'm using this method: Create a formula field i.e. 'Item No' to the Trial Summary table with this code let myID := number(Id);let myTrialSum := 'Trial Summary';…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Help with a button opening a subtable.
To create a new child record... let myID := this;let newRec := (create MoneyCounter);newRec.('Safe Log':= myID);let myRN := number(newRec.Id);popupRecord(record(MoneyCounter,…
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: Child Table Record Selection?
Try to click a column header and then Hide or Show column.
- Nick
- 5 yrs ago
- Get help
- Reported - view
Re: PUTTING AN "OR" INTO THE FORMULA FIELD COLUMN FILTER
Try this: like "Apples" or like "Pears" or like "[nothing]"
- Nick
- 5 yrs ago
- Get help
- Reported - view

1 16 17 18 19 20 28

Welcome to the Ninox community

Nick

My Posts

Re: Anybody else having issues logging into Ninox site using Chorme today?

Re: Why is Edit Field Missing?

Re: Mac Application Slow Performance?

Re: Mac Application Slow Performance?

Mac Application Slow Performance?

Re: styled

Re: Calculate records with dropdown value

Re: How to pass field name to a function that returns field value?

Re: select and sum only if and if

Re: App IOS crashes

Re: How to move rows from one table to another? Or can I lock a box when status is X for example?

Re: How do I adjust the column widths of a referenced field when it pops up?

Re: How to move from one table to another

Re: Printing multiple forms

Re: Printing multiple forms

Re: Templates and Manual

Re: Changing views on iPhone does not work

Re: send e-mail?

Re: Database duplicate

Re: style() to a Number field

Re: Creating A invoice Number or Order Number

Re: Button for Adding Records to Subtable with Numerical Increase

Re: Help with a button opening a subtable.

Re: Child Table Record Selection?

Re: PUTTING AN "OR" INTO THE FORMULA FIELD COLUMN FILTER

Overview