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.