Jump to content
X2Community Forums

Use Workflow to update field linked with current Record Type


Recommended Posts

I'm making a Workflow with condition like picture below

 

post-10646-0-41524200-1488615183_thumb.jpg

 

Trigger: Record Updated

+ Record Type: Quotes

+Compare attribue is Invoice Status: equals Paid

 

and I want update field Deal Value from Contact record linked with Quotes by Contact field. I think have to use {attributes} and {chained attributes} to do this but still on finding out how to do. How can I do this with Workflow?

 

post-10646-0-34320900-1488615214_thumb.jpg
Link to post
Share on other sites

I've made new workflow with Flow actions Change Record like picture below

 

post-10646-0-34745600-1488620095_thumb.jpg

 

And I add Update Record and Email flow actions

 

in Update Record, I choose Deal Value but I still no successfully in formula plus Total of Quote and current Deal Value like this: ={dealvalue}+{c_quote.total} 

I've tried other formula  ={dealvalue}+{quote.total} and  ={dealvalue}+{total} but the same result.

 

post-10646-0-04182300-1488620304_thumb.jpg

 

Please show me the correct formula to plus Total of Quote and current Deal Value of Contact

Link to post
Share on other sites

Have you already set up a link from the Contact to the Quote? After switching focus to the Contact with the Change Record action, you're still going to need to be able to access the Quote total. To do so, you'll want to add a custom lookup field from Contacts to Quotes. Since a Contact will ideally lead to multiple quotes, you may want a "current quote" field or similar. Then, before changing to the Contact, set the lookup field to the quote's nameId field to facilitate lookups. Then, assuming a custom field named "quote," after you've changed to the contact, you can update the dealvalue with the formula ={dealvalue} + {c_quote.total}

Link to post
Share on other sites

Have you already set up a link from the Contact to the Quote? After switching focus to the Contact with the Change Record action, you're still going to need to be able to access the Quote total. To do so, you'll want to add a custom lookup field from Contacts to Quotes. Since a Contact will ideally lead to multiple quotes, you may want a "current quote" field or similar. Then, before changing to the Contact, set the lookup field to the quote's nameId field to facilitate lookups. Then, assuming a custom field named "quote," after you've changed to the contact, you can update the dealvalue with the formula ={dealvalue} + {c_quote.total}

Thanks Raymond, I've add field Latest Quote to Contacts module like picture:

 

post-10646-0-77920400-1488901698_thumb.jpg

 

But I don't know how to do "before changing to the Contact, set the lookup field to the quote's nameId field to facilitate lookups."

 

Please show more detail about this step!

Link to post
Share on other sites

Have you already set up a link from the Contact to the Quote? After switching focus to the Contact with the Change Record action, you're still going to need to be able to access the Quote total. To do so, you'll want to add a custom lookup field from Contacts to Quotes. Since a Contact will ideally lead to multiple quotes, you may want a "current quote" field or similar. Then, before changing to the Contact, set the lookup field to the quote's nameId field to facilitate lookups. Then, assuming a custom field named "quote," after you've changed to the contact, you can update the dealvalue with the formula ={dealvalue} + {c_quote.total}

 

Finally, I've done what you guide and have correct result

1. Create custom lookup field from Contacts to Quotes, my field is Last Quote

2. Create new quote and link to contact

3. Edit contact and set the lookup field to the quote's nameId field manually

4. Create workflow with formula

 

I have another question in step 3: "Edit contact and set the lookup field to the quote's nameId field manually", can automatic this step by auto add last quote linked to contact in step 2 to custom lookup field? 

Link to post
Share on other sites
  • 11 months later...

I wonder what this means: 
 

https://www.x2crm.co...feature-update/

New in this release is a “Change Record” X2Workflow Action. This new workflow action allows users to switch to a related record during a workflow execution. Users can use it to do things like update a “total sales” amount on a Contact when a Quote is marked as won or otherwise update related records in response to X2Wofkflow triggers.

 

 

Does it mean that you can only increment total sale count and not the total sale value because to get the total sale value, you will have to carry forward that value from the previous record. 

  • Like 1
Link to post
Share on other sites
  • 6 months later...

I wonder what this means: 

 

https://www.x2crm.co...feature-update/

New in this release is a “Change Record” X2Workflow Action. This new workflow action allows users to switch to a related record during a workflow execution. Users can use it to do things like update a “total sales” amount on a Contact when a Quote is marked as won or otherwise update related records in response to X2Wofkflow triggers.

 

 

Does it mean that you can only increment total sale count and not the total sale value because to get the total sale value, you will have to carry forward that value from the previous record. 

Following this post, I'm hoping the admins are able to answer this as well. Since I have made a similar "total point value" field in the Quotes module and need the contact's field to regularly update the total of that field every time a new Quote record is created and associated to that contact.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...