Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Requirement: User wants a button like toggle where they can limit the data to last 6 months and then can again switch back to the whole data set using the same button/text object.
What I did: I created a Flag to identify the data which falls under Last 6 month range and created a button and used an Action - "Select in Field". This works smoothly on my desktop but the moment the app gets published on access point, the button becomes useless.I have read about triggers not working on access point so i think this why the button doesn't work.
Other option is to create a variable based conditional expressions but since i have lots and lots of sheet objected where I will have to do this, i was wondering if there is any work around or any other way to implement this.
This is quite an urgent requirement from the user, so, any help or suggestion would be great.
Thanks,
Pranav
Hi Brett,
I had actually used the same approach which you have suggested. One button to select Flag value to restrict the data to 6 months which i am hiding on click and showing "Clear" button in place of it. But the reason why it was not working in access point was the use of quotations i.e. '1' to select the value for Flag in the Action tab of the button. I removed the quotations and just entered 1 and it started working in access point. Although '1' worked fine in my desktop but did not in access point.
Thanks for your response!
Pranav
AFAIK only OnOpen trigger doesnt work on Ajax client. Others should work. I would investigate if some other trigger is interfering with yours.
Alternatively
Why not use your flag as the filter?
e.g. Last 6 Months Flag - values will be Y or null
User can just deselect it.
Pranav, in addition to Dilip's post, you could use two buttons here with conditional show such only one of them shows at a time and one does your selection to lock it down to the last 6 months whereas the other one does a ClearAll action.
Regards,
Brett
Hi Brett,
I had actually used the same approach which you have suggested. One button to select Flag value to restrict the data to 6 months which i am hiding on click and showing "Clear" button in place of it. But the reason why it was not working in access point was the use of quotations i.e. '1' to select the value for Flag in the Action tab of the button. I removed the quotations and just entered 1 and it started working in access point. Although '1' worked fine in my desktop but did not in access point.
Thanks for your response!
Pranav