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 -

37replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Gianluca
    • Gianluca
    • 2 mths 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”?
     

    Like
    • Fred
    • Fred
    • 2 mths 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. 😉

    Like
    • 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
      
      Like
    • 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

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

      Like
      • Fred
      • Fred
      • 2 mths ago
      • Reported - view

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

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

    Like
    • Sean
    • Sean
    • 1 mth ago
    • Reported - view
    Jacques TUR said:
    and not have to do complicated functions

    😆 Says the guy who is hacking their code! 

    Like
      • Sean
      • Sean
      • 1 mth ago
      • Reported - view

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

      Like
    • Sean 😂

      Like
  • 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!

    Like
  • PLEASE DON'T POST ANY MORE SUGGESTION ON THIS THREAD

    ADD THEM TO THE "SUGGESTIONS FROM MAY 2022 POST"

    Like
Like4 Follow
  • Status Answered
  • 4 Likes
  • 1 mth agoLast active
  • 37Replies
  • 397Views
  • 15 Following