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: Linking tables
You can connect them during the import. https://ninoxdb.de/en/manual/import-and-export/importing-linked-data Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: PRINTING FORMS
Do you mean something like this? https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/attach-file-5b5d77049b4f220718cdba4d?post=5b5dabbe615501550d8cbcf4&page=1
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: PRINTING FORMS
Ninox is under development and soon, I believe, they will make some things more simple. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: PRINTING FORMS
The "Id" just indicates the record you are browsing (for the printout). You have no reason to change that. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: PRINTING FORMS
Create (or modify) a print layout with your desired fields. Then create a button to your form: printRecord(Id, "youPrintLayoutName") Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Text
Create new formual field and use this code: substr(yourTextField, 0, 2) + "/" + substr(yourTextField, 2, 2) + "/" + substr(yourTextField, 4, 2) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to create a button that clicks through forms
Next Record: let thisNUM := number(Id);let myNUM := min((select yourTable)[number(Id) > thisNUM].number(Id));openRecord(record(yourTable,myNUM)) Previous Record: let thisNUM := number(Id);let myNUM :…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Export a single record as a CSV ?
And the result is... Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Export a single record as a CSV ?
Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: formula
if NetTotal < 0 then "YourText1" else if NetTotal > 0 then "YouText2" else "YouText3" endend Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
1) You can continue adding code to the script, just separate them with a semicolon. 2) Click on column header and choose "Show Column...". Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
I've created a small test file for you, download it and import to Ninox. https://www.dropbox.com/s/qlzu0mbcfuqzddl/Proffing.ninox?dl=0 I hope it helps Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
if 'Mag Stage' = 3 or 'Web Stage' = 3 or 'App Stage' = 3 or 'Bev Stage' = 3 then'Proof Stage' := 2elsenullend Notice > := Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
if 'Mag Stage' = 3 or 'Web Stage' = 3 or 'App Stage' = 3 or Bev Stage = 3 then'Proof Stage' := 2elsenullend Why Proof Stage have to be Choice and not a Formula field?…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
...or use Choice Id Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
Try to convert to text: text('Mag Stage') text('Web Stage') etc Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Help Please
Create new Formula field and: Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Help Please
For expiry date create formula field: -- YourDateField +15 -- For highlighted fields I use something similar for invoices: -- let dd := Date + Customer.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Anyone know where to find support info on buttons?
From Ninox Templates, reading the manual, a litle SQL, a litle Filemaker and ofcourse in here, Ninox Forum. Read about Operators, too. Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Anyone know where to find support info on buttons?
Buttons in Ninox accepts Functions as any other Formula field. Look in the manual https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language in User Interface Automation section.…
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: sum and count function?
For column in table: click column header and choose Count or Sum On forms -> Formula field and: sum((select 'TableName').FieldName) or cnt((select 'TableName').FieldName) Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Trigger after update previous value.
Hi Jörg, can you invite me for demo databases? Nick
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: links diagram
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: How to change a table name ?
Top left corner when you are in Editing Fields screen -> Table Name...
- Nick
- 6 yrs ago
- Get help
- Reported - view
Re: Confirm box when new record
Yes, I meant the button works. For a trigger i can't figure it out.
- Nick
- 6 yrs ago
- Get help
- Reported - view

1 22 23 24 25 26 27 28

Back to top

Ninox-Documentation

Overview

View all topics