Technical Help / Having records sorted in Table by more than one column
You probably won't like it... :) This is a workaround that requires you to add another field for ranking that would be used in the concatenation instead of the actual descending ordered field. You could update the ranking field using the console, if you like, and make sure you start off with a number large enough that the left most digit is the same for all numbers. let recCount := 5000 + count(se
Technical Help / Get image URL via REST API?
Paul and Dean --> Thank you ... thank you !!!!!!! You both have helped me A LOT! I am very grateful!! == Paul, Finally it sunk in, understood - Got it!!! :-)) I'll have to practice writing some of those GET requests tomorrow. Is the GET Request (code) added to a button? (vs a formula field?) or can be on either? === Dean, thank you so much for your example and explanation + all your help. Now, it
Technical Help / Display chart
Hello, I have a list of dates but want to show volumes of activity in a month. I have managed to create the format of the date by using format(' Start Date', "MMM, YYYY") but what I want to do is to just show activity between certain dates and then order the results by month / year ascending. How can that be achieved?
Technical Help / Trigger after duplicate
@Rich, No worries.. Assume your invoice has a sub table called Items .. and a form something like Notice there is ONE row in the Inovice table.. and it has TWO Items. The code for the duplicate button The keys above are.. let newInvoice :=(create Invoice) ... this creates a new invoice record (AKA record #2). for i in t.Items do ..... this starts the for loop... let newITem := (create Items); ....
Technical Help / Calculation of running balance
OK, I am begining to understand the problem. Your calculation and several of the calculations I've tried do work - except, when records are added/deleted or field values changed, not everything updates. Sometimes, hitting the refresh button helps, sometimes it doesn't. I can see sequences of 10, 15, 20 records where the running balance is working correctly then it goes wrong for several records an
Technical Help / problem with conditional function
Hi! I want to show a bell if today is between two particular days ( Start day, named 'Data Inizio', and End day, named 'Data termine'). I've written this code: if 'Data inizio' <= today() <= 'Data termine' then styled("", "", "bell")end but it doesn't work correctly. What's wrong?
Technical Help / Is there a way of setting ID counter back to 1
I am guessing that you might be confusing the row number column with the Id column. Unlike the row number column, the Id column contains a unique Id for each row. If a record is deleted, the Id number for that record is gone from the table forever. Try going back to the table view. If you do not see a column named "Id", then click the filter icon and drag the Id column from right to left. Now when
Technical Help / Display Field Only referencing Multiple Choice Field
Hi there, Im making a form for multiple services a company offers. At the start I have a multiple choice switch field with 6 values in it, one for each type of service. I then want sections for each service but to only show when they have chosen that service in the multiple choice switch. Im currently using if Experiences = 1 then true else false end which works great if I only have the first opti
Technical Help / How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.
"drdlayton": I think you mean a multiple choice FIELD, because, as far as I know, there is no such thing as a multiple choice "table". (If I'm wrong about that, please tell me. I want to know.) Like "S Moore" above, I don't think it is possible. On multiple choice dialog I don't see any way to import: Many, many questions here asking for help to import odd data sets into Ninox. My solution -- and
Ideas & Suggestions / Month by month table
Check out https://www.ninoxus.com/ ... they have some FREE calendering utilities / samples.. YES.. it is more than possible to create a script that will create "appointments" based on your desired use case.. If you are using the Mac App.. it can even put those on your Mac Calendar if you so desire.. or you can just keep them within your Ninox database calendar view. I would then add a start script