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

New 3.6 Script Editor

Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…

while loop stops before reaching end

Hi everyone, I created a button in one table which is to export some values to another table creating new records there. I am using a while loop to create the records.…

Disable Duplicate Function

Hello, How can I disable the duplicate record function for one of my team members?

Multiple Choice Field - How to get possible values/choices

How to get all possible choices of a multiple choice field? With choose() I can get only chosen values, but I need all.

Calculate integer from decimal value

Hello, For a calculation I need to know the integer part of a decimal value, ie. 34.25 would give me 34 as the integer part. I expected to see a trunc() (or similar) function in the Ninox logic set,…

• Answered

List field content using rsort()

I'm trying to print a list of all entries in a given field between two specified dates. With the precious help of other posts in this forum I managed to get the list but it still brings up all the…

Automatically Displaying referenced data based on String

Hello, I'm sorry if this is a dumb question but I can't seem to figure it out. I'm attempting to use Ninox to help organize summer camps. Based on already imported data,…