Using a button to only click on specific rows

Like that — not possible. When you reference a base table in a formula, it always refers to the full dataset, not the filtered one. I.e.,

MyTable.MyButton

will always try to click all buttons in every row of the base table. You have to explicitly .Filter() your table, which is not possible to recreate with the filter bar because you cannot programmatically access the values selected in the filter bar to use them in a formula.

This is one of the reasons why best practices exist, and one of them is to not use base tables in your ‘for use’ part of the doc but keep them tucked away and use views instead.

2 Likes