Hi Anna,
There is a good example here of using a snippet to update one field when another field is edited, however this might be possible to do without any code using the actions framework.
A very brief summary of how it would work is that you would:
Create a separate model on the Instructor Day object
- limit it to 1 record
- uncheck ‘load model data on page load’
- set a condition where the date field equals a single value, leave it empty, and set it to ‘filterable default off’
- set another condition where the Instructor__c field equals a single value, leave it empty, and set it to filterable default off
Create an action sequence (or a button that allows the user to control when the actions are performed) on the Private Lesson object, which:
- Activates the two conditions on the Instructor Day object, AND passes in the values of the Date and Instructor
- Queries the Instructor Day object
- returns the value of the Id field (e.g. {{$Model.InstructorDay.data.0.Id}} ) from the query, and udpates it into the corresponding field on the Private Lesson object.
- Saves the private lesson model
- Empties the instructor Day model (depends if you might want to query this model again to repeat this process)
thats a very broad overview of how it might work. If you want to post some screenshots of your page builder that would help to go into more detail.
