Concept of how to make something with google sheets

[Tyller_]

(This is a question targeted towards ppl like Jeff who may have experience with stuff like this)

I have decided I’ll use google sheets for my chat room project after creaticode mentioned it had a limited number of rows, my question is, I need some ideas for how I would do this. I have a few ideas but what to know if anybody has any other ones, I just want to not have to read the sheet every time I write (to check for next message) because if people send messages too quickly next to each other, it could overwrite. Any ideas are appreciated

[info-creaticode]

@tyller_

One way is to make sure each user writes to a unique column, so 2 users will never write into the same column, and each user can read the columns of other users to get their latest messages.

[Tyller_]

@info-creaticode that’s a really good idea, though the issue is how would I do per world, now that I think about it I could use the same method but with a massive sheet of all the worlds and users, and use a mark system or a user data sheet for what worlds a user is in, thank you for giving me the idea! (any suggestions on what I’ve said more of would be appreciated)

[info-creaticode]

@tyller_

Maybe we can give you a new block to create a new tab in a google sheet?

Or, can you create a new google sheet with 100 tabs manually, then recycle them when a new user comes? It depends on whether each user needs to keep the data permanently.

[Tyller_]

@info-creaticode I think I can have each instance of a user in a world be a separate column in a messages table, then I fetch it all and just filter through all columns (actually I may have it go a row per user so I can fetch it by the entire row) for any rows that are for the world (semi complex filter with row number of item containing and some smart data formatting), put them in a separate table/list, and append them to the chat, though a new tab/sheet block would be quite nice and likely convient for quite a few projects with google sheets

[jeffreyrb03-gmail]

@tyller_ Just treat google sheets like a giant table or database and you’ll be fine. The current blocks work with you can retrieve rows and columns to a table and also copy your table over to a specific range in google sheets. I wouldn’t use it for private things like passwords or chat messages though because they need to be public for CC to read and write to it so that also means anyone can access it. Even semi private things I wouldn’t wanna mess with too much like simple user data, but I’d rather use it for public things like names and whatnot.

[Tyller_]

@jeffreyrb03-gmail any that I use with creaticode I have the project not shared, if I really want to share it to some ppl I can just use my alt to host and share with friends and only friend ppl who I truely trust. Plus for security with perms you can lock a table if you still want it writable, I use that just to ensure I don’t wipe my data tables