# Chat and Comments using the Trebuchet Method

**URL:** <https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396>\
**Category:** Project Showcase\
**Created:** [April 10, 2021, 4:21pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396 "2021-04-10T16:21:52Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [April 10, 2021, 4:21pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/1 "2021-04-10T16:21:52Z")

</div>

Hey Gliders, so using the Trebuchet Method created by @Robert_Petitto and @Lucas_Pires , @SantiagoPerez and I went a step further and created a chat and comments section that will no count towards your number of rows. Most of the credits go to the creators of this method, we just spiced it up!!! 🙂  
Hope everyone likes the idea!!

https://player.vimeo.com/video/535271331

---

<div class="post-metadata">

**Author:** ![alfonso\_ayala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alfonso_ayala/32/10862_2.png) [@alfonso\_ayala](https://community.glideapps.com/u/alfonso_ayala)\
**Post date:** [April 10, 2021, 5:08pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/2 "2021-04-10T17:08:42Z")

</div>

nice one 👏

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [April 10, 2021, 5:19pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/3 "2021-04-10T17:19:07Z")

</div>

Now we need to find out if there’s a limit on the amount of information we can put in one cell. @david are there any limitations?

---

<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:** [April 10, 2021, 6:17pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/4 "2021-04-10T18:17:34Z")

</div>

According to @Jason you can store 1 million characters in a glide table cell. Google sheets limited to 50,000 characters per cell

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [April 10, 2021, 6:18pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/5 "2021-04-10T18:18:47Z")

</div>

That’s very limited if it comes to a chat then…bad times LOL. Thanks for the info Robert

---

<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:** [April 10, 2021, 6:22pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/6 "2021-04-10T18:22:45Z")

</div>

Yes there’s lots of use cases for the trebuchet method. The limitations are that it doesn’t do well with lengthy content nor does it allow you to easily correlate two values per submission. For example if I’m using it to track user check-ins at various locations, I can track email addresses and I can track timestamps but I can’t easily track which users checked in at those timestamps independently.

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [April 10, 2021, 6:44pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/7 "2021-04-10T18:44:46Z")

</div>

Always good to know these limitations, yet the method is sick 😀

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 11, 2021, 5:50pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/8 "2021-04-11T17:50:28Z")

</div>

I had been mulling over something like this for the community built messenger thread. Just never got around to it. I had the same concerns about maximum character limits for the cell size, but now it’s good to know what those limits are. Nice to see something like this in action.

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [April 29, 2021, 4:51pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/9 "2021-04-29T16:51:02Z")

</div>

@PabloMFalero can’t wait for the user guide to replicate it!  
Well done!

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [April 29, 2021, 5:40pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/10 "2021-04-29T17:40:43Z")

</div>

Hey, sorry I’ve been extremely busy, I’ll make a video next week!!!

---

<div class="post-metadata">

**Author:** ![Harry\_OBrien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/harry_obrien/32/14485_2.png) [@Harry\_OBrien](https://community.glideapps.com/u/Harry_OBrien)\
**Post date:** [May 22, 2021, 6:19pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/11 "2021-05-22T18:19:41Z")

</div>

Hi Pablo, any progress on this? Desperate to replicate this!

---

<div class="post-metadata">

**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\
**Post date:** [May 24, 2021, 10:02am UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/12 "2021-05-24T10:02:28Z")

</div>

Hope it helps

https://player.vimeo.com/video/554209840

Codes:

P: Profile pic  
E: Temporary commenter (Current user’s name) {usc}  
D: Current date and time {usc}  
N: Temporary comment {usc} (Text entry component)  
V: Lookup column rel\_RowID Row ID

Comment

```
P <b style="color:#00819C;font-size:18px;">E</b> <i style="font-size:12px;">D</i> <br><br> N <br><br></h3> V

```

Profile Picture

```
<h3><img src="URL" alt="" width="35" height="35"/></h3>
```

---

<div class="post-metadata">

**Author:** ![Harry\_OBrien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/harry_obrien/32/14485_2.png) [@Harry\_OBrien](https://community.glideapps.com/u/Harry_OBrien)\
**Post date:** [May 24, 2021, 11:02am UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/13 "2021-05-24T11:02:38Z")

</div>

Thanks Pablo! Nice work

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [May 25, 2021, 6:22pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/14 "2021-05-25T18:22:47Z")

</div>

Hi @Lucas_Pires @Robert_Petitto, not sure if my question is relevant given that I did not go deep in Trebuchet (yet…):

- is the idea of the TrebuPiresPetitto to store all messages in 1 cell?
- if yes, is it correct that this cell cannot store more than 1 million characters for all messages?
- if yes, would it mean that, taking macro assumptions, the app allows maximum: 1 M. / 8 (?) characters per word / 10 (?) words per sentence / 2 (?) sentences per message / 100 (?) users = magnitude of 50-100 messages

I am sure that I did understand… **wrong** 🙂

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [May 25, 2021, 6:38pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/15 "2021-05-25T18:38:37Z")

</div>

I’ll let mr @Robert_Petitto tell who he achieved that lol

---

<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:** [May 25, 2021, 6:57pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/16 "2021-05-25T18:57:38Z")

</div>

> [@AyS\_0908](#):
>
> - is the idea of the TrebuPiresPetitto to store all messages in 1 cell?
> - if yes, is it correct that this cell cannot store more than 1 million characters for all messages?
> - if yes, would it mean that, taking macro assumptions, the app allows maximum: 1 M. / 8 (?) characters per word / 10 (?) words per sentence / 2 (?) sentences per message / 100 (?) users = magnitude of 50-100 messages
> 
> I am sure that I did understand… **wrong** 🙂

This is correct. This is why I haven’t used the Trebuchet method for chats…that was @SantiagoPerez

I mainly use it for email addresses ~40chars per email address = ~25k email addresses

---

<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:** [May 25, 2021, 8:05pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/17 "2021-05-25T20:05:24Z")

</div>

We just did this as a fun idea to go a step further with @Lucas_Pires and @Robert_Petitto’s idea but the limitations makes it unscalable. Besides, comments seem to not add to the row count which makes having all the comments in one cell not a real solution to be adapted.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [May 25, 2021, 8:11pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/18 "2021-05-25T20:11:04Z")

</div>

yeah, I’ve already tried this… this makes it impracticable

---

<div class="post-metadata">

**Author:** ![Matt\_Friesen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_friesen/32/2388_2.png) [@Matt\_Friesen](https://community.glideapps.com/u/Matt_Friesen)\
**Post date:** [May 29, 2024, 5:56pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/19 "2024-05-29T17:56:37Z")

</div>

Do you know if the comments/ chat component now (in 2024) contribute to row count?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 29, 2024, 6:31pm UTC](https://community.glideapps.com/t/chat-and-comments-using-the-trebuchet-method/25396/20 "2024-05-29T18:31:26Z")

</div>

> [@Matt\_Friesen](#):
>
> contribute to row count?

Yes it does, because its just normal data stored in a table.
