Technical Help / How do I define the 'Number format' as 'Fraction Number' in a number field?
geral, if you want a starting point this might help. This code goes into a formula field... let myNum := format(Number, "#,###.##0");let decLoc := index(myNum, ".") + 1;let myDecimal := substr(myNum, decLoc, 3);let myFrac := "";switch myDecimal docase "125":(myFrac := "⅛")case "25":(myFrac := "¼")case "375":(myFrac := "⅜")end;myNum := format(Number, "#,###");myNum + " " + myFrac You can add more c
Technical Help / display problem!
it seems that my table field called produits is inside my Achats form and from that, the display formula start from the Produits table. Anything I try to recover the Achats field seem not to work...it always gives me all the entry corresponding to the product ID... I even try to store the Achats ID inside a formula field and then use it to retrieve the ID_prix_1 value...but same results... all my
Technical Help / Is it possible to link automatically (via a function) fields in two tables that contain the same text?
So, I went in and created a new field in the State table, which is the "relationship" of "from City." I then tried your code, and it ran successfully, filling the new relationship field with the data from the StateID field. I think I misunderstood the steps to make this all happen, and what was going on in the background. This is what I did: Starting point: two tables exist (full of data) with fie
Technical Help / How to sort alphanumerically
Hello there, I have only only recently started using Ninox and I'm finding the user manual a little difficult to understand. I have created a database to manage a gardening associations membership. I have 2 tables, 'members' and 'plots'. The Plots are numbered alphanumerically and some are split, some are not, so we have the following plot numbers; 1 2a 2b 3a 3b 4 5 and so on to 47b with around 90
Technical Help / Button to local folder
@bureaua.... Interesting use case.. I tried the "openURL" function with variations of openURL("file:///dir1/dir2/dir3"); openURL("file://localhost/foo/bar"); openURL("file://127.0.0.1/foo/bar"); But Ninox was smarter than I.. and knew that while chrome (and most modern browsers) understand "file:" as a protocol and will open a directory listing within the browser.. Ninox must be looking explicitly
Technical Help / "Display field only, if" with multiple choice
Hi! I need to show field if some options of multi choice was chosen (one or two or even three) I tried to use chosen function: chosen('multi choice field') => ["Option 1", "Option 2"] but it actually doesn't work even with one option Here how I use script: The function "Display field only, if" works with this script and multi options starts to work in this script, but... But, there are no logic of
Technical Help / How can return a value with a own function?ä
I apologize! I just now took another look at your function, but this time it is on my computer and not my phone. I didn't realize those were comments until just now. I have a question. In this section... "De 13h30 à 18h00";if heureEnMinutes > 810 and heureEnMinutes <= 1080 then myReturnHtmlBarreHeures := myReturnHtmlBarreHeures + "<span class=" + "'apresmidi'" + " style=" + "grid-column-start: " +
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
Technical Help / Help creating Invoice Numbers
I am wanting to set up a unique invoice number that is made up of two elements and I dont know if this can be done. I am wanting to auto number clients simply each client is a new number but then sessions count up from one. So I am currently on client no 510 , but the second part of my invoice number is made up of how many invoices have already been sent. So the invoice for the first session would
Technical Help / Create table with static column?
Hi Dean, Thanks, this seems like it might be what I am looking for. I will have a play around with it now! In a little more detail... Our existing system was modified from the projects template, and so each customer job is a record within the workflow. If we need to order parts, then this currently enables us to link it both to the customer, and view it in the purchase order table directly. Recent