Technical Help / Creating serial numbers for group and sub groups
I’m attempting to use Ninox to create a filing system that is broken into the following sections - Box - Group - Subject A group is contained inside a box, and a subject is contained inside a group. I want to allocate a “Serial Number” for each group and a “Serial Number for each subject. However, the only method I’ve seen for creating serial numbers uses the fact that a new record is created in a and...
Technical Help / Import data
through software issues but this has me baffled. I have a client database with pre-existing data – let’s say State field. We currently have the client table – State field linked to the State Table and State pops up to be selected. When I uploaded the Client table test data to Ninox – it uploaded perfect! When I uploaded the States table test data to Ninox – it worked perfect! When I linked Ninox C and...
Ideas & Suggestions / Fantastic product – but the color palette …
Overall, I am immensely satisfied with Ninox and happy that I found it. It took a while – based on a vague memory of the usefulness and sheer fun of using HyperCard, as a kid, and early versions of FileMaker, I scouted for some sort of upgraded equivalent for quite a while before I landed here. Ninox is extraordinarily useful for my current purposes, in a way which —even if I was a skilled coder, and...
Technical Help / Getting a 429 Too Many Requests error from my Integromat scenario when accessing Ninox API
Yes the Friday one is 6pm for me, the same time I make dinner and feed my children, it's still a long way from convenient, so far I have been able to attend one out of the last 7 or 8. I don't have an API, I use Integromat. The construction(s) of my code is irrelevant to my question. Firstly if your API has limits then these are either random or they are known. All I require is a document listing and...
Technical Help / Types of parameters for a private function
So, I had some time to kill because the retards in Birmingham, Al closed two lanes of traffic on I-459 for road construction. They could have sent traffic through downtown this being a Sunday and all!!! Here's a version of a user-defined function that replaces a single array item... let myArray := ["Python", "Ruby", "Java", "C++"];function replaceArrayItem(indexItem: text, index: number) do switch
Technical Help / Something strange with U.S. Locations
Folks, I am seeing something a bit strange with U.S. Locations. I want the user to search for a location and select it.. This gives me lat/long that can be used later for routing etc.. I also want to parse that location so I can have a U.S. Postal Address. So.. taking just the happy path for now (not worrying about address line 2 just yet)... I have the following logic... basically .. just split t and...
Technical Help / Setting up a formula field across records in a single table
n, you are correct in that my original answer will not suffice. What you are going to have to do is create a Parent/Child relationship between two tables. In this case, the Parent Table is 'Trips' and the child table is 'Expenses'. You can create this relationship by making the child a component of the parent (to learn more about this, refer to the Users Manual at www.ninoxus.com) Once you have cr
Technical Help / Is it possible to have choice and multi choice fields where editors can enter new values directly into the field, rather than having to pre-define all values?
After, you create one formula field (Fx) and you put this code in « formula » : html(GetComboBoxByArray(“Invoice”, number(this.ID), “Customer”, string((select Customer).ID), string((select Customer).(“First Name” + “ ” + “Last Name”)), number(Customer.ID))) The GetComboBoxByArray function have 6 parameters : - TableDest : text // it is the name of your table destination - RecordIdDest : number //
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 and...
Technical Help / Button to send mail and attachment PDF
You are creating the attached ducument locally (on your machine). Next you tell the server to send a mail. The requested attachment is not yet availale when the mail is to be send. Try this:–––let me := this;do as serverlet Bijlagen := null;let myLayout := "Asignacion comercial";let myNumber := cnt(files(me)) + 1;let myName := "Fidelizacion - " + me.Inquilino.'Nombre Completo Persona' + " " + form