Get help Category

Entering dates into a date field using only digits (and a slash or hífen)

To enter a date into a date field, as far as I know, it is necessary to use the numeric keypad and the alphabetic keyboard.In the case of a date in DD/MMM/YYYY format,…

Connect customer to E-Mail - Help

I am working on making a new e-mail area that can use e-mail templates. I have it all set up and kinda of working but it has problems see screen shots and info.…

number() function stops convert strings with letters

Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .…

Formula don't work but no errors

I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…

• Answered

Appointment function not working

Ever since the last iPhone update I am not able to create or edit more than 1 appointment at a time. When I create an appointment with a start and finish time I have to shut down and restart the app…

Trigger after update record not triggered when linking/adding records to sub-table

I don't know if this is a bug or a feature, but the Trigger after update is only triggered when editing data in normal fields. Any change in a sub-table does not trigger the script.…

• Answered

How to sort on multiple columns in interface?

Is there a way via the interface to sort items on multiple columns (like an ORDER by in a SQL statement) and have the grid view update to show that combined order? Thanks

Native Ninox form embed

Hi there, I wanted to find out if there is a native Ninox form that can be embedded in for instance a WP site. Hoping for a positive response Edwin

Button to print all records in a table (to pdf)

I have a table with 2 subtables, and I would like to have a button so the entire table is printed (on an iPad so this would be a pdf.) I've tried a for loop as suggested in this thread: https:…

Creating an address block from different fields

I have a shipping table with different fields for address components (line 1-4, city, state, post code) I can create a block showing the address without the if formulas,…

Are there Trigger limitations?

I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…

• Answered

CSV Import not working on Mac App

I used to use the cloud version of Ninox to all my databases and used to import data via a CSV file. Recently i moved from the cloud version to the Mac App.…

Design Table for WBS

Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.…

• Answered

Unique Field in a table

sorry but I didnt fund it in the documentation... my bad probably How can I force a field in a table to be unique? eg a field that is used in a N:1 table relationship...…

Integromat "Webhook" Module: Bring the Ninox ID Record

Hi! How can I include the Ninox ID Record as a parameter in a URL (Integromat "Webhook" Module) embeded into an email done in Ninox? I mean: In Ninox I use sendEmail.…

• Answered

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

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

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

How do I move a record to another table?

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

Help with Scripting

Hi, I am trying to add logic to a function that I created that will flip the item status from listed to sold, donated, returned, etc. I would like to put in a safety piece that will prevent this…

• Answered

Highlight attachment icon

Hi, i want to know if there is a way to highlight the clip icon of a record when an attachment is attached to it

How to rename file attachment programatically after import?

Hello! I am adding files manually as Attachments to record. Since "#" character does some issues in Integromat, I need to remove it from name, after file is uploaded.…

Import date format incorrect

This has never worked in Ninox. Whenever I import a CSV file, the date is always way off. For example: "2022-02-3 05:56" will import as "Mar 3, 2022". The only way to correct this is to open the CSV…