I would like to piggy back off of this string....
I have several forms that are each filled out by several users.
I have assigned a Date type and User type to each schema which gets automatically filled-in with the current date when the form has been submitted.
I would like to tabularize which forms have been filled out and submitted (filtered by user) by placing the date in a table with a cell value given as that has the info for that specific logged in user, as follows.
^ Form/Survey ^ FormA | FormB | etc... |
| Date Completed | {{$schemaA.submission_date ? filter: "user_name = $USER$"}} | | |
Unfortunately I only get "Nothing found".
PS
I have not assigned a schema to any particular page.
struct list, struct table and struct global all work...
PPS
Plan B (which works): I can create a list instead of a table and do this...
**Schema A completed on: **
----struct list----
schema: schemaA
cols: submission_date
filter: user_name = $USER$
----
and repeat ... but I would prefer the table and to learn how to use the value format for aggregation of data.