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
    • 1 yr ago
    • 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
    • 1 yr ago
    • 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
    • 1 yr ago
    • 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
      • 1 yr ago
      • 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
      • 1 yr ago
      • 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
      • 1 yr ago
      • Reported - view

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

      • Fred
      • 1 yr ago
      • 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
    • 1 yr ago
    • 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
    • 1 yr ago
    • Reported - view
    Jacques TUR said:
    and not have to do complicated functions

    😆 Says the guy who is hacking their code! 

      • Sean
      • 1 yr ago
      • Reported - view

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

      • Ninox developper
      • Jacques_TUR
      • 1 yr ago
      • Reported - view

      Sean 😂

    • Mel_Charles
    • 1 yr ago
    • 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
    • 1 yr ago
    • Reported - view

    PLEASE DON'T POST ANY MORE SUGGESTION ON THIS THREAD

    ADD THEM TO THE "SUGGESTIONS FROM MAY 2022 POST"

    • slickert
    • 1 yr ago
    • Reported - view

    Function "do something while typing"

      • Mel_Charles
      • 5 mths ago
      • Reported - view

       this thread is closed.

      Please start aa new thread

Content aside

  • Status Answered
  • 4 Likes
  • 5 mths agoLast active
  • 40Replies
  • 1082Views
  • 17 Following