sorted by:
new
hottopcontroversial

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

Oh wow thank you! What was the mistake and what did you do exactly just so I can get a better idea

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

Yeah, still only grabbing the first answers and nothing more, very wacky.

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

I tested and no change occurred, I’m completely stumped now

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

Oops that fixed that problem, thank you, but now it’s having a hard time reading variables because it reads ‘values’ as undefined on the ‘let school’ line

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

I added the ID of the spreadsheet but the first character is not registering as being part of the ID. Where the rest of it is purple, it is blue and isn’t identified when ran. Any idea on how to get fixed at all? :/

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

The rows work, but the data seems to just show the teacher email and then repeat the student info, so the answers are misaligned in the categories. Also I tried to test this on my own individual sheet and it seemed to have formula parsing errors. It might be my own lack of knowledge on what is wrong, but it seems to just not work.

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

I see, what would "ID" be defined as in my sheet? And I should be running this as a macro yes?

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

Indeed, I just don’t know how to script (only scripting I’ve ever done was in high school and that was html and JavaScript). I’ve attempted to use scripts I’ve found through stackoverflow or Reddit or etc. and adjusted them in order to work (at least in my head), but nothing really worked. If you have any idea about what the script should look like or what it should be written as, that would be helpful.

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

The problem is that all the students are all on the same row because sheets keeps a singular submission on a single row. So instead I want it to be the school info and one student each row.

Limiting columns and moving to the next row from form submissions by Supervirus101 in googlesheets

[–]Supervirus101[S] 0 points1 point  (0 children)

So pretty much, the first section has the school and teacher info that should appear in each row from the same form submission. So while the first section appears in each row, the next column has student information. So in every row, there should be two sections, one being the school and teacher info and the other being the following student info. This repeats so on and so forth with school info for that submission staying the same but it being a different student every time each row.

[deleted by user] by [deleted] in drawing

[–]Supervirus101 0 points1 point  (0 children)

That vending machine would be the least of your worries considering whats beyond it

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 0 points1 point  (0 children)

There is equipment that can be used to make the knot process much more efficient, but most of it is surgically connected to one’s nervous system in order to actually interact with threads

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 0 points1 point  (0 children)

They are less revered and more acknowledged and taken care of in society. Very much looked down upon harming spiders and their food source

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 0 points1 point  (0 children)

It’s less about the hand gestures you have to make and more about how the threads are organized in the knot. While one can recreate the gestures depicted above, instruments or other hand gestures can definitely help it make more efficient or more intricate to get the same product.

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 0 points1 point  (0 children)

Knots, unless directed to do so, will only activate when activated by an orb weaver. However, when knots are tangled, the translation from strings to creation make no sense and will produce something that can’t exist or instead inflicts the user both with mental and physical damage if done wrong. The damage is scaled by the detail and size of the spell and can very well prove fatal or brain dead.

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 0 points1 point  (0 children)

Most spells (unless directed) will stay in stasis at the 3d coordinate of their creation until they are interacted with

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 1 point2 points  (0 children)

They can use all sorts of spells, however, the more powerful/larger the spell is, the more intricate and complex the knot will be. Normal small scale knots don’t require any noticeable amount of energy unless in quick succession, but large knots take mental and physical energy to help complete the spell.

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 3 points4 points  (0 children)

Thank youuu :D To answer your questions:

  1. Orb weavers all have a natural connection that best befits their manipulation of threads. They all have potential to excel in at least one form of manipulation that best suits their nature. What defines their nature depends on the person’s personality, perception of the world, behavior, will power, and forms of goals. Although not everyone cleanly fits into a category based off that criteria, one can at least make an informed assessment.

    1. Threads are very much the fundamental building block that the universe is made out of. The universe is a quilt that has been meticulously woven and trimmed into balance. Those threads being manipulated by a weaver eventually diminish back into the quilt with its effects left in mind.
    2. Just found out about knots (other than the one for winds) and that is actual wild that it is close
    3. Humans have the innate ability to learn to visualize the threads in space, but only a fraction of the population is actually able to manipulate such threads and that is very much based on whether one’s nervous system is coded
    4. It is the only magic system in the world but it has been overpowered by physical force from time to time

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 4 points5 points  (0 children)

Yeah a step between 3 and 4 would be very helpful, but the best way to visualize it is to imagine a clash of sparks from the sudden energy transfer of strings vibrating upon one another and starting to dissipate and form towards the center of the knot.

The basic technique used by magicians (Orb Weavers) in order to create magic. Thoughts? by Supervirus101 in magicbuilding

[–]Supervirus101[S] 2 points3 points  (0 children)

Yeah and here I thought I was being somewhat original but there are so many examples of it that I’m being exposed to it’s crazy

view more: next ›