Ninox Profile

Technical Help / Filtering select statements with “choice" fields

You can do it using the text() function... (select inventory where text(category) = "Oil").item or (select inventory)[text(category) = "Oil"].item

Ninox Profile

Technical Help / E-Mail link made with formula.

Jörg, I'm trying to create a work flow where I an write any number of e-mails to a user in a database using standard forms. When I write the e-mail the e-mail text, subject, etc. is logged in the database. This would be to track correspondence sent via e-mail. I could be going about this all wrong. John

C

Technical Help / Filtering select statements with “choice" fields

This select statement doesn’t work; select inventory[category = "Oil"].item when category is choice field but it does when it’s text... is it possible to do this with choice fields? I tried category.value and category.value but those don’t work.

Ninox Profile

Technical Help / How can you relate existing databases, filled with records, in a quick and efficient way?

That is really cool, a Lego Collection dB!!! (I'm sorry, I know I'm not posting anything particularly helpful, but I just had to comment ...) -- what a tremendous collection! :-)

C

Technical Help / Console to test sql/nx statements

Perfect :) thanks very much. Had a feeling it was there somewhere 😀

C

Technical Help / Console to test sql/nx statements

Perfect :) thanks very much. Had a feeling it was there somewhere 😀

Ninox Profile

Technical Help / Can you join a Webinar that's already started?

I don't think that is a problem. You can always join mid webinar...

Ninox Profile

Technical Help / Can you join a Webinar that's already started?

I'd like to join the Webinar next Tuesday, but I have an appointment that I must keep. If I did the time zone conversion correctly, it starts at 11:00am CDT and I will likely not be able to join until after that time. Thanks

Ninox Profile

Technical Help / Can I install Ninox on two computers?

If you want to be able to access your databases from virutally anywhere... The Ninox Cloud account is the way to go.

Ninox Profile

Technical Help / Console to test sql/nx statements

Yes.. there is... Go into admin mode by clicking on the wrench in the upper right.. Then select console.. Then have fun!

Ninox Profile

Technical Help / I don't have a iCloud link on my Ninox start page

Absolutely NO scam. Ninox is one of the BEST software companies I have had the pleasure working with over my 30+ years in Information Technology (IT). Their weekly webinars and support are out of this world. Yes.. the Mac App is $34.99 (USD) ... the Ninox Cloud version is $8.33 per month.. as they say.. the devil is in the details.. They bill it annually ... so $8.33 x 12 = $99.96.. Which version

C

Technical Help / Console to test sql/nx statements

Is there a console or someway to run arbitray nx/sql statements? I'm finding the nx script a bit confusing and there's not any way I can see to preview statements to see their result outside of alert() boxes which is clunky.

J

Technical Help / I don't have a iCloud link on my Ninox start page

the Apple App store says the Mac OS ver is $35.00. on the Ninox web site if i click upgrade its about $100.00 . whats this some kind of scam? Certianly apperar to be.

J

Technical Help / I don't have a iCloud link on my Ninox start page

Im using the Nixox Cloud trial. do you have have a trial for the Mac OS ?

2

Technical Help / Can I install Ninox on two computers?

I purchased Ninox database, and would like to have a copy on my laptop (older) as well as my iMac so I can look stuff up while away. Can I install the same copy of Ninox db on this computer?

A

Technical Help / Ninox Display is Unpredictable

One of my primary pet peaves with Ninox vs other database is that its so unpredictable, and you never know what it's going to display next. One example is when copying and pasting values from records, the display will often change from a grouped view to an ungrouped view, putting the records in different positions. To replicate this, just add a group to any view, start copying and pasting and you

Ninox Profile

Technical Help / I don't have a iCloud link on my Ninox start page

What platform are you running on? Here is an example of the Mac app. Once opened.. you see the cloud icon.. Is this the one you are referring to? And local databases do not have the clound sync.

Ninox Profile

Technical Help / right syntax of a trigger with double condition

Use "and" instead of the comma... let jj := cnt('3. Commissioni'.'Elenco Workflow (tutti)'['TODO.2' = 31 and CHIUSURA = null]); Similar to your if-condition.

Ninox Profile

Technical Help / Can you do secondary sorts within a view?

Steven, that works kind of OK for my similar situation (fields SUBMISSION DATE and PAGES) - but it mashes the fields together and forces both to sort in the same direction. Can one field sort descending and then the other sort ascending? Is there a piece of script to make that happen? I want to most recent submission date items at the top, and the pages to start with 1 at the top.

Y

Technical Help / right syntax of a trigger with double condition

I want to make a trigger that is execute on ly in case of 2 condition of the same record are verificate….but I don’t find the way with the syntax….I tried with comma, +, nothing….but in everyone of these the formula ignore the first condition ['TODO.2' = 31] and consider only the second [CHIUSURA = null]) below an extract of the formula..———————————————— let jj := cnt('3. Commissioni'.'Elenco Work