Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Nick
Nick
Greece
674
17
1
Joined: Wed Jan 01 00:00:00 UTC 2014
Follow
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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Export a single record as a CSV ?
And the result is... Nick
Nick
Nick
5 yrs ago
Get help
Reported - view
Re: Export a single record as a CSV ?
Nick
Nick
Nick
5 yrs ago
Get help
Reported - view
Re: formula
if NetTotal < 0 then "YourText1" else if NetTotal > 0 then "YouText2" else "YouText3" endend Nick
Nick
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Trigger based on multiple fields
...or use Choice Id Nick
Nick
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Help Please
Create new Formula field and: Nick
Nick
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
Re: Trigger after update previous value.
Hi Jörg, can you invite me for demo databases? Nick
Nick
Nick
5 yrs ago
Get help
Reported - view
Re: links diagram
Nick
Nick
5 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
Nick
5 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
Nick
5 yrs ago
Get help
Reported - view
1
21
22
23
24
25
26
27
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics