How to use the "View" element
Hello, when we create a database, we can add an element called "View".
Can you please tell me how to concrete use this field?
Because I always get the error message "Expression does not returns records" when I want to define the columns.
Thanks in advance for your help.
Have a nice day,
Just came across this post.
I am trying to use the "view" Function to view certain guests of a table for that particular day for a particular event.
My current code is:
let t := today();
select 'Snorkel/Sea Scooter Guests' where Tour = 1 and t
This is showing guests, but its basically listing every guest on my table that is on tour 1, regardless of the date they are booked on.
the table where the information is is called 'Snorkel/Sea Scooter Guests'