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]

1. Show all value

2. show only Keyword, which has "all"

3. Clicking by Campaign or other tab my input box should be cleared or use all possible value.

I use a trigger

set variable=if(SubStringCount(concat(DISTINCT {<[Keyword]=P()>} Keyword, ', '), ', ' )>0, ExcludeKeyword)

In this case, when I move to another tab, my input box show all possible value

I try to find any solution how to show what I typed for search

[Anonymous]

not sure if there is a way to show what you have typed for search. But if you search something in search box and select it .. and if you want to show in a text box.. then use =GetFieldSelections(Keyword) in the text box...or use that in the variable .. that will be fix the issue...

[Anonymous]

Do you know how to get undefined condition for input box?

When I click "Delete" command and than "Enter", i got empty input box with undefined, and everything works

[Anonymous]

Not really i dont know.. may search in the support site. Is my solution helpful...

[Anonymous · Accepted solution]

I probably find the issue

trigger for variable  -  chr(00)

[Anonymous]

Glad you found the solution Buddy

[Anonymous]

Thank you for your help.

[#9]

If you have no input constraints on your variable, this will happen.

Go to Settings > Document Settings > Variables > Input Constraints

You can also mange these constraints while you are configuring the input box.

Go to Input Box Properties > Constraints > Input Constraints