-
"net total" field
I don't understand your "net total" field. How to create it? Thank you Diego
-
Using Ninox Cloud how do I sync multiple devices?
I have a laptop and ipad. how di I sync my devices using Ninox Cloud??
-
Is it possible to hide Multiple Choice values that are not ticked/selected?
Hi. I have a field which is Multiple Choice with a lot of selections in it. To make it easier to see the selected items, is it possible that you can use a formula to hide the values from the Multiple…
-
How to update new number field to contain the table record id
I am trying to copy the contents of the built-in id column to another number column using Update Records. A simple assignment does not seem to work. How can this be done?
-
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…