You need to sign in to do that
Don't have an account?
Yogesh Biyani
One time update to contact fields
Hello,
We create a case to track purchases. I would like to update contact fields such as date first purchased, date last purchased, first license #, last license # etc. using the information from the case. How would I go about it? I am new to SOQL but I think something like this may work.
1) Get all the contacts with the purchases
2) For each contact
After the one time update, I plan to use triggers for future purchases.
Thanks in advance.
Regards,
Yogesh
We create a case to track purchases. I would like to update contact fields such as date first purchased, date last purchased, first license #, last license # etc. using the information from the case. How would I go about it? I am new to SOQL but I think something like this may work.
1) Get all the contacts with the purchases
2) For each contact
- Get all the cases for purchases
- Use Min (Created Date) and Max(Created Date) for first and last purchases
- Find the License info for case with Min (Created Date) and Max(Created Date)
- Set the values on the contact fields
After the one time update, I plan to use triggers for future purchases.
Thanks in advance.
Regards,
Yogesh
Yogesh