-
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
-
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.…
-
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?…
-
How to get filtering to work in a reference field that is set to popup and has columns from linked tables.
Don't know if anyone else needs this but for some reason it has taken me way too long to finally figure out why I couldn't filter a reference field that had columns that showed linked data.…
-
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
-
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.…
-
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.…
-
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.…
-
Dates Overwritten with Epoch Date on Opening
I have a small personal database I am using to keep track of video game releases. Some of the games are not yet released and have no announced release date,…
- Answered
-
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
-
Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Hello everyone, Have you ever had a cold sweat before deleting a field in a table ? I always wonder what will happen. And the more my database is important,…
-
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.…
-
Custom HTML Dashboard
Hello, i was looking to create a custom Dashboard in Ninox to have a clear overview over some important KPIs and also allow controllers to get a quick view at key data.…