# System Jam. Page Couldn't Work when Using Search Bar

**URL:** <https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843>\
**Category:** Ask for Help\
**Created:** [September 8, 2022, 6:00am UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843 "2022-09-08T06:00:38Z")\
**Posts on this page:** 15\
**Page:** 2

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [September 14, 2022, 10:13am UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/21 "2022-09-14T10:13:23Z")

</div>

Hi @ichilddev

Have you sent this in the ticket? If not, add it there so we can have all the information concerning to your ticket in one place.

If you can make a screen recording to show what the issue is, that would be helpful.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 10:45am UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/22 "2022-09-14T10:45:48Z")

</div>

Hi @SantiagoPerez Thanks for your reply.

I have replied your email and added your email into the app. The app basically can’t function now. Can’t update anything at all via glidetable, unless key in the data from google sheet. This also breaks the app, as the RowID is not assigned properly.

See here [Template Does not Reflect Row ID](https://community.glideapps.com/t/template-does-not-reflect-row-id/49275)

Thanks in advance!

---

<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:** [September 14, 2022, 10:53am UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/23 "2022-09-14T10:53:38Z")

</div>

@ichilddev - I just had a thought. Is this the same App that I helped you with sorting that joined list? (Employment History). That uses an external code column. I can’t possibly imagine that it’s related - I use the same code column in many of my Apps - but I guess it would be a good idea to eliminate that as a possible cause.

So I’d suggest deleting that column for now, and see if that changes anything. I seriously doubt that it will, but who knows? 🤷‍♂️

We can always add it back in once your current issue is resolved.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 11:53am UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/24 "2022-09-14T11:53:25Z")

</div>

Hi Darren @Darren_Murphy dont’ think so as we are still able to edit and update records after your addition of the joined list.

Regardless, you may want to disable and then we can check it out?

---

<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:** [September 14, 2022, 12:04pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/25 "2022-09-14T12:04:13Z")

</div>

Okay, I’ve deleted it.

Let me know if that makes any difference. I’ll be shocked if it does.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 12:50pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/26 "2022-09-14T12:50:32Z")

</div>

Hi.

I have added this record

 ![1663159195280](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc3088b664ac6d6d96bfb2a8522e5ba9d5ba9d75.png)

Can be seen in Main page ( 3 items)

 ![1663159219993](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/2/6203e5f21b0b2c1f76c85add6b5ce0705151b8d6.png)

Shown in Editor now. Didn’t disappear.

 ![1663159148044](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/6/76e44f00d3a9cfce62444f9a4b532a018efa3622.png)

But the Glide Table and Google Sheet does not sync at all.

 ![1663159083173](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/8825427084b44c587ffa80d3f88e37472ac4ba0d.png)

Observation:

1. If add a record from Google Sheet, and hit on manual sync, the record is updated in Glide table. But RowID is not valid  
 ![1663159306408](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/14a3f1f31251989941ffa0951592c0c8f660ae4b.png)

2. If add record from Glide table, no record is updated in Google Sheet, not even doing a manual sync.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 1:06pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/27 "2022-09-14T13:06:38Z")

</div>

hi hi @SantiagoPerez

Some updates:

One of our programmer, who has created the google sheet and later transfer owner ship to us, I have his access rights to the google sheet changed to commentor

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1653476353b046e63a1c38f97bbcb7ef6071cdd.png)

Just 5 mins ago, I change it back to Editor, and all the updates we have done via Glide sync and downloaded to Sheet!

How could this happen? I suspect in Glide Table, the access rights wasn’t updated whenever we have updated the Google Sheet’s!

 ![Update and Remove Access Rights for Glidetable - Google Sheet](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88e056d7e8bb16626fbb64fff160c49dda889ab6.png)

---

<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:** [September 14, 2022, 1:32pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/28 "2022-09-14T13:32:39Z")

</div>

ah, okay. That kind of makes sense now.  
What I would suggest is to make a copy of the Google Sheet, and then replace the data source in the App with the copy that you make (Settings → Data → Data Sources)

Just to explain a bit, even though ownership of the Google Spreadsheet might have changed, the original connection to Glide must have been established by the previous owner. So has soon as their edit permissions were removed, Glide could no longer sync with the Google Spreadsheet. Replacing the data source whilst logged in from your own account should fix that.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 1:41pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/29 "2022-09-14T13:41:55Z")

</div>

Do you mean this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b3c25c13ed9d6f5b4377def26ddc66e93fd8500.png)

---

<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:** [September 14, 2022, 1:44pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/30 "2022-09-14T13:44:56Z")

</div>

Yes

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 1:50pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/31 "2022-09-14T13:50:31Z")

</div>

That’s bad! All the integration using the google sheet with third party apps need to be re-established!

---

<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:** [September 14, 2022, 1:58pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/33 "2022-09-14T13:58:33Z")

</div>

Yeah, I was just about to suggest that. You should be able to just replace the sheet with itself.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 1:58pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/34 "2022-09-14T13:58:54Z")

</div>

> [@Darren\_Murphy](#):
>
> Just to explain a bit, even though ownership of the Google Spreadsheet might have changed, the original connection to Glide must have been established by the previous owner. So has soon as their edit permissions were removed, Glide could no longer sync with the Google Spreadsheet. Replacing the data source whilst logged in from your own account should fix that.

So technically, i can remove and add again using the same Google Sheet ID, using our own ID.

---

<div class="post-metadata">

**Author:** ![ichilddev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ichilddev/32/45179_2.png) [@ichilddev](https://community.glideapps.com/u/ichilddev)\
**Post date:** [September 14, 2022, 2:02pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/35 "2022-09-14T14:02:34Z")

</div>

Thanks for your prompt reply.

Should I check with Glide Support team before doing this replacement, if they have a better solution?

Still awaiting for them to revert on the system sluggishness during office hours.

---

<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:** [September 14, 2022, 2:21pm UTC](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843/36 "2022-09-14T14:21:40Z")

</div>

That’s up to do.  
Replacing the sheet is safe enough - as long as the sheet you’re replacing it with is identical to the old one.

[Previous page](https://community.glideapps.com/t/system-jam-page-couldnt-work-when-using-search-bar/48843.md?page=1)
