Sort Table by Surname in another table / show Titles as text

Hey Team, I have various tables within my database based on tblPeople. I populate a dynamic field in each of the connected tables called "FullName" based on various fields in tblPeople.…

• Answered

Where have the Views gone?

I have a simple table of all the images used in the database. They are categorised so I can limit the list when picking a photo for a linked record. I set up half a dozen (Table type) 'Views' so I…

Views are not saved when I close database

Using Ninox locally on my iMac. I create new views (usually Table views) or modify existing views - both in normal and editor mode. When I close my database and come back in - the views may or may…

Two condition nested If not working

I am trying to color a field when days overdue (delta_days) is the below however with the below code, I get either red or green, never Yellow. The second else/if should be skipped when the number for…

• Answered

Formula colour

Hey everyone, here's a question: I have a choice field where I have set different colours for every value. I also have a formula field which is linked to another table.…

• Answered

Export child table

I might be wrong but there doesn't seem a native way how to export records in a child table. Seems the best option atm is to use the ninext from @Jacques TUR https://forum.ninox.…

• Answered

Formula issue

Hey guys, I have the following problem: I'm using a formula which shows data from a table with two columns, let's say column1: "title" and column2: "organisation".…

• Answered

How to Use Constraints

Hi all, Been struggling to understand how to utilise the Constraint field when i have 2 tables linked together. Table 1 is Staff details which contains everything about a certain staff member,…

Send reminder SMS

Hi everyone I am trying to send an appointment SMS reminder referred to an DATA FIELD. How is this possibly, if it is! I look on Zapier, but can't find the right app. thanks in advance.

How to get accurate average numbers?

Hi, we have three shops and in each shop at the end of day we calculate avg price per item and avg purchase per customer. How do I set it up so lets say if i select data for a whole month it shows me…

Send email and include only fields with value

Hello. I do want to send service reports to customers. I have a code which works fine (see below) but I would like to exclude fields from the text in the body of the email,…

Tables sync

Hello everyone, I have the following problem: I have a Table A with X and Y fields and a Table B with links of X and Y fields. If I choose a value on the link X on Table B then the link to Y field…

• Answered

copy and paste table between databases

copy and paste table between databases

Updating Multiple Records with use of a button

I have a database that keeps track of lessons plans for homeschool. I have tables for each of my subjects. The fields include the date of the assignment, the assignment text and so on.…

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

Print and download file name not same as saved filename

Have a little issue that it getting in the way When I print a customer quote the file is also saved into the same customer form in the file attachments.…

• Answered

Loop not clear

Hi there, Although loops are explained in your manual, it is not yet clear how you would, for example, in a table called "contacts" with only "firstname" and "lastname" but where some firstnames are…

• Answered

Reference to items in the same table

I am still new to the field of databases so sorry if this question is badly formulated. I have a table 'Items' that lists a large number of items that can be associated to one another.…

Select multiple rows from en embedded table

Hi everyone, the tile speaks for itself but I will use my own database as an example. I have a database that contains information about art objects. Under the heading 'Administration' I have embedded…

Sending emails reminders automatically in Enterprise version

Hi there. I'm searching the forums but can't find an answer for my needs. We have an Enterprise account, and want/need to send a remainder to our costumers when certain event occurs (time based):…

Duplicate fields

When are you going to update the software to allow duplicating field. I have used my database apps and they all have this very basic ability. It’s a huge omission from your software.

Change location of saved PDF's

Hi there, is it possible yet to change the location of where PDFs are saved when using the printAndSaveRecord function? Being able to do this would seriously cut down on clicks! Many thanks

Unlink Images from database to reduce the size

I have a database of my client session records which is now over 1 Gb in size mainly due to the images. Each session has multiple images of my handwritten notes.…

A link in a text message via button

Like all my posts, I know this is simple, but I can't make it work! Part one: I have a button I use to send a confirmation text to a client after contact.…