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.…

Conversion

Any help on how to convert my Database.ninox back up into a CSV file ? ie From ZIP to CSC or XL file so I can import the data elsewher

How do I express a date to a day, like Monday or Tuesday. Other than using a choice box with a dropdown list. Thank you

Thank you for considering my question

Table within a record of other records in the table

Is it possible to create a table within a table showing other records from the main table that have the same field? So in Record with ID WEV0001216 I would like to have a table of all other records…

How to make a multi-level dynamic drop-down list ?

How to make a multi-level dynamic drop-down list? Thanks.

Printing TAG for inventory

I am creating a workshop inventory, it will include tools, but also hardware, like bolts & nuts, washers, drill bits or paint, brushes and various stocked material, metal, wood, etc...…