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),…

Unlink Images from database to reduce the size

I have a database of my client session records which is now over 1 Gb in size mainly due to the images. Each session has multiple images of my handwritten notes.…

A link in a text message via button

Like all my posts, I know this is simple, but I can't make it work! Part one: I have a button I use to send a confirmation text to a client after contact.…

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

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)?

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

Modifiche NINOX

Ciao Ninox, quando ci darai la possibilità di avere le sezioni nel menù laterale di sinistra in modo da raggruppare le tabelle per sezioni? Aspettiamo da tempo!!!!!!

RTF to text

How do I convert RTF into text preserving line breaks?

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…

how to lock a cell at a given value?

hello, I have a catalog with the price of the parts and this price is reported on the estimate. the concern is that if the price changes, the amount of the estimate is modified,…

Trigger button and code to open calendar

Hello Ninox Community. Question: Is a code to open the calendar directly while being in a dataset (in my case a dashboard with table view) ? In Ninox you can open a table via button and function.…

How to make a query in Ninox

Hi, I would like to merge several tables into 1 table/view. By this I mean, all fields. I don't know how to do this. In Microsoft Access this is very simple.…