Sort and filter the child tables on workflow template.
I have two tables, parent and child with strong relations (ispartof : true).
To create the workflow to parent table, when the column on parent is changed, the action is triggered to send email.
On this template, the child table listed in table form on google doc with start expression like this.
<<Start: [Related MOSM Dock Report (Photo)s By Report Date]>><<[Photo]>>
I wonder how to
- Orderby :
I have column with name of “Category” on the child table. How can we alter the start expression to sort the list by “Category” either asc, desc?
- Filter :
Also similar thing, but i wish to filter this table on template by “category” column, to show the specific items only with the selected “category”.
Thank for your attention, but your help is appreciated to get the right syntax to achieve category, filter the child table for template.