Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Simple question I hope.
I have two list boxes:
1. Menu
2. Snapshot date
When the value '6' is selected in the Menu list box, I want to show the max value in the Snapshot date list box.
Finally, if the Menu value is changed from 6, then clear that max value in the snapshot date list box.
Is this achievable?
I think this can be achieved by a trigger but I don't know where to begin.
Please help
Many thanks,
Rob
Solved my own issue.
Need to assign an 'On Select' field event trigger to my list box field.
Under actions, choose 'Select In Field'.
In the field, write the name of your field like this: Date Snapshot
and then in my search string I have: =IF(%_Menu_Wlist='Details',vMaxSnapshotDate,'')
That way, when I click on 'Details' in my listbox, it will make my date snapshot the equivalent to my variable (max date).
Hope this helps someone in the future!
you need to use field event triggers OnChange and use select infield
check below video to give you an overview
Solved my own issue.
Need to assign an 'On Select' field event trigger to my list box field.
Under actions, choose 'Select In Field'.
In the field, write the name of your field like this: Date Snapshot
and then in my search string I have: =IF(%_Menu_Wlist='Details',vMaxSnapshotDate,'')
That way, when I click on 'Details' in my listbox, it will make my date snapshot the equivalent to my variable (max date).
Hope this helps someone in the future!