A few questions about form layout

One of my biggest hurdles with Ninox forms has been setting up the style and layout I want. Hoping people can help with these specifics: - When i put a View element on a form,…

copy records to a other table

copy records to a other table Itried with copy paste to a other table butI could't paste it; is there a video for this problem Thanks for your help

Layout PDF View

Hi :), I'm working on my invoice template. The issue I have at the moment is when I had more than 10 Items on it, my invoice goes into 2 pages (wich I don' mind) but split this part ( see picture)…

How to assign a table's identifier to a variable, i.e. not hardcode table names in functions?

The openTable("table", "view") function uses strings as parameters. This is great as you can read a table name from anywhere (e.g. a field value), e.g. let t :…

How to avoid a column to be filtered from the table list view?

Hello. How can I avoid my users to change a established filter from "yes" to "no"? I mean, the result is always in "YES", but I can't allow them to change the filter into "NO" (or remove the filter).…

Can I with a field from one database open field in another database?

I have 2 databases as attached. One with appointment and the other with medical record. I need to say that when I click Jose Pedro on the schedule, he takes it to Jose Pedro on the medical record.…

Assign RGB color to a choice field

Hello, I am not able to find how to assign a RGB color to a choice field. After assigng values to the RGB palette (attached file F1), clicking anywhere or pressing Return does not assign the chosen…

Create button in Ninox that composes an email using email client

Hello, I was wondering if anyone can help me with a script that will allow me to compose an email, where the data is across 2 tables? I want to compose an email from a Quote layout I have built,…

Get error using "number(chosen(field))" inside a formula

Hi there, I'm trying to use a field “Choice” (“Selección”, in Spanish) inside a formula, exactly like it's described here:…

Global script definitions

Hello, What kind of information, commands, ..., can I use in the Global script definitions? I thought I could define there global variables, etc. I tried to do that,…

How to manage two-way multiple table references?

Hello, I am new to Ninox, and new to any kind of database building so please excuse me if this is a naive question. I am building a database for farm records that include 'Plots' and 'Inputs'.…

How can a count the number of letters and space in a field ?

How can a count the number of letters and space in a field ? What i need to do is to complete a field always with 50 letters or spaces. Exemple: "Home" is a 4 letter word.…

Make colour of text in report change dependant on data in field

Is there a way I can make the text in my PDF report change colour based on what data is entered for a record? e.g. red if text is NO and green if text is YES.

Formula Button to open a specific record

Hi, I have two tables, one for my estimations and one for my invoices. I input all the information into my table estimation. In my invoic table I only have the invoice date and invoice number,…

Possible subform fault - reposted as original posts not posting body text

Issue: Lost sub form on data model? I have spent quite some time looking for a sub from that exists but no longer shows up in the data model and trying to understand why.…

Single page formatted print of all records in a table

I have just started trying iPad Ninox (after around 20 years of using MS Access) and am generally very impressed. However, I need to produce a nicely formatted single page printed report containing…

possible subform fault - just a warning

Possible subform fault! - just letting you users know!

How to pick up single value from related table

Excuse my ignorance but I am new at this. I have two tables, the first table is called 'Paper Catalogue' and is a list of items and their prices. The second table is called 'Calculation' and has a…

select not working

The following is not working as expected (I think). (select Table1)[Id < 50].Col2; Table1 is a table with a few records, some with Id less than 50. Col2 is a text field, filled with some text.…

Disable the create record on the left

Hi :), Is there a way to disable the cross button on the left to create a new record in order to just use the create record cross on the top right?

SQL to sum the sessions for only the current month

Hi, I have this code behind a button and when I click it I want it to populate a table with various information (which is partially working) let me := this;for i in select Pupil dolet myInvoice :…

Limit view to sessions scheduled for next month

Hi all, I have this form which is a reference to another form - all I want to do is for it to show the sessions scheduled for next month, I know I need to use the month function but I'm not too sure…

Console to test sql/nx statements

Is there a console or someway to run arbitray nx/sql statements? I'm finding the nx script a bit confusing and there's not any way I can see to preview statements to see their result outside of…

I am making changes but Ninox isn't asking to save them

I am making changes to a formula field but, after clicking the OK buttons, Ninox isn't asking for the changes to be saved and the amended formla is being ignored.…