Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have to select some selections in sheet by defaut when I open the document.
I added them in Triggers>OnOpen>add actions>select in field> then my Field name in Field and selection in Field in Search String.
I am able to add only one selection.
Could you please suggest the way to add multiple selections when I Open the Document.
Thanks
Pavan
To select several values from a field you need a search-function like match(Field, 'a', 'b', 'c' ...) or as string (a|b|c). But instead to select various selections with an OnOpen-trigger I would rather use bookmarks triggered or not which could handle variables and layouts, too and it will be easier to maintain.
- Marcus
To select several values from a field you need a search-function like match(Field, 'a', 'b', 'c' ...) or as string (a|b|c). But instead to select various selections with an OnOpen-trigger I would rather use bookmarks triggered or not which could handle variables and layouts, too and it will be easier to maintain.
- Marcus