haha, don’t worry I can relate to that. My very first Glide app was built on a Google Sheet that had been evolving for about 5 years - it was a tangled mess of formulas and scripts and redundant sheets. It’s taken me the best part of a year to untangle all that as I’ve been learning Glide, and it still has a ways to go.
And yeah, all those “Year X Feed” and “Year X Results” sheets make me immediately suspicious
I wouldn’t mind betting that you have a bunch of redundant data in there and those could probably be massaged into just two sheets (“Feed” and “Results”) without too much effort. The way it is at the moment, I can imagine that you’re probably having to create and configure a lot more screens than you would otherwise need to.
But, there is also something to be said for “if it ain’t broke, don’t fix it”. If you’re happy with the way it all works at the moment, then it’s not my place to tell you that you should change it.
Hi Darren, this started happening and not sure why…
When I click ‘clear’ every choice bar sets to 5. But it’s still treated as clear, because if sent, the values for each column are blank. If I want to actually set 5 as a score it works, I just tap 5 on whichever bar and the score will go through as normal.
It was all working perfectly and I didn’t use the app for a couple of days. Reopened the app, did not make any changes at all and it happened straight away
Should add that everything still works perfectly, scores go though as they should etc. It’s just that the ‘cleared’ format is now 5, rather than every number going back to green
mmm, I can’t explain that. Was a bit worried there that something may have changed in Glide that alters this behaviour, but I just checked one of my apps that uses a similar setup and it’s behaving normally. ie. if I clear all User Specific Columns associated with a segmented choice component, then I see “none” selected.
Have you tried looking in the data editor after the “clear” action to check that it has actually cleared all the columns?
Also, what happens if you clear them manually?
And try viewing as different users… does the behaviour change?
Yes, they do clear from the user columns when the button is pressed, but remain in the actual score columns as they should. Clearing manually sets it straight back to 5.
@Dan76 are your user specific columns configured as Number columns?
Assuming yes, instead of clearing them, try setting them all to 0 (zero) and see what happens
Because if I set to zero manually, it clears the choice bar, but the zero is sent through to the actual column. After sending, the 5 is switched back on. Also, cannot manually set to zero through the app, only through the Glide table
