-
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,…
-
Locked out
If I go into Options, and Trigger After Open, and then paste in: openTable("Contacts", "Cards");popupRecord(record(Contacts,1)); Thereafter, when I open the database,…
-
Year function stopped working text(year('Date Created')) + "-" + Id
I have a field that assign a project number to each record that consist of the YEAR-ID. The formula I have is text(year('Date Created')) + "-" + Id This morning it stopped working and will only…
-
select and sum the same date values
how can I sum values in a Table1 without the same date? I write this but don't work: let c := Client;sum(unique(select Table1)['Invoice'.'Date' and c = Client].'Amount') Thank you!
-
Numéro de semaine
Bonjour, j'aurai besoin d'une formule qui indique le numéro de la semaine pour une date précise. exemple : 19 novembre > semaine 47..merci pour votre aide
-
Open PDF in app other than Preview?
I don't use Preview for viewing PDFs. How do I change Ninox so it opens PDFs in my preferred PDF app?
-
Embedding an image into an email
Might anyone know how to embed an image into an email sent from ninox? The image would be pulled from an image field
-
Button to Change Value of All Records
Hello, I want to create a button, that when clicked it will modify all data that is referenced from that table. How do I do this?
-
I am getting an "email not verified" trying to send out an email from form. Please advise
I am getting an "email not verified" trying to send out an email from form. Please advise
-
Problems with calendar
Hi, I have a problem with calendar or date functions... Records with date on 1. of November are shown in calendar both on 31. of October and 1. of November. So they're shown twice..…
-
I cannot put the number of flat at the adress in the location field
I cannot put the number of the flat, or sometimes, others important things that describe the adress. For exemple. In Spain is "calle Dortor Madrazo, 5º2ª, 08006 Barcelona.…
-
Change a form field's background color within the script of a button click event?
I have a script that executes upon the click of a button. Can I include a line of code that will change the background color of a field on my form? Thanks!
-
Uniform phone # field
I have imported a lot of data into my data base from spreed sheets not realizing all the phone # are not formatted the same. Is there a way to reformatt the data that is already in the data base to a…
-
exporting all fields
I'm having a problem exporting all fields in pdf, Excel and CSV formats, from my iphone. In all cases the last three of eleven fields refuse to export (they are also missing in the preview).…