Mass edit multiple rows

Hi,

I have a table with around 200 records, and I’d like to update one column for many rows at once (but not for all rows in the table).
For example, I have a checkbox column that I need checked for these rows.

Is there a way to do this?

I was thinking about using Automation Rules, but it seems I cannot trigger any rules, since the rows in question are not being edited.
Time-based triggers don’t work either, since they don’t allow changing existing rows.

Thanks!

Can you write JavaScript? I think this can help you to filter and update rows in batch.

I can think of a simple solution:

  1. Create a filter to match the rows you want to modify
  2. Use “drag and fill” or “copy and paste” to quickly change the cells from uncheck to check
1 Like

Thanks for both of your suggestions!

For now, copy & paste is easiest. Don’t know why I didn’t think of that … sometimes you don’t see the forest for all the trees :wink:

Great! You are welcome! Now I’m marking this topic as solved.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.