Hello. Good to see glide added way to control visibility based on multiple conditions (AND / OR). Thanks. However, it seems like there may be an unrelated bug? I have two sheets A and B. B has a relation column based on a matched column present in both sheets. B has a lookup column based on the rel…

This should be fixed by now. Is it not?

[image] Bug in visibility on form Report a Bug I think the problem is when you attempt the set a visibility condition (in edit mode) against a value that is not editable on the screen. I don’t think it’s an issue with the multiple conditions (at least I haven’t seen an is…

I was too fast to conclude. Actually as Jeff said, this workaround didn’t fix this situation because condition for visibility is based on a formula field which presents some constraints when deploying this workaround. If I put the formula field on the form and make it hidden, on submit the value i…

Sorry about those limitations. We will fix them in due course.

There is another issue with the workaround. If cell value with formula changes (added a family member) and then I press “Done”, it overwrites the correct value with literal old value. Invalidating entire column with first cell which has ArrayFormula reading like “Array result was not expanded becaus…

Create two separate sheets One where your form will submit to and one that will present your data the way you want. You don’t have to use the same sheet for submit and present Run a query formula to pull the data you need over the present sheet, this way you have no conflict. In glide you can se…

Thanks. I will explore this option of two sheets. Looks like it has many uses. But for now, I wrote a time-driven trigger on my sheet that detects first cell value as “#REF!” of the column in question. Then it clears entire column and then assigns the formula to the first cell. This works as a worka…

Glide staff, is there any update on this bug? Thanks.

I must not understand the visibility logic. I need to add conditions and want one that is first and want to add one with “OR” and then add another with “AND” and might even need another with something…but appears that no matter what I need the choice I make for the 2nd condition as to OR/AND will a…

Can’t have both OR and AND. What I do is create the OR logic in the data editor as its own if-then-else column. Then use that column in conjunction with another value using AND in the visibility.

Possible bug in visibility condition

Report a Bug

Jeff_Hager December 23, 2019, 1:53pm 2

Topic		Replies	Views
Bug in visibility on form Report a Bug	6	930	May 17, 2020
Visibility Conditions in Forms stopped working Report a Bug	6	567	August 25, 2020
Visibility condition with numbers and AND with GDOCS isn't working Report a Bug	6	370	August 25, 2022
Visibility based on more that one condition Feature Requests	13	1379	May 15, 2024
Visibility Conditions inverted in Form? Ask for Help	5	298	November 27, 2023

Possible bug in visibility condition

Related topics