-
Ninox is losing id of functions, am I taxing the app too much?
Firstly, this may be hard to explain. I blasted off a note to support but wanted to ask here just in case. I have an extensive set of functions in the global script,…
-
Can a field appear on TWO tabs of the same form view?
Doing a bit of RTFM (Read the FUN Manual)... https://ninoxdb.de/en/manual/tables/forms I see the following. You can interchange data fields between tabs using drag & drop.…
-
Show day of the week from date field
I have a date field in one of my tables and I want a secound field in the same table that shows the day of the week based on what the date fields input is: Example:…
-
Column Sort doesn't match Order By Sort
When I used this code... ((select Table1) order by Text).Text I noticed that the sort orders aren't the same. This can be fixed using upper(), but I'm curious if that behavior is intentional
-
Sort two fields?
Is there a way to sort by more than one field? I want the second column sorted too.
-
How to count the records and percentage
How to get the data of "chosen", "unchosen" and "percent" thank you.
-
Formula to keep an extra "0" from getting added when scanning in a UPC-A Barcode (12 digits).
I use UPC-A barcode numbers (12 digits) to enter supplies into my database and for searching as well (using an iPad/to scan them). Each time I scan a barcode from a product,…
-
Update city in a new field from location tag.
Can someone help me on this one. Have seen an example based on the US Location, but i need from these string the city "Nieuw-Weerdinge" i have extract this data from my database x.…
-
Neuen Wert bei Mehrfachauswahl hinzufügen
Ich habe ein Mehrfachauswahlfeld mit den Werten a, b, c, d, e, f, g Die Werte a und e sind ausgewählt und ich möchte jetzt per Code b hinzufügen. Wie ist da die richtige Syntax?…
-
Generate Unique Numeric Key for table
Lets assume you want to create your one unique numeric key for a table object and you want to ensure it is of a fixed number of digits.. Here is a quick hack..…
-
Error to sync Calendar with Google
I’m not sure what I’m doing wrong. I haven’t synced to calendars yet, so this is my first newbie attempt. On my MacBook I have the option to synchronize with Google and when I select that option I…
-
selecting a related field in Pivot view
Have a Pivot View (great Feature) Year by Month from a date field and it displays the minimum value without issue. The second data field I wanted to show was the date of that minimum.…
-
variables in views formulas...
Hello everybody, another weird behavior... why does this view formula work let moi := this.ID; (select Interactions where date(start('Rendez-vous')) = today() and Praticien = moi and (Type = 1 or…
-
Formula to Create a random number
I am looking for a formula to create a random 16-digit number. It cannot have any leading zeros.
-
Show sub table formula result in main form
I have a sub table that shows appointments, a marked delivered checkbox and invoice value. Within the sub table I have a formula that will add up the invoice values of all delivered appointment.…
-
Calculate Discount Percentage
This has been driving me crazy. I am trying to calculate the total after taking 30% OFF of the price to get the total, not 30% of the total. I've tried Total :…
-
Scientific Notation
Is it possible to display numbers in scientific notation? e.g. 1.234567e+6 Thanks.
-
Problems using an image field
I am using an image field on a "dashboard" type of form - that is, a "view" form element. I can't get the image field to be in any position other than the left side of the form,…
-
How do I get this space field to the left of the image field?
I drag it to the left, but it won't stay there.
-
calculate difference between field values in current and previous record
Hi, Calculating a field value from 2 other fields in the same record is straightforward.Now I'm trying to create a formula field that calulates the difference between the value of a field in the…
-
Multiple selection returns value
Hello,I wish to know the choice in a multiple selection to be done I have created a formula (see below) but it returns me anything. How can I solve this problem let boite := 'Nature du point';…
-
programming language
What is the programming language used by ninox
-
Forms page settings
Hello everybody, I would appreciate to have the possibility to order the forms fields not only in rows but also in columns. Just add "vertical parting" to "Éléments de mise en page". thanks, Marc
-
Is it possible to make a view with a top 10 only?
Let say I have client and purchase. If I wish to make a view with the 10 biggest purchase for exemple, how should I do it? To sort the result, should I use the built in filter or do it in formula?…
-
Managing precision in number field, seeing non-exact values.
Hopefully this is easy solved, but i am evolving a crypto management system that has large sets of decimal-place variance so i cannot simply limit a number field to, say 7 digits, where some go to 10,…
Top Contributors
Last Month