RecordSelectionChanged event? Follow
Within the Data Entry Forms I am trying to resolve the following situation:
- Data Form contains 1x Record Picker, 2x Date Picker and quantity TextBox field
- User starts by entering the unique product code (SKU) into the Record Picker and filters exactly one record
- based on the value in different column from that selected record (Shelf life), I need to compute Expiration Date and initialize one of the Date Picker with a result of that computation
The idea is that the Date Picker's default value should be always precomputed from the selected record and user could change it when needed.
I was hoping to solve this task by using some VBScript, but I couldnt find logical hook for this - some event like OnRecordChanged - where I could perform computation and set Date Picker's content dynamically after the selection. Alternatively I was thinking about another approach, using VBScript as NamedDataSource for the Date Picker, where I would put the computation logic, but here I am not sure that the script is executed after each record selection.
Is there a way to address this scenario?
Please sign in to leave a comment.