Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a requirement to select the Max date by default when user opens the qvw document.
To achive this I have enable the trigger option and select the max date. Its working fine but when user click on clear all option, every thing got deselected including date.
How to make date as consistant even after users clicks on clear all option?
Many thanks in Advance!
Deepak Sharma
PFA
1. OnOpen trigger : =Date(Max({1} Date))
2. OnAnySelect trigger : = Date(Max(Date))
Write the same trigger on Document properties -> OnAnySelect
Hi Deepak, there is another action to lock the field, this way it won't be cleared but users should unluck to change the selected value.
Another option is creating a 'Clear all' button that locks the date field, clears all and unlocks the date field, but the global action to clear all still will deselect this field.
And another option is setting the date field to have always one value selected, so it can't be deselected.
A last option can go playing with triggers on change on date field, but can be difficult to manage using this way.
Thanks for your reply Sibin.
On doing this, now on opening the document...max date is not getting selected.
You can write the same trigger on Document properties ONOPEN also
No Luck
Create a listbox for date column.
Then select one value from this list box -. then go to properties -> check always one selected value
Then click on ok
after that Delete that listbox.
now if you click on clear all, always one value will be slected for Date Column.
Again No luck Sibin
Will you be able to share the sample app pls.
Is it clearing the date field now? after creating the listbox with always one selected value.
I can't upload the file due to security restriction.
Hi Sibin
always one selected value option is available in multi box as well. even I tried with list box as per your suggestion.
But n luck....Once I enable "always one selected value" Max datae trigger doesnt work and showes last saved date value.