Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm facing an issue while using button action to navigate from one sheet to another and in between storing some selections into variables.
Given below is the scenario and example attached. Thanks in advance for your help.
In the qvw you can find that I've two sheets. Each has a button to navigate from one to another.
When I go from Sheet 1 to Sheet 2 using button 2 I've actions set as below.
Set variable vSTS = getFieldSelections(status) // storing current selection of status field into a variable
Set variable vType= getFieldSelections(type) // storing current selection of type into a variable
Activate sheet = SH02
Clear All
Select in Field = status = vSTS // Set field status value as stored in variable
From Sheet 2 when I'm coming back to Sheet 1 using button 1 then the action set are
Set variable vSTS = getFieldSelections(status) // store current selection of status into a variable
Activate sheet = SH01
Clear All
Select in Field = type = vType // select field type value as stored in variable
Select in Field = status = vSTS // select field status value as stored in variable
Issue:
I'm on Sheet 1 and I selected type = 'infra' and status='completed' and clicked on button 2.
On reaching sheet 2 I can see that the selected values are stored in the variable but the Select in Field (status) action has failed.
Similarly when coming back from Sheet 2 to Sheet 1 using button 1 this is not working as expected.
NOTE: this may not be an issue using tab navigation. I've a workaround found to use a variable (variable event trigger) that gets set and in turn select the field values but that solution is not working in AJAX mode. Please check your solution to work in AJAX mode too.
Regards,
Sudeep
i do not see sheet 2, I see sheet 1 and main
I was referring the Main sheet as Sheet # 1 and Sheet1 and Sheet # 2.
will this work - I do not think you need the variables (If I undertand what you are wanting to accomplish)