Whilst this is a really nice solution, unfortunately the issue I described here makes it unusable from a user experience perspective. So I’m afraid it looks like I’ll have to go back to the multiple screens/clickety-click option
I’m sorry. What does it not do?
Functionally, I think it works fine.
But there seems to be some sort of race condition going on with the action sequence that ends up creating a very confusing user experience. It’s almost like the toggle is being flipped multiple times (it isn’t) and so the screen switches between the two states 2 or 3 times before finally settling down.
I’m not exactly sure what is going on, which is why I posted that other question. It could be because some actions are being fired before a previous action is completed, or maybe it’s a data sync issue with several actions firing one after the other. But without knowing what the expected behaviour should be, that’s just wild speculation.
This is a fairly extreme example (with 70+ components on the screen, all being toggled on/off rapidly), but I’ve also observed similar behaviour with just a handful of components.
Make the toggle invisible during the event.
You mean set component visibility according to the state of the toggle, yes?
That’s precisely what I’m doing.
I know these aren’t ideal solutions but until we have real fixes …I’m just trying to help you get to that point
yep, I understand.
And I think that your solution is fine.
The problem isn’t with your solution, the problem appears to be that Glide is misbehaving and refusing to do what I’m asking/expecting it to do.
Send video of this naughty behavior, that may help me
The toggle isn’t a actual toggle is it? When I said toggle you just need it to toggle a cell’s value from like zero to 1 or true to false and when that value changes they go invisible, I didn’t mean an actual real toggle button. I apologize, I did say button, I was at work and distracted. I say button a lot recently, Glide overload I think.
This is how I set it up (from my earlier post):
I’ll see if I can make a video that shows the behaviour.
Okay, here is a video (I recorded this on my phone).
- I added the “SCREEN ONE” & “SCREEN TWO” components at the top to make it more obvious what is going on. (NB: It’s the same screen both times, with component visibility being toggled)
- You’ll notice that when I tap the submit button (0:20), it initially switches to “SCREEN TWO”, and it looks like everything has worked.
- But then several seconds later (0:29) it flicks back to “SCREEN ONE”
- And then finally at 0:38 it bounces back to “SCREEN TWO”
The expected behaviour is that after I tap the submit button at the bottom of the screen, it should:
- Hide all the choice components and text components associated with SCREEN ONE
- Take me to the top of the screen
- Expose the text components associated with SCREEN TWO
- Reset all the choice components (clear values) (kinda…, but see below)
- Expose all the choice components in their reset state
- STAY THERE!
One thing to note is that when the choice components are unhidden, it’s obvious that the ‘clear values’ action hasn’t completed yet. And this is what leads me to believe there is a race condition going on.
Below is what the action sequence looks like:
How is you sheet setup? I would think that each question was a column and each row was a user. If that was the case your next screen would just link to same sheet but you would have it be the rest of the questions and since you stayed on the same row the action to set column would be able to set the entire row with 1 simple action. But since its multiple choice it causes the issue of that…
How far aside from these choices have you gotten with the project? Do you plan on turning this into a template? If not are you comfortable with using a script instead of glide logic?
Send me a copy of the sheet, just the sheet, I just need a list of your options, I think theres a much easier way to do this…Nevermind. I’m just reading them from the video.
This is what the choice options look like in the sheet:
Essentially, there are 66 pairs. Each pair fills one of the choice components.
When the selections are written back to the sheet, it looks like this:
The value in Col F indicates the “Feedback Type”.
Columns C & D are the user that provided the feedback, and the subject of the feedback, respectively.
In the video I shared earlier, in stage 1 the user is being asked to describe how the subject “Is”, and in stage 2 they are asked to describe how the subject “Could be”. Both set of responses are written to the same sheet.
I am developing a set of scripts that will process and summarise the results.
But none of this is really relevant (as far as I can see).
No, it’s a private project for a private business. No plans to ever release it as a template.
I’ll be using scripts extensively in the backend for data crunching - but I don’t see how scripts can help with what is a UI/UX issue?
Why dont you just clear the row thats dedicated to that user when they are done? Give me a few minutes. I’m building this out real fast to show you what I’m talking about.
As the user works through the choices, they are temporarily stored in user-specific columns.
Then when they hit submit, a new row is written and the user-specific values are cleared.
Clearing the row that has just been written to the sheet makes no sense, as the whole point of the screen is to create that row.
Then dont clear them just stay the path…ok, just give me a moment.