I feel like I’m VERY close to figuring this out, but the last step is tripping me up.
What I’m trying to achieve :
Outside of a table…
- Select a value from a column using a simple select box. Nice and easy
- Press a button which then presses all the buttons in a table who also have a column that matches the select box selection.
Its easy to press ALL the buttons in a table, but I only want a subset pressed. But try as I might I can’t get formulas I think should work to work.
But I’m close. To test, I’ve just written some formulas on my doc - and am able to get the correct filtered list of rows using this :
[Workflow Setup].[Workflow Name].filter(CurrentValue=Workflow_Selector)
maketasks_selectworkflow is the name of my selection button.
Anyway - I can’t seem to amalgamate that into a formula for my button to press buttons in that row.
To try make things clearer, I’ve made a dummy version of the doc and shared it below.
I’ve taken out the button formula that doesn’t work and just put place holder for it to press all buttons in that table.
However, I’ve added the rows to the “task” table that should be there after you press the button - so the intended behaviour if that makes sense.