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

Passing a field name (string) as a function parameter

I'm searching the forum but I can't find an answer to this question. I've defined a function like this very simple example: function updateField(iField:text, iValue:text, iRedord:…

• Answered

How to Unlock PDF With PDF Unlocker ?

I have a pdf file i need to unlocked how can i unlock my pdf pleasss help me

Create a view based on contains

Hi all, I have a table "Guidance" and in that table I have a multiple choice field named "keywords". Now I want in another table to create a view based on a textfield "keyword selection" - my idea…

• Answered

Send quote to a client direct rather than attach A pdf

I must be getting lazy ! At the moment I can send clients a pdf quote from the system no problem - this relies on a printout being saved to an image field and then when i click the field i download…

Reminders in Ninox

Hello friends, I am planning to write a personal bills management app. I wanted to ask whether is it possible to set/create app reminders in Ninox that customers can choose to flash a few days before…

Bug obtaining a value from a JSON object

I'm trying to use parseCSV to retrieve specific values from a CSV file. After using the parseCSV function with the firstLineIsHeader option set to TRUE, I can retrieve the content of the first item:…

• Answered

No Workspace Access - macOS Desktop Client

Hello Ninox Forums - I built a pretty big database that I use to track my jobs and labor. Work has been slow so I haven't started Ninox in 2 weeks or so,…

1 to N table had values removed

Hello again - I had a problem the other day on the macOS desktop client where I was not able to access my databases. @Fred suggested i delete the preferences via the terminal, which worked,…

If, then 2 criteria

Hi, As always, I'm guessing this is a simple fix and my limited skills with coding are the problem here. I am trying to configure a choice field to trigger on update and adjust a choice field in…

• Answered

How do I change the record's background color?

I made a new DB. I should be able to go into edit mode and click the tab header. That works on my older DBs, but not with this new one.

Is there a way to open a specific database through iOS shortcuts?

With several databases running in Ninox is there a way, using the Shortcuts app to open Ninox and the wanted database (while closing another database if that is already open)?

Switch

Can anybody tell me what is wrong here ? ninox gives an error at case 2 where it says that keyword 2 is not found. I have tried without ";" - same problem, and also tried to remove case 2,…

• Answered

URLs with international characters not displayed properly

I use URL fields to store links, mostly to Wikipedia. In the latest version (I use 3.16.4), links with international characters are displayed using control codes (%xx), for example: https://en.…