Show "1" instead UNDEFINED

Good morning everyone, I am writing because I need "Field1" to show the result "1" when the result of the formula is "undefined". Otherwise it must show the correct number, extracted by the formula.…

• Answered

Record create date function

Hello Ninox community, I wanted to create a field that displays the record creation date and which user created the record. Would it be possible to do this?…

Formula fields not visible to other users

I am attempting to create a dashboard and use a lot of formula fields to display data. However, when any other team member views the form, the fields are not showing up.…

Order by date from text field

Hi. I have a date in text field and I want to order it by date. Create a date field is not an option, I need it to be with this text field. Is there any way to do that?…

• Answered

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

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

Search in formula field

Hi colleagues, I have a table that consists of 3 different text fields (lets say A,B,C). These fields are joint in a separate formula field to show them concatenated, too:…

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

Reference to items in the same table

I am still new to the field of databases so sorry if this question is badly formulated. I have a table 'Items' that lists a large number of items that can be associated to one another.…

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

Choice based on field content

This is a typical MAC address for a Dante device: 00:1D:C1:93:AD:3A What defines it as such is the 1D (second pair). I have 4 input fields MAC1, MAC2, MAC3, MAC4.…

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

Sub-Tables - Add existing record

Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…

• Answered

Hours result from appointment field

I have an appointmenet field which has started giving weird results in a formula providing hours worked. This is the formula: duration(appointment(datetime('DAY END'),…

is there a formula to disconnect the link field to a table ?

i would like to disconnect the field linked to the table with a formula. I am trying to disconnect the field when i update another link field. I hope i've been clear. thanks in advance for your help.

Parent / Child / Grandchild

Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…

• Answered

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.

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

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

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

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

URL Field expands off layout view

Hi, I've reported it to support as a bug, but just wondering if there's a workaround in the meantime? I have a couple of URL fields in a database and they're already at the maximum width I can go in…

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…