Chat and Comments using the Trebuchet Method

Project Showcase
1

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!!! :slight_smile:
Hope everyone likes the idea!!

15 Likes
2

nice one :clap:

1 Like
3

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?

4

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

4 Likes
5

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

6

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.

4 Likes
7

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

8

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.

3 Likes
9

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

10

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

1 Like
11

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

12

Hope it helps

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>
8 Likes
13

Thanks Pablo! Nice work

1 Like
14

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 :slight_smile:

1 Like
15

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

16

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

2 Likes
17

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.

2 Likes
18

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

1 Like
19

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

20

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

2 Likes