+ Start a Discussion
Reppin505Reppin505 

Update Account Field from Opportunity Table

Now i thought this was easier than it actually is.
 
I would like to pass the value from an Opportunity field into an Account field.
 
Of course i cannot use a formula field to do this. I'm wondering if i can update a field with an S-Control that queries the Opportunity table.
 
I already have the query set up.
 
var SearchString="Select Type, Membership_Status__c, Membership_End_Date__c from Opportunity where AccountId = '{!Account.Id}' And Membership_Status__c = 'Active'";
 
Now this will give me a number of records. But i would like to populate a field in the Account table with a value pulled from that query.
 
Unless there is another way of doing this.
 
Please help :)
cafe2cafe2

Hi,

 

Did you ever figure this out? I'm having a similar problem. Any tips you could give me would be greatly appreciated!