activate sheet only after first selection

[kristof_j]

Hi

I want to make a search box with 3 fields.

If you select something in field 1, 2 or 3 you go to the respective sheet 1, 2 or 3. But once you're on the sheet and you select in another field, it shouldn't activate that sheet anymore.

e.g. you search something from field 1 and after selection, it activates sheet 1. If you then select something from field 3 it should activate sheet 3 anymore.

Is it possible?

If you use the Field Event Triggers (document properties) to activate Sheet X after a selection in Field X it won't stop 😞 it will always go to sheet X.

Any solutions?

[vamsee]

Hello,

I would suggest you create 3 duplicate fields of Duplicate_Field1, Duplicate_Field2, Duplicate_Field3 in the script.

Create triggers based on these three in the landing page.

In all other pages do not display them.

Hope it suits your need.

Thanks

Vamsee

[kristof_j]

I was thinking the same. The problem is that it aren't 3 dimensions like in my example but > 10 and potentially more. I'm trying to find a more efficient way.

[sebastiandperei · Accepted solution]

Hi kristof.

Create a variable, for example, called "FirstSelection". Create a doc trigger that set it to 0 when the doc opens.

Add a second action to the triggers of these fields that set FirstSelection=1. Take in mind that these action must be below to Activate sheet action.

Finally, in Activate sheet action, make the condition to these variable for the name of the sheet:

if(FirstSelection=0, 'SH01'). This action MUST be before to set the variable.

[kristof_j]

I found the exact same solution