# Search GIF's and use it in your app? 👀

**URL:** <https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511>\
**Category:** Ask for Help\
**Created:** [June 25, 2022, 7:01pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511 "2022-06-25T19:01:24Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 25, 2022, 7:01pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/1 "2022-06-25T19:01:24Z")

</div>

Hi Community,

What you’ll guys think about this? 🫣

> **[Search GIF's.mp4](https://drive.google.com/file/d/1SXpO4qHUkqVJr9u85TkFV8GqmZMYwNon/view?usp=sharing)**
>
> Google Drive file.

Let me know! 🙌

Thanks!

Have a great weekend!

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 25, 2022, 9:28pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/2 "2022-06-25T21:28:17Z")

</div>

Cool) I wonder how exactly do you transpose results to display as inline list?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 25, 2022, 11:25pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/3 "2022-06-25T23:25:29Z")

</div>

Probably with your rowid \> lookup \> find element index method

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 25, 2022, 11:54pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/4 "2022-06-25T23:54:23Z")

</div>

This looks like GIPHY? I did something almost the same a while ago, an advice is to not show the highest quality GIF on the screen. It can take a long while to load.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 25, 2022, 11:58pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/5 "2022-06-25T23:58:14Z")

</div>

I meant further steps. I noticed that JQquery in Transform JSON column works super slowly and it’s almost impossible to transpose anything with it. On the other hand JS column makes things much faster though the code itself seems to be a little more complex.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 26, 2022, 12:43am UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/6 "2022-06-26T00:43:34Z")

</div>

> [@11183](#):
>
> I noticed that JQquery in Transform JSON column works super slowly

I haven’t noticed it being that much slower. The app I mentioned above used the same technique and it worked just fine in production. I even had one app where I have 100 rows transposed and I didn’t notice any problems.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 11:31am UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/7 "2022-06-26T11:31:14Z")

</div>

I thought a short loom video will be better than a long text message)

---

<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, 2022, 11:40am UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/8 "2022-06-26T11:40:15Z")

</div>

That’s a pretty convincing demo.  
What happens if your API response contains a much larger collection? Is there any change?  
My guess is there would be no change?

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 11:45am UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/9 "2022-06-26T11:45:17Z")

</div>

I didn’t try actually (too lazy)))) But I think there will be no difference. May be the JQ method will work even more slowly)

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 12:00pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/10 "2022-06-26T12:00:29Z")

</div>

Okay, I tried to transpose 37 results from that Chuck Norris API. JS method works well. JQ method shows only 15 lol) And this is a hell to work with the JQ table, it is sooooo slow

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 26, 2022, 1:28pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/11 "2022-06-26T13:28:19Z")

</div>

Thanks for sharing, that is indeed weird. Here’s my case.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 3:45pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/12 "2022-06-26T15:45:05Z")

</div>

Hmm 🤔  
I’ll research this case deeper. Would you mind to share your app as a template? I promise not to distribute it or build something else based on it. Just for the research.

---

<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, 2022, 3:50pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/13 "2022-06-26T15:50:58Z")

</div>

Actually, my guess is that it might be down to network latency. When you use JS everything happens on the device. But when you use JQ you’re calling an external service. So the long delay might just be because there’s high latency between your location and wherever JQ is hosted.

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 4:28pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/14 "2022-06-26T16:28:21Z")

</div>

Oh, that makes sense. I thought that JQ executes on device too. I’m not an expert in programming like at all))

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 26, 2022, 6:06pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/15 "2022-06-26T18:06:06Z")

</div>

Hola @11183

May you share your demo APP in order to see your settings and make some changes using what I do in these cases?

I use another method and use the Fetch JSON plugin only and works perfectly so far. I think I can improve what you are using.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2996a8147641f32713399d2b8fe24141b2b1a67.png)

Saludos!

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 7:38pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/16 "2022-06-26T19:38:25Z")

</div>

Actually that’s a fake app with some fake data. I don’t even fetch anything real, just copy-paste a collection manually. But anyway here it is: [https://hissing-word-6623.glideapp.io/](https://hissing-word-6623.glideapp.io/)

What I’ve noticed from your screenshot is that you use single JQ column to get all the values divided with “,” So I assume then you split it into a Glide native array and use Single Value to get different values one by one?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 26, 2022, 7:40pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/17 "2022-06-26T19:40:30Z")

</div>

> [@11183](#):
>
> What I’ve noticed from your screenshot is that you use single JQ column to get all the values divided with “,” So I assume then you split it into a Glide native array and use Single Value to get different values one by one?

that’s right!

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 7:44pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/18 "2022-06-26T19:44:56Z")

</div>

Clever) But anyway whatever I do JQ works terribly slowly and thanks god (or David😁) we have JS column)

---

<div class="post-metadata">

**Author:** ![11183](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/11183/32/29797_2.png) [@11183](https://community.glideapps.com/u/11183)\
**Post date:** [June 26, 2022, 7:50pm UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/19 "2022-06-26T19:50:56Z")

</div>

By the way, where is Dilon?) Looks like he threw a party here and gone somewhere)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 27, 2022, 12:44am UTC](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511/20 "2022-06-27T00:44:32Z")

</div>

> [@11183](#):
>
> What I’ve noticed from your screenshot is that you use single JQ column to get all the values divided with “,” So I assume then you split it into a Glide native array and use Single Value to get different values one by one?

That’s the same as my approach. Sorry that app was in production and we signed a NDA so can’t share.

[Next page](https://community.glideapps.com/t/search-gifs-and-use-it-in-your-app/43511.md?page=2)
