Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a List box in 'Windows checkbox' style with a multi selection possibilities and i have following Values:
- Value 1
- Value 2
- Value 3
- Value 4
- Value 5
- Total.
Now i want to have "Total" selected as default (When document loads and on Clear)
But when i select anny other value (incl. Multi select) the Total needs to be deselected.
Is this possible?
Not sure what you mean by 'when document loads' so here are two methods:
1. To default select total when document opens or when sheet is activated:
Right click on your sheet.
Select "Properties"
Navigate to "Triggers" tab
Add Action
Add
Action Type = Selection
Action = Select in Field
Type your listbox field in Field Box
Type Total in the Search String box
2. To default select total when document reloads:
Settings - Document Properties - Triggers
In 'Document Event Triggers'
Select 'OnPostReload' and Add Action(s)
Add the selection per process above.
To default select total when you clear all:
Right click on your 'clear all' button.
Select Actions Tab
Add action
Add the same selection as the first two.
Select Total first. Then in the Selections menu click on the option Set Clear State. Finally save the document once. Now when you open the file Total will be selected until you select another value in the same field. If the click the Clear button then Total will be selected again.
This will help me with the standard load. But it will not remove this selection as soon I selected another value.
Not sure what you mean by 'when document loads' so here are two methods:
1. To default select total when document opens or when sheet is activated:
Right click on your sheet.
Select "Properties"
Navigate to "Triggers" tab
Add Action
Add
Action Type = Selection
Action = Select in Field
Type your listbox field in Field Box
Type Total in the Search String box
2. To default select total when document reloads:
Settings - Document Properties - Triggers
In 'Document Event Triggers'
Select 'OnPostReload' and Add Action(s)
Add the selection per process above.
To default select total when you clear all:
Right click on your 'clear all' button.
Select Actions Tab
Add action
Add the same selection as the first two.