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

Filtering contacts from a specific client

Hello :), I have a Parent Table for my Clients. I have created a child table for my contacts, so I can record them under each specific client. I have linked my Parent Table for my clients to my…

Weird field/formula display on form

Anyone have an idea why this should be? Seems it only applies to this record

Embedding a multiple choice dynamic field

I am trying to build a Dashboard that merges various related records for a single "easy" and consolidated view. I've been able to do this using Views however the one challenge I am having is for a…

Leave formula field empty if .....

Hello. In our quotes, we often have to write some details within line items. But in the printed quote, it show "0.00" next to it. Qty and PPU (Price per Unit) are number fields.…

• Answered

Using dynamic reports

I am going to have a bash at setting up a dynamic report using Word. If I create a 2 or more page template for Ninox as a dynamic report does the pagination follow through?…

AutoNumber increase when duplicating record

Hi guys, I have an auto-increasing number field. "Trigger on new record" : QNumber := max((select Quotes).QNumber) + 1 Works fine. I sometimes duplicate a record because I have a set of sub-records…

• Answered

Bug or Limitation: Combo Box References: Limited Capacity

I created a table with 500 or so entries. I want to create a refernce to this table from another table using the "Combo Box" option for Table Reference.…

Filter appointments shown in Calendar

Is there a way, to filter the Appointments which are shown in the Calendar? E.g. when an Appointment is cancelled, this is recorded in the Table. Based on this "cancelled" can i hide/filter that this…

Setting a color for a TAB - Ninext

@Jacques TUR I have this on a TAB in Display if: which works perfectly, function onUpdate(event : any) do { caption: "LOCATION NOTES", color: "#fcfcfc", backgroundColor: "#ff3333", tooltip:…

• 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…

I am losing records

Yesterday I created about 10 new record, resort them and everything looked good, closed the database and today the records are gone. Made new records today closed the database and when I reopened it…

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…

Column Filter Date?

My table's column is grabbing dates from a subtable. How do I filter the results to show a specific date only? The results I get are for the date I want plus all of the dates of records with that…

Combining two dates fields into single appointment field

Today I have Start and End date fields and I'd like to leverage the appointment field so I need to write a script that will combine them. However the format to do for the appointment field hasn't…

• Answered

How to clear/null a reference combo box

I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a…

• Answered

Sending emails - hit and miss

I have a hit and miss sucess sending emails to my guys. GMail emails do not seem to arrive and others may or may not. The email I send is very basic and has a small pdf attachment.…

Create a PDF in Ninox via Integromat/Make/Webhook/API or "trigger after update" a yes/no field

Anyone knows how can I create a PDF file in Ninox via Make? I have a Make scenario that starts with a Webhook and turns a yes/no field into YES. Then, a "trigger after update" should create the PDF…

Conditional formula

Hello everyone, I have a small question for you: I'm using a "join" formula to show records from a referenced table in the record. I added a number field to the referenced table so I could see the…

• Answered

What is the difference between the font and color tags in HTML?

HTML font tag has three main attributes: color, size, and face. Color is used to define the font color, the size attribute defines the size, while the face attribute defines the font face of text.…

Create a "Place an Order" Database Template?

I'm looking for a template to create a "Place an Order" database. I will have a table of products that can be used to create an order to purchase. I want to maintain a record of past orders.