Nick's Profile | Ninox Community

Badges

Latest Posts

Re: How to create a button that clicks through forms
No, no hostile at all! Don't get me wrong. I love the app, and (as you said about my responce) I'm trying to help other users. I just say that I am not completely satisfied (my workaround included).…
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: How to create a button that clicks through forms
All these are workarounds that doesn't work right. Lets's hope Ninox Team add the functions goToRecord (Next) goToRecord (Last) etc. The code is already hard coded to the app. Nick
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Linking tables
You can connect them during the import. https://ninoxdb.de/en/manual/import-and-export/importing-linked-data Nick
- Nick
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 yrs ago
- Get help
- Reported - view
Re: Export a single record as a CSV ?
And the result is... Nick
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: Export a single record as a CSV ?
Nick
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: formula
if NetTotal < 0 then "YourText1" else if NetTotal > 0 then "YouText2" else "YouText3" endend Nick
- Nick
- 7 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
- 7 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
- 7 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
- 7 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
- 7 yrs ago
- Get help
- Reported - view
Re: Trigger based on multiple fields
...or use Choice Id Nick
- Nick
- 7 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
- 7 yrs ago
- Get help
- Reported - view
Re: Help Please
Create new Formula field and: Nick
- Nick
- 7 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
- 7 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
- 7 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
- 7 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
- 7 yrs ago
- Get help
- Reported - view
Re: Trigger after update previous value.
Hi Jörg, can you invite me for demo databases? Nick
- Nick
- 7 yrs ago
- Get help
- Reported - view
Re: links diagram
- Nick
- 7 yrs ago
- Get help
- Reported - view

1 23 24 25 26 27 28 29

Welcome to the Ninox community

Nick

Re: How to create a button that clicks through forms

Re: How to create a button that clicks through forms

Re: Linking tables

Re: PRINTING FORMS

Re: PRINTING FORMS

Re: PRINTING FORMS

Re: PRINTING FORMS

Re: Text

Re: How to create a button that clicks through forms

Re: Export a single record as a CSV ?

Re: Export a single record as a CSV ?

Re: formula

Re: Trigger based on multiple fields

Re: Trigger based on multiple fields

Re: Trigger based on multiple fields

Re: Trigger based on multiple fields

Re: Trigger based on multiple fields

Re: Trigger based on multiple fields

Re: Help Please

Re: Help Please

Re: Anyone know where to find support info on buttons?

Re: Anyone know where to find support info on buttons?

Re: sum and count function?

Re: Trigger after update previous value.

Re: links diagram

Overview