Problème avec loadFileAsBase64(Photo)

Bonjour, je n'arrive pas à faire fonctionner : let photoData := null; if Photo != null then photoData := loadFileAsBase64(Photo) end; J'ai la roue qui tourne sans fin avec une photo de 60ko… La…

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

setting up user instructions for using a table

Hi - I have two staging tables in my database, each of which is setup to import a .csv file and (with a scripted button) process that imported data into permanent tables.…

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

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

Multiple choice field (dynamic)

Does anyone know if I can have such a field in more than one column ? The case is that I have a table called keywords, which occur in a MCF (dynamic) field, and it works perfectly.…

• Answered

Product from multiple records

I have several data records with a field “Year” and “TWR”. For each year, there are multiple records with different TWR values. Now, (in another table) I want to calculate the product of the TWR…

add Rich Text Fields

Hi there I have several rich text fields I want to combine with the format they have. To make it easy let's say that I have RT1, RT2 and Endresult. If I say Endresult :…

• Answered

Resetting a Page Field...

I have a page with a search field (Text) and a "clear search field" button next to it. Is there a way of pre-setting or clearing that field PRIOR to opening the page - effectively clearing previous…

• Answered

I can't edit fields?

I cannot edit fields in most of my DBs. Why might this be happening?

Formula error? What is wrong?

I have a number field "Buy In Cost", and a formula field "My Buy In Cost", which is = to the field "Buy In Cost". Here's my entry: Here's the formula results.…

Date insertion

Dall'ultimo aggiornamento quando vado ad inserire una data il programma inserisce automaticamente il giorno prima

What does Sync app do?

Look up/search a single record with GET returns array instead of an object

Hello is the documentation wrong or am I missing something? There is an endpoint Look up/search a single record with GET that is GET…

Are these all errors?

Is there documentation regarding what these badges mean? I think the red ones are errors. If so, how am I suppose to fix them? This screenshot shows only 1/3 of my fields.…