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

How to insert a "carriage return" in a formula?

Hi all. In a "Customer" database, based on a YouTube video, I created a formula field that contains street address + City + Province. I would like to have this "formatted"; in other words,…

• Answered

How to disable Create Record button in reference

Is there a way that I can disable the Create Record + button when I add a reference to another table? Ideally, I would like to only be able to use the Add existing record magnifying glass button.…

• Answered

How do I show information from another table, based on user input?

Hello, We deal with a lot of websites for logging in and obtaining oversize and overweight permits. We have a seperate table we use that keeps track of all the websites for each state,…

• Answered

What means these mensage.

Hi what these mensage means, these error simbol ? only apearse in design view, but all work good.

• Answered

Calendar issues

Something not working here ( for me at least) Any ideas? Thanks, John. (have posted this earlier, but can't see the post anywhere. pls. bare with me if it's uploaded twice)

Pie chart for a single record

I want to display a pie chart within a form, that visualises info contained in numeric fields within a single record of a single table. But it seems no matter how I try to construct the forumla for…

• Answered

sunrise and sunset

Would any of you who live in a different time zone than CET be kind enough to test my script? It displays the sunrise and sunset at the site. The accuracy is about two minutes.…

Transferring Filemaker relationship

Hi, I'm transferring some FileMaker Pro database to Ninox and I can't find how to recreate the relationship. In Filemaker, relationship are built out of existing field,…

Comments Section

I have a property database where I send reports after an inspection. Is it possible to create a formula that any comments I add to a property record are then sent to the Ninox comments section on…