# Target Multiple Rows

**URL:** <https://community.glideapps.com/t/target-multiple-rows/63169>\
**Category:** Ask for Help\
**Created:** [June 26, 2023, 3:33pm UTC](https://community.glideapps.com/t/target-multiple-rows/63169 "2023-06-26T15:33:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![James2](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james2/32/60886_2.png) [@James2](https://community.glideapps.com/u/James2)\
**Post date:** [June 26, 2023, 3:33pm UTC](https://community.glideapps.com/t/target-multiple-rows/63169/1 "2023-06-26T15:33:50Z")

</div>

Hello,

Is there a way to select multiple rows in a table?

We have a list of Invoices and I want to be able to check multiple items and then click a button which will update a Paid column to “Paid”. There could be hundreds in one go, so too slow to click 100x. Can I create an action which will set the column value for multiple (selected) items? I don’t seem to even manually be able to highlight multiple rows or select all?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 26, 2023, 3:38pm UTC](https://community.glideapps.com/t/target-multiple-rows/63169/2 "2023-06-26T15:38:39Z")

</div>

You can “select” multiple rows in a table with a multiple relation, but unfortunately it’s not possible to use that to change values via that relation.

The only real way to do what you are asking is to use the Glide API. What you’d need to do is get a joined list of RowIDs, send those via a webhook to an automation tool such as Make, and then use that to update the rows using the API.

---

<div class="post-metadata">

**Author:** ![James2](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james2/32/60886_2.png) [@James2](https://community.glideapps.com/u/James2)\
**Post date:** [June 26, 2023, 3:51pm UTC](https://community.glideapps.com/t/target-multiple-rows/63169/3 "2023-06-26T15:51:05Z")

</div>

Thanks for the reply Darren. Ah that really kills our use case for it unfortunately. What a pain, I’ve been trialing various tools and Glide seems to have been the best so far, but not being able to manipulate multiple rows at once is a deal breaker ☹

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 26, 2023, 4:05pm UTC](https://community.glideapps.com/t/target-multiple-rows/63169/4 "2023-06-26T16:05:11Z")

</div>

There is a technique that uses a bit of smoke and mirrors to give the illusion of changing values in multiple rows - without actually changing them.

I don’t know if that would make sense for your use case, but perhaps have a read of the following:

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

The example that Jeff showcases is used to “reset” values in multiple rows, but the same technique can be adapted to “change” values.