Carriage Return and Line Feed (CRLF)

Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…

• Answered

Upload file to Ninox via API

Hi there, I want to upload a file to Ninox via MAKE / Integromat using the 'Make an API Call' module. Unfortunately, I do not really understand the API documentation.…

Dynamic Choice as table list/View column

let's say I have a column 'Quantity' in a table/View. I then add/Show a formula column calculated as:- if Quantity = 1 then "one" else "other" end In this case,…

How to get a formulae field to show the result of a Dropdown box instead of a number

Ive got a table of staff names table of scheduling & a table to show the daily allocation of staff. table 1: The table of staff names is just so when new staff join and old staff leave,…

Include links in PDF

Is there any way of including links in a PDF exported from Ninox without the line breaks destroying the link? I have tried scripting it several ways, but with no success.

Filtering data based on manual dates entered.

Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…

• Answered

Dynamic Choice from Dynamic Multi Choice

I have a Multi Choice Dynamic field with which multiple choices can be selected (obviously). I then want to have a Dynamic Choice field, based on that same table but that includes ONLY those choices…

Date suddenly wrong

Dear all, One of our users is suddenly seeing all the dates logged in the database backdated of one day. For example we have a date of 31/12/2021, he sees 30/12/2021.…

New record code needing a tweak

closeRecord(); let thisRecord := this; let myProject := 'SELECT PROJECT'; let myLoc := 'SELECT BUILDING, ROOM & DESCRIPTION'; let newRec := (create 'Project Equipment'); newRec.…

Dimensione del modulo

Ciao a tutti, ho bisogno di un aiuto per aprire un modulo con le dimensioni da me scelte. Vorrei aprire il modulo al centro della pagina. Grazie per un eventuale aiuto

New result line in the console

How do I write a new result line in the console? This is the code I run let LastDate := last((select Notify) order by Data).Data; text(LastDate); while today() > LastDate do LastDate := LastDate +1;…

Normalising existing data

I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…

Chang app logo

I am using the computer version of the program. But now there was a need to display the program logo on the desktop. How can I replace it and use my company logo? Regards

Formula to Include Multiple Filters from Choice Fields

Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…

• Answered

Script editor cannot validate script code

If I insert the script code to execute "a for loop" in my script, the script editor does not validate it and does not save it. if I remove that part everything works.…

erase, remove a date from a date field

Hi There In a date field, I put a future event date. In time, of course, it becomes a past event date... Using either a button (for a specific record) or a loop (for the entire table),…

Linking to a record using the iCloud version

Hello! Is there a way to link to a record using the iCloud syncing? I tried to use the urlOf(this) function as described here: https://forum.ninox.com/t/m1hrtam .…

Code the top search - Help

Been working on my DB and thanks to everyone who has been helping me. I think i am down to the last part that needs to be done and i can start using it.…

Scheduled Job in ninox it's Available?

Hello, i am using ninox NOT cloud version, i should be able to email with the data every evening at a certain time. How can I program and especially where can i implement this work that allows me to…

Running total every 5 days

I want to sum expanse Sunday to Friday in work week expanse field and ignore Saturday to Sunday I can only sum per week by using week function can’t sum 5 days.

• Answered

Ninox Iphone Stuck on Date Field Screen

We have one date field that for some reason get stuck on the select date screen on iPhones only. There are no permission restrictions or anything and it seems to only happen with one field as we have…

Multiple views have changed their column positions and formula columns have disappeared our cloud account. Why?

One view that used everyday just lost any formula columns I had created. It's like it rolled back to a super basic version of itself. Any idea why a view would do this?

Conditional Formatting at a stretch using a Filter

Sometimes I miss the filter funnel in the header which throws me when I know there are more records than I see. Especially if the column being filtered is off to the right out of sight so to speak.…

Expiration date in colour

Hello. I am at loss. Been trying many configurations but can't get the fields work. I have a table with one field called expiration date. I would like the field expiration date to be displayed in RED…