Retain selections even if there are no results

[matthewp]

I have a sheet that has several triggers for default selections

however when there is no result sin my table box foe these selections is doesn't select them in the list boxes.

i want the list boxes to retain selections even if there are no results

[swuehl]

Which selection do you want to retain?

the one that is not possible to make?

or the previous one?

[matthewp]

all selections even if no results are returned (5 selections in total)

[swuehl]

I assume your trigger is trying to create a selection state with incompatible selections, like

selecting a Customer and a Product which is actually excluded by the Customer selection.

Does this roughly describe your trigger settings and possible root cause?

[matthewp]

Yeh i think so,

the selections work fine when there are results but if all 5 selections mean there is no results it disregards a selection

[marcus_sommer]

Maybe you could include a check if there are dimension-values available for those fields and if not you applied the action to a not existing field which meant that then nothing happens:

- Marcus

[matthewp]

There are no expressions, its a table box

[marcus_sommer]

But you have selection-triggers which should sometime (conditionally) not select certain values, right?

- Marcus

[matthewp]

Triggers are as follows

OnActivateSheet

     Select In Field

          Field: [Status]

          Search String: (Complete|In_Progress)

     Select In Field

          Field: [Check]

          Search String: ='Miss'

     Select In Field

          Field: [Type]

          Search String: (AB|XY)

     Select In Field

          Field: [ECheck]

          Search String: ='Inc'

     Select In Field

          Field: [BCheck]

          Search String: ='Other'

[marcus_sommer]

And my suggestion meant to set a condition to the field within a trigger:

OnActivateSheet

     Select In Field

          Field: if(Condition = true(), [Status], [AnotherNotExistingField])

          Search String: (Complete|In_Progress)

....

- Marcus