Clear input box or use all possible value

[Anonymous]

Hi guys,

I have an input box. But when I move to another sheet, I'd like to clear my input box variable or set up - use all possible value.

How can I do it without using a macro?

Thanks,

[Anonymous]

Use Triggers , on Activate Sheet---> add action ---External--set variable. Hope this helps

[Anonymous]

I know it. But what should I set up in variable to clear or use all value?

Thanks,

[Anonymous]

or how to set up show what I typed in Search box ?

[Anonymous]

can you please let me know the definition of the variable or else sample application , i can be able to help you with that...

[Anonymous]

Please find the attached file.

I have a search box and input box. My chart is using Variable from Input box, but I can easy to redo to use Field from Search box.

The idea is by default chart shows all possible results. Using search box (or input box) hide unselected words. It works.

Problem with input box

---  But click by "Next" my variable from Input box should be cleared or used all possible value.

Problem with search box

--- Search field doesn't show what I typed

Thanks,

[Anonymous]

Why don't you use a list box and enable Hide Exclude option. So that Users will know what they have selected. And it will exclude what they haven't selected. And your expressions also work fine. Please correct me if i am missing anything

[Anonymous]

For Input text

I can set up  a trigger for variable

=concat(DISTINCT {<[Keyword]=P()>} Keyword, ', ')

in this case my input variable shows all possible value

[Anonymous]

I'm limited in a space.

Do you have an example, how to show my typed key word?

I'd like to have only *ja* or whatever I typed. I don't need to see all possible words, which have *ja*

Cheers,

[Anonymous]

Now i understood your problem is..so you want to see data for .. what you have typed... let me get back to you on that...