How customers access the database?

https://www.dropbox.com/s/q745debiyaslnxi/%E5%AE%A2%E6%88%B6.ninox?dl=0 Suppose I have three (or more) customers A.B.C. How do they access the NINOX database (only applicable to the data I opened to…

Move value of field to a new field for entire table

Hello, I need to copy the value of one field to a new field in the same table but I need to do this for all the records in the table. I know I can do it for one specific record at a time but what…

Embed /URL

Hi. Where can I find the embed code or the url to my database?

FILTER ON "ICON"

I created a formula to get an icon as answer : if ACTIF = 1 thenstyled(text(" "), "white", "done")elsestyled(text(" "), "white", "x")end It is better to get an icon than a "Yes" or "Not" in the…

integrated Google Maps Formula.

Good Morning All, I have a formula in pleace in which im trying to add an option for to select if i display a pin location on google maps by either, name of the business, the street address,…

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

Calculation of dates

Is there a formula that will return a date after a certain number of months, years or days from a given date? For example, If the date entered is June 27, 2005 in Field 1,…

Assistance with producing graphs

Hi All I use Ninox as an asset collection tool. So my databases can be 200 lines or 5000 lines. Part of the data I collect is the condition score - Red - Amber - Green And I also put a budget to each…

Slow Mac App

After updating my MacBook OS to the version 26.1 the MacApp is very slow.

Search for parent

When in a child record and clicking the parent field, a large table opens with suitable parent records to choose from. There is also a search box at the top and I don't remember this not working…

Array eficiency

Let's say we want a 'list' of values of a particular field (e.g. Text type) from records in a child table. Easy to do in a Formula field in the parent record,…

Working with Multiple Choice Checkbox

Hi, I have a multiple choice checkbox field in a table (Claim Items) which contains 5 options. That table is related to another table, Claim, so for each of the items in the claim,…

• Answered