Table Look Up

If I have a table called 'members': Member Number First Name Last Name 562323 Fred Smith 678944 Jane Jones and I want to upload a CSV file into another table called 'books' Member Number Book Title…

Go to view button

I've seen this before, but not quite sure of the formula. What is the formula that when clicked, it will take you to a specific table view?

Problems with IF Statements

I'm having lots of problems with code being lost after inputting it, then clicking OK. I don't understand why parts of the code are lost. Here are some examples.…

tick any choice on a multiple-choice field with a trigger

I'm trying to make a pre-determinated combenation of choice already ticked by selecting from another field. The syntax could be similar to the following:…

Nested IF Statements

When I create a function like this, I receive an Error: This formula may not modify data: let text1 := "";if Address2 := null thentext1 := "xxx"elsetext1 := "yyy"end;…

How to create a Report

Hi buddies i have structured a NINOX database i need to create Reports on pdf format which could be launched at anytime by Report name call. how to proceed ? grateful for support best! Claudio

trigger for multiple choice

It's possible to checks more then one in multiple choise field with a trigger? The sintax could be something like: if "a" is true then check "1" and "3" in the multiple choice field

I have a problem with the background color?

How do I make 100% background green and 0% red?

Why are related fields apparently returned as an array?

When I try to add a column to a table view using a field from a related table it is returned as so: Count(Name) First(Name) Last(Name) Concatenate(Name) This is unexpected as the related field is…

Is it possible to place the contents of a data field in a filter

Update Value References in a table when an item value in a sub-table changes.

the following is an example of what i want to happen. This is based on the invoice example provided by Ninox. If the Price of an Article changes after it has been included in an invoice,…

Using photos as database background

Hi I'm trying to import an image from my mac Photo file to use as a background image on my database but it installs upside down. Can anyone help.

Know more about function ' Design element / See '

I need to know more about how to use the fuction ' Design element / See '. Thanks. Necesito conocer más de como usar la función ' Elemento de diseño / Ver '. Gracias.

Round up or down

I am trying to create a formula (time) that will round up to the nearest 15 minutes, so 9999002000000 for on the hour, 9999002900000 for quarter after, 9999003800000 for 00:30,…

Text Coding

Hi, I have a huge problem. When i Try to print a report in a PDF the whole codeing gets massy. I use polish language and the polish fonts does not appear in any font.

Synching Issue

Inputting feilds on my mac works fine - and syncs to my other devices (im using single users premium) - but inputting from my ipad does NOT sync to other devices and disappears on closing the app.…

Reoccurring monthly events

Is it possible to set up reoccurring monthly events. For example, If I have an appointment that occurs on the 10th of each month, I want to use one of the data fields to set an appointment for each…

Test-Driven Development

Is it possible to put unit tests for TDD development (Test-Driven Development)?

Different validating field result when validating searching existing record in a table or when adding new record in a table

Hello I'm new in Ninox, need Help! I want to copy automaticly in a field, the result of a search record in a linked table. this is working when the search record is already existing in the table but…

Constraint by Multiple Choice

Hi, I'm trying to constrain a view of products depending on a multiple choice field (called Price Book). The products should appear if just 1 of the multiple choice items is ticked and this same…

cannot see any database in the cloud

Once logged in to Ninox, i cannot see any databases. I see a spot for 'New Team' but nothing else on the screen.

How can this happen?

I have just downloaded the app to my Mac. I wish to keep the database on a passworded .dmg file and so I "Saved the Archive as..." and then closed the .dmg file.…

Adding Images from another table

My apologies for asking such a simple question. I'm a novice and using this for a personal collection of pottery. I have created a main table for my collection with photos I have taken.…

Import issue

Just bought Ninox this am and made my first try. Was willing to import a .csv file coming from FMP Pro 15 : 7 columns (5 text, 2 number), 86 entries. /1/ I created a table on Ninox with 7 columns etc…

Add printPdf

How to add printPdf file in mail, like filemaker. When press on mail button popup mail with name, subject cet. But how add printPdf invioce in mail.