Button to modify a cell in current row, not all rows?

I am trying to create a button that changes the date in a cell to Now() in the current row, but I can’t figure out how to do it. Here’s a screen shot of what I have tried, but it changes the date in all rows.

Thank you for any help you can offer!


Hi @Gregg_Stebben,
it’s maybe a bit counter-intuitive but in order to achieve that, you don’t have to select a custom filter, rather “This Row” in the apply to selection.

When you select custom filter you should need to give some conditions that should me met by thisRow.

I try to better explain:

  1. with apply to: This Row the actual formula would be
thisRow.ModifyRows([My Column], Now())

i.e.: Just apply the changes in the button-pressed row

  1. with apply to: Custom Filter and then thisRow the actual formula would be
thisTable.Filter(thisRow).ModifyRows([My Column], Now())

i.e.: Apply the changes in all the rows of the table that - sequentially - are thisRow. So, ALL rows

I hope this helps.

1 Like

Thank you so much for your help!

1 Like