hidden table

Trigger Before Closing a DB

The Options Panel has a Trigger After Open box that is executed whenever we open a Database. Is there is some kind of Trigger Before Closing that would be executed after clicking on any button to…

Read File Data

Is it possible to read the actual file data in a record attachment? I'm currently trying to use the ninox programming language to read the actual file contents.…

How to create balance table from income and expense tables

Hi. I two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…

Link to file on computer

Is there a way to link text to a file on my computer? Click the text in my database, the linked file opens.

Can you do secondary sorts within a view?

I would like to have a view that made one column the primary sort, but when that column had duplicate entries, be able to sort by a second column. For example a column for "order number" and a…

Maps and Locations

Hey, I want to perform a search in my addresses database, in a 100 mi radius for example. How do I do that with location fields, or a formua? Is it at allpossible?

can I set and use global variables ?

for example i go to the option panel of my database (admin mode) and i type : let pn := 110;void and then i would use pn (how to call "pn" back btw ? just use pn ?…

Automatic alert for new comment

Hi! I'd like to create a field that 'll show warn icons when 1) comment section contains comments 2) there is a new comment in the comment section Anyone can help me..?

Custom made Icons

Hi, is there any workaround to add custom made icons? thank you

Find Highest Number

This must be simple, but I need some help. How can you display the highest number in field? Example: I have 1000 Records with 1000 different numbers. I'd like to show the highest number and then add…

Trigger After Open

I use this trigger: if ninoxApp() = "iphone"then openTable("TableName", "PhoneView") else if ninoxaApp() = "mac" then openTable("TableName, "MacView") I want when the Table opens to go to last record…

Default value for Location (lat / long)

The following steps are needed to record the current location when using Ninox on an iPad. I see now "default" value. Is there a function that can be called?…

sum and count function?

Is there sum and count function for column

Stuck with custom function...

Hello, I have a custom function to tweak a bit the contains() behaviour to use it together with a view field. My function is this: function containxORisORnull(Msource : text,Msearched : text,Moption :…

Fleno Storage

Hi, Yesterday I had used 2.6 GB of the 4 GB I have and without doing much today it appears as used 4.47 GB. Now I am having problems. Does anyone know why this is? How can I fix it?

• Answered

pdf from html

Is it possible to program a button to generate a PDF from an HTML file?

Is this possible in ninox?

I have a table with time slot records of 15 minutes starting at 9:00am til 7:00pm, like 9:00, 9:15, 9:30 etc. In another table I created services eg. service 1 takes 20min service 2 takes 45min etc I…

Module or another smart way to do things

Hi everyone I work pt at a customer who has several independant companies to set up kitchens. And the customer want some specific items in the independent companies's Invoices, however,…

Execute script in background

Our setup In our database there is a script that executes when a certain field is changed: If ZIP-Code A is changed, check the lookup table for a matching city,…

How to Implement Batch Data Entry and Quoting via a Button After Uploading Product Details?

**Quotes Table Fields:** - **'Customer'**: Linked to the Customer table - **'Quote Number'**: Auto-generated number - **'Quote Date'**: - **'Quote Validity Period'**:…

importing data from csv

Hi there, When I try to import a csv file into a Ninox table, with key update, the first record is not taken into account... How come? Thanks

Clear relationship field on click

I have a button coded to clear fields on my form view when clicked 'Field name' := null But unsure how to clear relationship fields and the signature field? Is this possible?

• Answered

Make some informations confidential

Hello to all, I am the administrator of a database that processes information, some of which is confidential, including to me. These are text or rich text comments.…

Stocktaking/inventory

Hi there, Sure it can be done but how? This very common job takes at least two tables : one with a list of items and one with the inventory lines (very much like the invoice examples less the…