-
Popup related record
I can't seem to get this to work at all: Two related tables: Start and Users. Users table has Id field and User Card Number. All I want to do is enter the User Card Number from the Start table and…
-
Strange behavior
When you subtract two numbers from different fields and then convert the result to text and then get the length of the text, the comma will be counted if the number field being subtracted from is…
-
Is there a plan tot introduce "before create" and "before update" triggers
Hello, Will Ninox support "by create" and " after update" triggers. Is there a plan to introduce alse "before update" or/and " before create" triggers, that would be very helpfull.…
-
Projects
Hello. I have a main table called projects and a sub table for my submittal log and i want to know how i can autogenerate submittal numbers? They are 3 digit and every project starts at 001 my…
-
Time rounding
Hello everybody. How do I round a time (Zeitdauer) to the next 0.25? If it were a normal float, it would be `round (number * 4) / 4`, but it is not.
-
signature
I want that the custumer my order signt bur how can. i do that?
-
format time in hh:mm
Hello, how can I format a field to display it in hours and minutes? I have a function field named "Duration" wich display for example: 2 days 0:28:14.358 and I want to show in hours and minutes as 48:…
-
Calculated field
Hello, I’m new to Ninox and would like to have a calculated field (age category) from birthdate. I have DatNai field which is birthdate. I created ‘Categorie Age’ that I’d want to populate.…
-
Zapier
Hi, i don't find yours app "Ninox"..
-
Choice field changing text field
Hi! I have a choice field with multiple options and I'd like to change a nearby text field. Can I do this? I'm trying something like this in the "trigger after update" of the choice field:…
-
use if logical syntax
Hello, I have on y calculated field this logical formula: if Usuario = "ESM" then 1 else 0 end . But it does not work, even if the field Usuario contains the text "ESM" it always give me 0.…
-
calculate time elapsed between two concomitant records
Hi, I would like to know how to calculate time elapsed between to concomitant records; for example a record have a field named date_time and I would like to know the time elapsed between record 1 and…
-
Datum aus Datumsfeld mit einer Anzahl an Monaten addieren
Hallo zusammen, mal wieder ein "Problemchen". Ich habe ein Datumsfeld und einen Turnus (monatlich, vierteljährlich, halbjährlich, jährlich). Je nach Turnus möchte ich das Datumsfeld + die…
-
How to make the selection of a value in one choice field force the selection of a value in another choice field
I've tried the following formula, but while it doesn't throw up any error messages, it also doesn't seem to have any effect! if 'Choice 2' = "A" then'Choice' := "Q IN"else'Choice' :…
-
Customized view when searching a linked table?
When I enter information in the data entry form, I have a field for a linked table that I can either search or add a new record to. This is standard for Ninox.…
-
Dove finiscono i vari database creati ?
Se io creo database diversi, dove vengono salvati ? Ho provato a fare un database con dati sensibili (inventario oggetti valore), alla fine ho salvato questo database su un supporto esterno e poi…
-
How do I un link a table from another table? Can I link one table to a number of tables? Can I link a single entry to another table?
How do I un link a table from another table? Can I link one table to a number of tables? Can I link a single entry to another table? Eg tables:- Workers Field Hands Packers Machinery Workers Can i…
-
How to update column with existing records to match the imported data
I am new to Ninox and imported data from excel into connected tables. I want to transfer the data from the excel-imported column to a ninox-created column. How do I transfer the data over?
-
Importing dropdown lists
I have a csv file where some of the fields were dropdowns (=select one item from a list). When I import the csv file and set a set a field to "Choice" in the import assistant,…
-
How to sync my data base netwenn Ios and web?
How to sync my data base netwenn Ios and web?
-
Automatically move data
Hi, I have 2 tables one called “Banned” and one called “Previously Banned” the tables fields are identical. Is there a way i can get a record to move from the “banned” to the “previously banned” once…
-
Views: Filtering Values
Hi, Ninox support, I have a table with a column "Age" (in years). If I want to enter the value as years and months, (e.g. 2 yrs 4 months), how should I do? And then,…
-
How to link add data with a button click
Hello, I have this formula let p := (create Renovaciones);p.(Temporada := "2018-2019"); that let me add the p. to the table Renovaciones. In Renovaciones I have a box for the current user linked.…
-
How to calc sum of date specific entries in one table from another
Hi, I’m new to Ninox, having come from HanDBase for iOS (which I found had a simpler method of calculation). I’m trying to create a table that summarises entries in another table for a given date.…
-
Can you place the "€" signs left in a tabel and the amount on te right in printing mode?
I would like to print invoices. I juse a table to include al the products. The position of € is based on how much digites the amount is. Can I chande this by lining the € sign to the left of the…
Answer questions and share your knowledge