4

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 -

40 replies

null
      • Alain_Fontaine
      • 2 yrs agoTue, April 26, 2022 at 2:39 PM UTC
      • Reported - view

      A "single record view". The existing "view" layout element allows to display a set (technically, an array) of records defined by a formula. Its operates much like a 1:N reference field, except that it is read-only. So, among the display modes available for 1:N reference fields, the "Radio Buttons" option does not make sense, but I don't see why "Field" could not be supported. Anyway…

      The "single record view" would be the read-only form of the N:1 reference field, displaying one record defined by a formula. Among te display modes available for N:1 reference fields, only the "Popup", with its "Show as" formula, and the "Embedded" options would make sense. Since the fields of an "embedded" record can be modified directly, being able to embed a freely chosen record could give access to some interesting interaction options.

      P.S.1 for an "embedded" record, it would be nice to have the choice of the displayed Tab.

      P.S.2 I am well aware that a single record can be shown in a view by enclosing its handle in square brackets to build an array; but then it is displayed as a (one line) table, which is not as interesting as a "Popup" or "Embedded".

      • Gianluca
      • 2 yrs agoTue, April 26, 2022 at 9:19 PM UTC
      • Reported - view

      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”?
       

      • Fred
      • 2 yrs agoSat, April 30, 2022 at 2:20 AM UTC
      • Reported - view

      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 := var1

      gives 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
end

      It 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. 😉

        • Ninox partner
        • RoSoft_Steven.1
        • 2 yrs agoSat, April 30, 2022 at 6:34 AM UTC
        • Reported - view

        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
        • Ninox developper
        • Jacques_TUR
        • 2 yrs agoSat, April 30, 2022 at 9:59 AM UTC
        • Reported - view

        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

        • Ninox partner
        • RoSoft_Steven.1
        • 2 yrs agoSat, April 30, 2022 at 10:53 AM UTC
        • Reported - view

        Jacques TUR True, as in this example where you can make a json from a select function with customized field names.

        • Fred
        • 2 yrs agoSat, April 30, 2022 at 1:39 PM UTC
        • Reported - view

        Thanks Steven, Just needed to switch things around. I guess I should have asked that before posting in the wish list.

      • Ninox developper
      • Jacques_TUR
      • 2 yrs agoTue, May 10, 2022 at 11:55 AM UTC
      • Reported - view

      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 🤩 !

      • Sean
      • 2 yrs agoTue, May 10, 2022 at 12:49 PM UTC
      • Reported - view
      Jacques TUR said:
      and not have to do complicated functions

      😆 Says the guy who is hacking their code! 

        • Sean
        • 2 yrs agoTue, May 10, 2022 at 12:52 PM UTC
        • Reported - view

        Maybe better phrased as the guy who understands their minified code well enough to hack it.

        • Ninox developper
        • Jacques_TUR
        • 2 yrs agoTue, May 10, 2022 at 4:06 PM UTC
        • Reported - view

        Sean 😂

      • Mel_Charles
      • 2 yrs agoWed, May 25, 2022 at 1:46 PM UTC
      • Reported - view

      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!

      • Mel_Charles
      • 2 yrs agoWed, May 25, 2022 at 1:48 PM UTC
      • Reported - view

      PLEASE DON'T POST ANY MORE SUGGESTION ON THIS THREAD

      ADD THEM TO THE "SUGGESTIONS FROM MAY 2022 POST"

      • slickert
      • 2 yrs agoTue, February 21, 2023 at 7:49 AM UTC
      • Reported - view

      Function "do something while typing"

        • Mel_Charles
        • 1 yr agoMon, October 9, 2023 at 2:07 PM UTC
        • Reported - view

         this thread is closed.

        Please start aa new thread

    Login to reply

    Content aside

    Categories

    View all topics
    • Status Answered
    • 4 Likes
    • 1 yr agoMon, October 9, 2023 at 2:07 PM UTCLast active
    • 40Replies
    • 1262Views
    • 17 Following