sum( where) help needed

I have a table named "Tax" which has a single user entered field named "Year" and then a number of formula fields that are supposed to collect data from other tables (Invoices,…

Save trial database work to my recently purchased Local Mac Ninox environment.

I created a trial cloud database, imported some data from a csv, but now I purchase app for my mac. I want to move the data from the cloud trial to my local system. How do I do this?

Appointment Scheduling Software Help

Hallo i have a patient database in Ninox, i kindly ask if someone have integrate Ninox with an Appointment Scheduling Software. My needs are to have an Agenda that can choose patients from my…

Balance

Dear all, I'm new in using ninox and i'm trying to set up a database to trace my income and expenses. I'd be grateful if someone could help me for a formula that can give me the balance every time I…

Convert table to subtable

I would like to turn a table (B) into a subtable of Table A. Table B provides reference to A already. Many thanks in advance.

• Answered

Can I restrict the share view to specific set of users?

When we activate share view, is there anyway we can restrict view to specific set of users and not make it public ? Also charts view is not seen as chart, it is seen in form of tables.

• Answered

Chart maps null data points a value of "0"

When a chart is drawn and it contains null data points, the null data points are displayed as having the value of "0" In the chart below, all of the data points at zero are actually null.…

Link to locally stored video file

I have built an asset manager for all my footages since several decades. One field contains a picture, generated from the video. As that particular picture is embedded,…

Formula openFullscreen

openFullscreen(openTable("Tablero Avances", "Dashboard")) There are any problem with theses Formula. Sometimes open the table and other the form, I need always open the form, need something more.

Copy text for subtable and paste in textfield in main table

Hello everyone, I have problem that I cannot resolve by myself. I am a physician and I am trying to develop this database to help my patients to get information.…

Formula for Chart Line

I need a Chart Curve for the two columns %Plan vs %Real in the Form view How can I do that.

• Answered

Search view Formula don't work

I Have these Formula for search Ganado Plan but don't work any idea. let Busqueda := Busqueda; select Documentos where 'Ganado PLAN' = " " = Busqueda

• Answered

Avoiding a circular reference

Here's a simplified version of a table I'm working on: closingBalance = openingBalance + Adding - Subtracting The problem I'm running into is that the openingBalance of the next month is supposed to…

• Answered

Integromat "Webhook" Module: Bring the Ninox ID Record

Hi! How can I include the Ninox ID Record as a parameter in a URL (Integromat "Webhook" Module) embeded into an email done in Ninox? I mean: In Ninox I use sendEmail.…

• Answered

Copy field contents into another linked tables field

Hi, I have multiple tables with a many to many link between two tables. I have a text field called Description in the Work table and also a field in the Drawings table called Description.…

How to associate multiple records in one table with a record in another table

Hello. Due to changes in workflow I have a new table (B) that I need to associate with a table (A). Is there a way to associate multiple entries in A with a particular entry in B? That is,…

• Answered

Finding the sum of the last entry given specific text in a field

Sorry for the nonsensical title. I have a table called Bulk Inventory: In a formula in a different table, I want to find the sum of the 'Cumulative (Laa)' values for the final entry of a given month…

• Answered

Conditional Formating for Dates

Hi, I need to create a Conditional Formating for Column FechaP1 to compare with other field DataDate that field is unique only one date. => Value Color The conditional not available for Dates

• Answered

Linking one record to one record

hello everyone I am working on a medical project I have a table with patient information such as name, ID, DOB, etc. I have created two more tables with a questionnaire and a CT report.…

• Answered

Paste Excel cell intor RTF field with simple HTML

Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…

• Answered

Linking populated tables

I am trying to migrate an existing database from Filemaker. I have exported the records from filmmakers as a CSV document and then imported them into a new table in Ninox. So far so good.…

• Answered