How to use the "View" element

Admin The "and t" doesn't make sense to Ninox. You need to provide a field for it to check agains.

Try:

let t := today();
select 'Snorkel/Sea Scooter Guests' where Tour = 1 and DateFieldName = t

or you can remove one line of code and just put:

select 'Snorkel/Sea Scooter Guests' where Tour = 1 and DateFieldName = today()

Fred Thanks for the suggestions.

I have tried both lines and no data is showing.

here's a screenshot of the table name and field that I can't seem to get Ninox to recognise.

here is the table that i am trying to pull information from.

this is the code that i currently have

select 'Snorkel/Sea Scooter Guests' where Tour = 1 and 'Date of Tour' = today()

the table is called 'Snorkel/Sea Scooter Guests'

and the 2 fields that are unique is the Tour must = 1 and the date must be the day the form is in.

@Fred i tried

select 'Snorkel/Sea Scooter Guests' where 'Date of Tour' = today()

just to try and get the table to show something unique to that day and still showing nothing, which tells me that Ninox does not seem to recognise "date of Tour' and today.

Admin The table of Guests, is that view element or the actual table name?

Fred that's actual table name

Admin the name on the tables is just the name ive given it for the field, the actaul table is linked to the form that i am working on

Fred  the name on the tables is just the name ive given it for the field, the actaul table is linked to the form that i am working on

I tried something similar:

(select Table2)[Date = today()]

and it works in a view element for me, so the structure works.

It is good that you simplified the code to check the logic. Now can you check that you have records in 'Snorkel/Sea Scooter Guests' where 'Date of Tour' equals today. If you want you can hard code the date you show me "13/05/2022" in place of today() and see if that returns the record.

Then my next question is the field Tour in the 'Snorkel/Sea Scooter Guests' table. My wee brain is having a hard figuring out your tables and fields and relationships.

Fred thanks for your assistance, Ill break down my table relationships

I have a table/form called Snorkel / Sea Scooter Bookings. This is the "main" form where the details for each tour is completed.

I have been using the "tab" feature to break up the table making it look more user friendly.

I then have another table called Snorkel/Sea Scooter Guests which is linked to the first table with a

"Reference from Snorkel/Sea Scooter Bookings to Snorkel/Sea Scooter Guests" This table is also Compositioned to the main table (Snorkel/Sea Scooter Bookings)

The idea is that each "tab" on the main table shows information for particular tour. the last "tab" is where the staff can add a record to the Guest table that is linked.

The view function was to then show just the guests that are booked on a particular tour in the relevent tabs

as shown here:

Fred I inputted that code 

(select 'Snorkel/Sea Scooter Guests')['Date of Tour' = today()]

and it does show me the guests. but as before, it is showing me all the guests that are on the table, regardless of the date. as shown below

Please note that the guests in this picture are fictional

Fred Thankyou very much for your help. I Flukely worked it out.

I assigned 'Date of Booking' to the Date field in the Main table and then told the 'view function' to lookup guests in a certain group and with their "Date of Tour" to match the date in the main table.

Sounds to simple once you broke it down.

let 'Date of Booking' := Date;
(select 'Snorkel/Sea Scooter Guests')[Tour = 1 and 'Date of Tour' = 'Date of Booking']

Still got more tests to do to make sure this is the fix but fingers cross this works