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,
David W.
15 replies
-
Hi David,
let's say you have a table Invoices and you you want a View for today Invoices.
Now use this code:
let t := t(today());
select Invoices where InvoiceDate = tIn the field edit screen you can Edit (select) Columns.
-
Sorry...
should be:
let t := today();
select Invoices where InvoiceDate = t
-
Thanks for your feedback, Nick.
-
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 tThis 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.
any suggestions?
the table where the information is is called 'Snorkel/Sea Scooter Guests'
Content aside
- 2 yrs agoLast active
- 15Replies
- 1997Views
-
2
Following