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…

CR 2161 - Please provide materialized view / formula fields in the Ninox API as well as expose to Integromat

Perhaps this is possible and I do not know how to do it. I just created CR 2161 - CR 2161 - Please provide materialized view / formula fields in the Ninox API as well as expose to Integromat.…

Closing account

Hello, I've started a free trial, but that works only online and it's not what I'm looking for I'd like to cancel the account I have created. Instead, if I buy the version "on premise",…

• Answered

Formula don't give anything

These Formula don't give me anything, any idea. let x := (select Documentos where Semana = 9); if Week = (select Documentos).Semana then sum(x.'Horas Ganadas Plan') end Thanks

• Answered

Need help with very simple for loop

Hey Everybody, Im a truck driver and a very novice programmer to Ninox. Im trying to setup a database to track my loads and I need help with a very simple code I can't remember from high school to…

API request limit

Hi there. Want to know if there is API requests limit?

How do I move a record to another table?

How do I move a record from one table to another?