This might be more of a logic block I’m having an issue getting over. Maybe you could help?
So basically you have 5 choices you can make (this is not an actual form but a variation of the multi-step form template). You can select any combination of the first 4 but if you select choice number 5, you cannot choose any of the first 4. Kind of like you can make multiple choices but if you select none of the above, it wouldn’t make sense to select anything above. To try and simplify this to my current skillset, I was just going to do a hint that pops up and says you can’t do that, then also do actual validation when you click “submit” (copy from user defined glide table to google table where completed forms live).
How would you go about accomplishing this? Like I mentioned earlier, I was messing around with visibility of the hint and go it close but unfortunately if you select a rack or multiple, the hint shows, when you select only the “none of the above” option, the hint doesn’t show as intended, or then if you select none of the above and a rack it shows. so it kinda works. just need it to not show when you are selecting racks choices like normal.
I also tried to setup an if then else formula column and having a brain fart there too. Screen shot of question below
Thank you for your time. I tried searching for it but honestly, I don’t even know the correct search terms. I’ve been using “multiple choice”, “forms”, “validation”, etc. I’m sure it could hit me someday, probably on the toilet next week but a helpful push would be really appreciated lol.
edit: also if someone could explain “includes” vs “is included in” difference like I was 5 years old, that would be awesome. Right now I think they’re the same and the dev post about it looking at first value vs second value respectively threw me for a loop.
Oh that’s pretty cool, the None of the above gets hidden when a choice is made.
Now if you were able to make multiple selections and hide the none of the above, that’s more of what I am looking for.
however that makes me think that maybe i need to do - show component if field does not include choices 1, or 2,3,4…errr gotta think about that some more…
edit: also if someone could explain “includes” vs “is included in” difference like I was 5 years old, that would be awesome. Right now I think they’re the same and the dev post about it looking at first value vs second value respectively threw me for a loop.
You can think of it as opposed logics.
Includes: IF “123456789” includes “1” THEN “true”.
Is included in: IF “1” is included in “123456789” then “true”
You can think of it as opposed logics.
Includes: IF “123456789” includes “1” THEN “true”.
Is included in: IF “1” is included in “123456789” then “true”
Yes that’s doable! I just left it in the demo but you can make the choice “required” and allow “multi selection”.
What I did here, is that I have two choice components:
With 5 options, Visible if selection is empty or contains (in your case) “no racks”.
Only with the 4 first options (in the filters, only display those who doesn’t contain “no racks”), visible if selection contains “no racks”.
oh crap that is genius and what’s even more funny is that I’ve implemented something like that on a different test but forgot about it! I knew someone here would be able get me on the right path. Thank you so much!
Just to help anyone else figure this out and building on Lucas_Malguy1’s help. I ended up having to do three of the same choice component to be able to get it right in my mind. Basically if you select 1-4 or any multiple of that, it makes visible component three to prevent the ability of selecting “no racks”. if you select “no racks” it makes visible component 2 to prevent you from selecting no racks and racks. Component 1 is just an initial view of what can be selected. This works only outside of an actual EDIT FORM or NEW FORM component of Glide Apps. My specific use is within a multipage form TEMPLATE that utilizes visibilities within a details page, so values are immediately saved in a holding user defined table until eventually you would “submit” (copy from temp table to permanent table then clear temp table). Example video below:
