Scripting and Functions

Formula with calculation between two different times

I want to make a different text for each hour, and then make the text coloured red when the hour (now) is in between a chosen time. What is wrong with this example? Example: if time(now()) > time(9.…

Is it possible to split the Location field to several address formula fields in Ninox?

I want the Location filed to split and copy the address to several fields like Street, ZIP, City etc, is that possible?

How to create a field that displays all gigs worked within a range of dates?

I have the following tables Event Details, Staff, and a join called Event_Staff_Join. My payroll person would like to pull a list of staff that have worked any event between a date range.…

Show form of combined select (or array) logic

Hello, I want to show something in a form which is a combination of multiple wheres and conditions. I want the entries from table_A which have no value in the field bakery.…

• Answered

Newbie Formula Question

I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…

• Answered

Script to confirm date-time availability

I'm an "intermediate" MacOS app user, with a database to track short-term house-rentals. I need a script to confirm availability or flag date-time conflicts as I enter new bookings.…

• Answered

Ninext loading modules not requested

Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…

Array trouble after update

I have some code that creates 2 arrays of records, which I then combine thus:- array(thoseDirect, thoseDupes) The combined array then gets used in a Dynamic Choice field.…

Extract year from date field in text format

Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…

Auto generated email

hi, I'm trying to automate the email report. Like my aim is to fill fields and then my email would be ready. Here my workflow : Fill fields > Generate email > Mailto from ninox I can generate well my…

Sending emails reminders automatically in Enterprise version

Hi there. I'm searching the forums but can't find an answer for my needs. We have an Enterprise account, and want/need to send a remainder to our costumers when certain event occurs (time based):…

table numbers

Hello I have a reference to a table (1 : N) where all the relevant records are displayed. It would be very convenient if we were able to see the number of the array.…

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

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

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

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

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

Get Previous Month

Hi, Hopefully a simple one. Im editing the body of when the email field is clicked. Whats the syntax to get the previous month. I have tried everything with no luck. Thanks

"Join" script function will not show line breaks

I've just started using Ninox. I've set up a database for my contacts with it. The database has two tables: "Contacts" and "Organisations". Contact details that are specific to individuals (eg,…

How to get a filtered sum() from a table-value, where all have a common category?

I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…

• Answered

Neuer Editor Auto-Ergänzung ist ein absoluter Sch...

Könnt Ihr bitte diese Autoergänzung abstellen oder zumindest in der nächsten Version einen Ausschalter einbauen? Es macht keinen Spaß mehr Ninox-Anwendungen zu bauen.…