Steve,
Can I create my own view by creating a subfolder (called "TodaysVisits") in the tables directory and then create a fields.ini file in that subfolder?
what is the exact syntax for the sql query in the fields.ini
I want to do something like
[TodaysVisits]
__sql__="select *, where (field called "visit timestamp") > today -1, sort on (field called "visit timestamp"), from clients"
This way I can see all records in the clients table that have timestamps of today in order received.
I want to be able to to put an entry in my dashboard.html that looks something like:
<li>
<img src="{$ENV.DATAFACE_URL}/images/edit.gif"/>
<a href="{$ENV.DATAFACE_SITE_HREF}?-table=TodaysVisits&-action=list">List of waiting clients:</a>
</li>