-
The names of the fields are not clear…
When I try to import a base I get "The names of the fields are not clear" What shoud I do ? Thank you When I try to import a base I get "The names of the fields are not clear" What shoud I do ?…
-
Automated creation of a record in subtable
Hi all, I hope you're doing well. I have a master table and a subtable - each time I create a record in the master table, I want a record to be created in the subtable and connected to the main table…
-
Dynamic choice display on iPhone app
Dynamic choice on iPhone app displays numeric values instead of what I would like to see. I have used record() to display the info I want on the OSX app, and web app, but iPhone app displays numbers,…
-
To open each of the two context view menus
Hi In the Ninox manual page 52 and 53 there are 2 different context view menus, how do you open them ? I am on an Ipad. Thank you.
-
Is there a way to enter text field value from a list of 'acceptable' values in a listbox
I have a Payments table in which the Provider field is linked to the Provider field in the Providers table (One field: Providers, unique values - Many to One relationship).…
-
About the sorting
Hi Is there a way to remove all the sorts in one time ? Thank you
-
Is there a command to make a specific field active on creation of a new record?
By which I mean, the cursur is inserted into said field so I can immediately start type without having to click into it...
-
Duplicate some fields in a final summary ? How to do ?
Hello to the Ninox community, There you have it, I have several fields in a form. I would like to know how to include (duplicate) the most important fields in a final summary.…
-
Valore minimo tra periodo temporale fiasstao
Buonasera, ho due tabelle: RISORE e LAVORI. Nella tabella LAVORI ad ogni lavoro assegna più risorse co data di inzio e fine e un impegno (numero percentuale) della risorsa che utilizzo.…
-
Round a calculation to 2 decimals
A claculation field produces a 0,001777777778 result. Any help to round this number to 0,00? Nick
-
How do I change email on my own profile?
Thx Jesper
-
Formula for finding sum based on a condition
Hello, Here is what I have: 1 - A number field where I put in a value 2 - a choice field where I have 3 options 3 - a formula field (in a linked table) where I would like to calculate the sum of the…
-
Is there a way to auto-increment a number field so that the numbers only happen within the subtable record of a parent record?
OK, that's probably not clear, so let me use an example of what I want to do (this is not my use case which may be to obscure, but it illustrates the point:…
-
UNCHECKED spam on this mailing list is more than a nussance.
The UNCHECKED spam on this mailing list is more than a nussance. It is so pervasive that it severely damages the utility of this list as a platform of support for Ninox.…
-
Report Writer
I emailed this to sales and they sent me a link to ICloud but no mention of the Report Writer. ( I have the MAC desktop version and found it easy to use for development of my database.…
-
Returning the last date from another Table
I'm building a beekeeping database. I have a 'Colony Table' which is the parent table. I have an 'Inspection Form' which is a child composition table to the 'Colony Table.…
-
table reference error stating "Return type mismatch for then and else expressions. at line #, column ##
I am attempting to set the link between 2 tables, but I get the above error when I attempt to set the reference Id. I have a button with the below: let Customer := record(Customers,this.…
-
Help with last Formula...
let xFrom := From;let xTo := To;let Cus := CUSTOMER;sum(Invoices['Date of Invoice' >= xFrom and 'Date of Invoice' <= xTo].Customer.133) This does not return the amount shown in the view of Total Shop…
-
How to create a button to start a new Appointment?
Hello and good day to All! I have a table called "Events" where I record interactions with customers (a simple form with selection of date, remarks, choice field to select if email sent,…
-
Roles dissapearing
I created a user and added a new role "allow-delete". I then proceeded to our tables and added the role restriction. All worked fine. I then deleted the user and wanted to add the role to other users.…
-
Recursive functions in Ninox
Is creating a global script function which call's itself not allow in Ninox ? If not what is the best way to create formula's that use data out of a parent-child table structure.
-
Formula to select an exchange rate based on currency and date of payment
Hi everyone, New day, new Ninox puzzle :) I have a series of fields in a subtable recording past exchange rates for a series of currencies (we use InforEuro, so these are monthly exchange rates).…
-
Delete incomplete record
I would like delete a record if on exit I check the absence of the value of some fields. I think the right function is "delete (this)", but how to implement it for this need? Thanks
-
Problems loading database
Good morning,Does anybody else have problems loading their database this morning?/Gry
-
Import makes duplicates ?
Hi When I want to import datas from csv format into a Ninox base and I look to the table wich displays the modifications that are going to be made, I notice that in this table are still datas that…
Answer questions and share your knowledge