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?

New Record with prefilled date field

What would be the code to put in "on Create" so that when the new record is created, the Date field is automatically completed with the next date of the previous. Example.…

Look up value in table based on two other values

I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…

• Answered

Selecting Multiple Records in Table View in Order to Update

I frequently need to update multiple records in the table view. How to I select multiple records in order to these the Update Multiple Records function without using the Select All Records menu item?…

Speed issue

I have some speed issues with statements like this, is the a way to work around summing another file let xTM := Termijnnummer; let xWerk := Regel; let xProj := Project; let TVT :…

Button in table x (subscription) to create a record in table y (Deliveries) and its subtable y2 (Delivery lines)

Hey so we work with a subscription formula so the products the customer gets is preset in fields in table x (max8). I want to create a button in table x where when you click it you create a record…

Repeat Appointments

I would like to know if it is possible to repeat appointments. I have several tours that occur everyday at the same time. is this possible to do on Ninox? thanks for all the help