Mass edit multiple rows

User Talk
1

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!

2

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

3

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
4

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:

5

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