conditionally hide/show a text box based on field values without its selection in that field

[sayanpwc]

Hello team,

Facing an issue.

I want to hide /show a text box based on a filter value.

for ex: while opening the sheet my field 'Region' shows two values in the list box : north and east,west,south

Now i want to show a text box if the field value is north/west and hide it if the value is east/south. But without selection  in the filter.

How can i do this?

[sunny_talwar]

If both the values are possible then how do we hide or show anything? You are not selecting one or the other? or is this based on selection in another field which leads to only one value of Region?

[sayanpwc]

SEE THis comes from section access. for example one user has access to North and south Region.

In dashboard i have four text boxes for North,South,east and west instead of the region field. ( There is a reason ).

now for example user A has only access to North and East region. so when user opens this app he should be able to see only two text boxes of North and east. How to achieve this?

[kfoudhaily]

Hello,

I think you should use triggers to open an object on a sheet when it is opened.

here is how you need to configure you sheet:

You go the "settings" menu, "sheet properties", and then "Triggers" menu

on sheet activatin, clic "add action"..

there's more than one way to do this; either to use the activate object option

or you can use to assign a value to a variable depending on the condition you are requiring.

Hope it's helpfull.

regards

[sunny_talwar · Accepted solution]

May be just check like this in conditional condition for North

SubStringCount(Concat(DISTINCT '|' & Region & '|'), 'North') = 1

and do this for all other Regions

[sayanpwc]

Thanks Sunny!! It worked!!