Skip to main content

Ninox-Documentation

Tim

Tim

29
2
0

Joined: 19 Dec 2018

My Posts

Latest Posts

Re: Bug or Limitation: Combo Box References: Limited Capacity
Dan, permissions like "can create" are not available in the stand-alone version. Don't forget about us!
- Tim
- 8 mths ago
- Get help
- Reported - view
Re: How to import local database from external HDD?
So, I had access to an Intel-based MacBook and was able to boot that from my old iMac drive in a USB dock. Ran Ninox there to create the archives, then plugged it back into the new MacBook to import…
- Tim
- 2 yrs ago
- Get help
- Reported - view
Re: How to import local database from external HDD?
After contacting Ninox support, it does look like the only approach is to boot from the external drive and create archives which can then be imported after re-booting from the internal drive.…
- Tim
- 2 yrs ago
- Get help
- Reported - view
Re: How to import local database from external HDD?
Sean, do you mean that this procedure will work with local databases? I hadn't saved the local databases as archives before the Mac died, so I don't see any *.…
- Tim
- 2 yrs ago
- Get help
- Reported - view
How to import local database from external HDD?

My Mac failed, but the hard drive is OK, so I've got it in a USB HDD dock. How can I best import my local databases from that drive into my new Mac? I am using Mac Desktop Ninox, not Ninox Cloud.…
- Tim
- 2 yrs ago
- 7replies
- 448
- Get help
Use "select ... where ..." or "select ... [...]"?

Proposition: It is preferred to use "select mytable where criteria" over "select mytable[criteria]". I only recently saw in the forum the use of a square bracket criteria expression on a select…
- Tim
- 2 yrs ago
- 1,230
- 2
- Get help
Re: Formula help please.
This should work: if Rarity then text(Rarity) else "Not Rated" end
- Tim
- 2 yrs ago
- Get help
- Reported - view
Re: "comments" in the code
Just be aware that with a quoted string not assigned to anything, you are not really creating a comment, you are specifiying a result value that may or not be used somewhere.…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: I can pass a record as a function argument!
OK, I've done some more testing, with mixed results. Here's what works and what doesn't, so far. This seems to be a capability that you can use very carefully,…
- Tim
- 4 yrs ago
- Get help
- Reported - view
I can pass a record as a function argument!

OMG, I just tried this and it worked! Did anybody else already know about this? I can't find any reference to this capability to pass a record into a function. function test(node : Entries) do node.…
- Tim
- 4 yrs ago
- 2replies
- 2,331
- Get help
Re: Universal array handling when array items are not text strings
Oh, yes, baby! That's it! I knew there was something in there somewhere that would do it. Thank you, Günther! This will work great. I may have a lot of records,…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Universal array handling when array items are not text strings
Since I'm looking for how to manipulate arrays that don't contain text values, I keep looking at the slice function, because it does return a new array, regardless of array element type,…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Universal array handling when array items are not text strings

There are at least a couple of threads proposing user-defined functions to make array handling more convenient - but they all work only for arrays of text strings,…
- Tim
- 4 yrs ago
- 7replies
- 3,123
- Get help
Re: Sorting within a constraint
You should click the tool icon (upper right on Mac desktop version) BEFORE you open the constrained view. It will then be displayed in red. Open the constrained view and make it look however you want:…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Set Date Field with a choice Field is Made
BTW, if you want to make your code a bit more readable, you can compare choice field values with text using 'like', as in: ------------------------------------ if 'Date Closed' = null and 'Project…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
A delimiter argument for the concat function would make a lot of sense. In the meantime, I've used the replace() function to replace the default ", " delimiter in the concatenated string with the…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
If you really need to pass an array into a function (e.g. into one of the new user-defined global functions), one approach I've used is to pass a string argument with a known convention for…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Types of parameters for a private function
I can't remember where I first saw this, but functions can also accept and return 'boolean' as an argument type, as in: function myfunc(arg: boolean) do if arg then bla bla bla endend Also,…
- Tim
- 4 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Ah. So I can't pass a record as an argument to a function. I hope that is on a list of future enhancements. Thank you for the information. (Tim)
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Sorry, I messed up my example a little. The question is how do I specify the argument type when I want to pass a record to the function?
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
A question about user-defined functions: How can I pass a record as an argument? -- Start example function myfunc(somerecord: ) do somerecord.somefield :…
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi, again. I'm really having fun with the scripting features of Ninox! I found the list of new features in Ninox 2.2.0 and would like to know more about the new loop features,…
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Ah, yes. For declarations, like in Swift. So it wasn't a scoping problem, it was that I was getting a new variable declaration (of the same name) every time. Thanks!
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
That works! Thank you! Can you explain the difference between "var" and "let"? Also, can you explain when and why to leave out "var" or "let", as in line 5 and 8 in your example? Thanks again! (Tim)
- Tim
- 5 yrs ago
- Get help
- Reported - view
Re: Reference of Functions and Language
Hi. I want to loop through some records, and detect when some value is different from the previous record. In this example, I just loop through an array of numbers,…
- Tim
- 5 yrs ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics