# Find element index with rowowner to update sheetrow with make

**URL:** <https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635>\
**Category:** Ask for Help\
**Created:** [August 31, 2023, 2:55pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635 "2023-08-31T14:55:08Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\
**Post date:** [August 31, 2023, 2:55pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/1 "2023-08-31T14:55:08Z")

</div>

Hello !  
I developed an ap which is working very good. For some reason i need to update some row in GSheet using make (integromat)  
In my table in find the element index and then i calculate the sheet rowNumber and ask make to update one column of this row. All its ok… BUT… i use rowowner and role in my app and when i use find element index for another owner, the result is not good because it only count _n_ rows for this user and not all the rows  
Example :

User 1 : _x_ rows  
Find element index of the last row is 64 (GSheet number row = 66)  
User 2 : _n_ rows  
Find element index if the last row is 4 (GSheet number row =6)

So make update the line 6 in GSheet but that row is owned by user 1…

I dont know how edit my function to solve that “issue”

If someone have an idea…  
Thank you for reading… and help !

Ps : i hope you understood my english !

Thomas

---

<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:** [August 31, 2023, 2:58pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/2 "2023-08-31T14:58:03Z")

</div>

Instead of trying to calculate the row number, add a RowID column to your table, and then send that to Make. Make can then search for the RowID in the Google Sheet and update the correct row.

That said, I don’t understand why you can’t just update the row directly from Glide?

---

<div class="post-metadata">

**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\
**Post date:** [August 31, 2023, 2:59pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/3 "2023-08-31T14:59:32Z")

</div>

Thank you Darren !

I have a row id… and i pass it to make with my webhook. But how can i ask make to update that row ?

I use make, because i update a column with a url file create with pdfmonkey and store in G Drive. I dont have access to the glide api regarding my starter plan.

---

<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:** [August 31, 2023, 3:03pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/4 "2023-08-31T15:03:31Z")

</div>

You need to search for it first. So you’ll have something like the below:

 ![CleanShot 2023-08-31 at 23.02.34@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b38c79919264795cef89e2ca3e8ea8e933058e56.png)

---

<div class="post-metadata">

**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\
**Post date:** [August 31, 2023, 3:05pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/5 "2023-08-31T15:05:09Z")

</div>

Oh ok… i have to add a GSheet module in my scenario ! I tried before with the same module.

I will try and tell you if its working

Thank you very much !

---

<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:** [August 31, 2023, 3:06pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/6 "2023-08-31T15:06:34Z")

</div>

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/a/babe0e0f50f06d1734dde05721a4733d5a6a8fb6.gif)

---

<div class="post-metadata">

**Author:** ![Thomas\_THEVENOT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_thevenot/32/57701_2.png) [@Thomas\_THEVENOT](https://community.glideapps.com/u/Thomas_THEVENOT)\
**Post date:** [August 31, 2023, 3:29pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/7 "2023-08-31T15:29:33Z")

</div>

Yessss !!!

All its Ok now !!!

Thanks you Darren and the Force !

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 7, 2023, 3:30pm UTC](https://community.glideapps.com/t/find-element-index-with-rowowner-to-update-sheetrow-with-make/65635/8 "2023-09-07T15:30:29Z")

</div>

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