Fields and Elements

writable if - otherwise calculate from another field

Hello, I have a numeric field for a measurement in inches, and a second for a measurement in centimetres. When I enter one I would like it to auto-calculate the other.…

• Answered

Different results using Checkbox vs Button to update text field with today() using the exact same code

I was having an issue with dates not storing correctly with some of my code. The code was storing dates as the next day instead of current day. While trying to figure out where my problems were…

Sending Emails using the Email Field Type

I am having untold problems sending an email using the standard Ninox email field type. Apart from a bunch of other issues I cannot for the life of me figure out why some email addresses allow me to…

Sending email from other than userEmail()

I use my self developed, self owned, application under my personal email for work. When sending emails it uses my personal email which is understood. Is there anyway to have the email sent using my…

Formatting an email

This is the relevant portion of the email code I am trying to fix. Issue is where the Bod of the email is placed. I simply cannot figure out how to get it 2 lines up from the Please refer to attached.…

Pop Up vs Combo for links.

I am trying out the use of Combo box for 'Show Field As' rather than Pop Up. I like the Combo Box option but it seems that there is no way of circumventing the field choices (when using Pop Up)…

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