All I want for Christmas!
Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that few!) features/commands/functions etc ...
(So fellow users - List your Christmas wish here - To help support, lets keep this list fairly concise! a not stray too far off point! If they miss this post - I will regularly email them direct this list - The more we add and request the same then more chance we have of a possible implementation.
So to get us started -
-
One of the features I think was great in Filemaker was the ability to build solutions where mouse clicks were almost not needed while populating the database with data: I hate to move hands from the keyboard to the mouse every 5 second to add new informations.
At the moment, the best way I've found in Ninox to "minimize" the use of mouse is to use dynamic choice fields where otherwise I should click to open a related table and choose a value from that related table.
Could next updates feature some way to “keep hands on the keyboard”?
-
I think it would be great to be able to use if statements to create variables and then use them in formulas later.
for example:
let t := this; if field1 = null then let var1 := first((select Table1[field1 = t.field1]).fullname) else let var1 := first((select Table1[field1 = t.field2]).fullname) end let newRec := (create Table3) newRec.linkfield := var1gives an error message. you have to put the whole create record part in each section of the if statement:
let t := this; if field1 = null then let var1 := first((select Table1[field1 = t.field1]).fullname) let newRec := (create Table3) newRec.linkfield := var1 else let var1 := first((select Table1[field1 = t.field2]).fullname) let newRec := (create Table3) newRec.linkfield := var1 endIt would be much cleaner if we didn't have to repeat code. I guess I could understand that Ninox doesn't know what var1 will be when writing the code so it can't validate it, but since this is a wish list.
-
Fred try this:
let t := this; let var1 := if field1 = null then first((select Table1[field1 = t.field1]).fullname) else first((select Table1[field1 = t.field2]).fullname) end; let newRec := (create Table3); newRec.linkfield := var1;or if you want to do it another way (more like yours) you have to define the variable first:
let t := this; let var1 := ""; if field1 = null then var1 := first((select Table1[field1 = t.field1]).fullname) else var1 := first((select Table1[field1 = t.field2]).fullname) end let newRec := (create Table3) newRec.linkfield := var1 -
RoSoft_Steven Rooryck What I would like for Christmas is a complete documentation that allows to see all the possibilities of Ninox Script
.
In Ninox, each instruction is a block that returns a value. For example, it is possible to write :join(for i in select Customer do i.'First Name' end, ", ")And the result will be : Sofia, Lisa, Sebastian, Anthony, Maria, Noah, Benjamin, Evelyn, Samantha, Natalie
This means that here the for loop returns a data set, an array of strings
-
Jacques TUR True, as in this example where you can make a json from a select function with customized field names.
-
Thanks Steven, Just needed to switch things around. I guess I should have asked that before posting in the wish list.
-
-
For Christmas, I would love to be able to sort my tables in descending order (select ... order by desc) and not have to do complicated functions that reverse text or return arrays to do this
! -
Jacques TUR said:
and not have to do complicated functions
Says the guy who is hacking their code! -
Maybe better phrased as the guy who understands their minified code well enough to hack it.
-
Sean
-
-
So - I think this subject has been useful and given us a reasonable clue as to what users are seeking/asking for. I have today copied all the thread and sent it off to Ninox support to be forwarded onto the development think tank for them to cogitate over. I have asked them to put a post on this forum to say that have a least read it! - No guarantees but we just might see some of it adopted ! Ps Thank you to all those who posted suggestions!
-
PLEASE DON'T POST ANY MORE SUGGESTION ON THIS THREAD
ADD THEM TO THE "SUGGESTIONS FROM MAY 2022 POST"