Format a Formulae Field to Show time
Trying to work a formulae field to show the data of a Time field in another table.
My current Formulae is
(select 'Private Snorkel Booking')[Session = 1].'Tour Time'
Result is a blank formulae field.
Im assuming its because i need Ninox to recognise it as a time. When i change 'Tour Time' to Name, it works by showing the the data in the Name field.
Remember that Ninox always returns an array (even if it is one record) when doing a select. Sometimes Ninox will figure out that you want to return the value in a field, but it is good to get into the habit of telling Ninox how you want to process the array.
first((select 'Private Snorkel Booking')[Session = 1].'Tour Time')
If the table has a relationship to ‘Private Snorkel Booking’ then you don’t need the select and then you won’t the array functions at the beginning.