Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'am facing an issue. So, i have two tabs with two fields as selection list : Year, Month.
What i'm trying to achive is when i open document current month must be selectionned in tab1 and previous month must be selected in tab2.
Is it possible to achieve this??
Thanks
You can add a trigger in each sheet.
Right Click in the tab -> Proprieties
Select Triggers -> Add Actions.
In firts tab you will select today, in second, today -1.
Look into the images.
On Open doc triggers don't work in ajax.
If you are using IE and the plugin, one way is to use alternate states.
If the app opens to the first tab, you could use onactivate for the second sheet to set the filter to the prev month.
May be you can try Onsheet trigger for this.
Can you share your data or app?
You can add a trigger in each sheet.
Right Click in the tab -> Proprieties
Select Triggers -> Add Actions.
In firts tab you will select today, in second, today -1.
Look into the images.
HI Zilz, Could you please suggest how make default selection in list box with color as well. I have two list boxes with like below Source 1: (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (10/23 ver.)-->(prev year) Source2 : (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (06/23 ver.) (10/23 ver.)-->(prev year) I need default selection of source1 is (05/23 ver,) and source2 is (06/23) when ever I opened the qvw app above values needs to be selected by default. and once data updated new data versions are added to list box for list box1(source1) like (06/23) and listbx2(source2) is with (07/20) after updating the app I need above mentioned values as default. could you please suggest me Thanks In Advance