Navigation

    CreatiCode Scratch Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • CreatiCode

    Concept of how to make something with google sheets

    Help
    3
    7
    307
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Tyller_
      Tyller_ Best Forum Helpers last edited by

      (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

      <div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
      </div>

      info-creaticode jeffreyrb03-gmail 2 Replies Last reply Reply Quote 1
      • info-creaticode
        CreatiCode @Tyller_ last edited by

        @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_ 1 Reply Last reply Reply Quote 0
        • Tyller_
          Tyller_ Best Forum Helpers @info-creaticode last edited by

          @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)

          <div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
          </div>

          info-creaticode 1 Reply Last reply Reply Quote 0
          • info-creaticode
            CreatiCode @Tyller_ last edited by

            @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_ 1 Reply Last reply Reply Quote 0
            • Tyller_
              Tyller_ Best Forum Helpers @info-creaticode last edited by

              @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

              <div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
              </div>

              1 Reply Last reply Reply Quote 0
              • jeffreyrb03-gmail
                JaecadeJnight Mod Helper @Tyller_ last edited by

                @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.

                #LLJW
                <span style="color:white;background-image:linear-gradient(to right, lightblue, navy)">My name is Jeff</span>

                Tyller_ 1 Reply Last reply Reply Quote 0
                • Tyller_
                  Tyller_ Best Forum Helpers @jeffreyrb03-gmail last edited by

                  @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

                  <div component="post/signature" data-uid="255" class="post-signature">Check out my chat room project so you ppl can not use forums as chat rooms! https://play.creaticode.com/projects/66f2e1dcd1be43d82b886fbd?version=1 <p dir="auto">
                  </div>

                  1 Reply Last reply Reply Quote 1
                  • First post
                    Last post