Date Addition Based On Weeks
I have a layout where you can choose a date to set an appointment with a contact.
Contacts do have a field called Frequency which contains the frequency in weeks for repeat calls.
Instead of just picking the next appointment date from the drop down calendar, I would prefer if a calculation was performed to establish the next call date based on the frequency value that already exists in the contact Frequency field.
How would I create a new appointment date in the appointment date field by automatically adding the call frequency weeks to todays date? I'm guessing there would be a script trigger upon ObjectEnter of the drop down calendar that would run a script that performs the calculation. I just don't know what the calculation would look like.