0

When I go to create a new process in Process Builder on the Quote Object, why are Quote Line Items not an option under field selection? See image below - The 'Line Items' that shows is just a count field of the number of line items on a particular quote.

enter image description here

Quote Line Items definitely have a parent-child relationship with Quotes. If I select Quote Line Item as the object to start PB on, I can then access the Quote parent object, but not the other way around.

I want to start a Process based on when a Quote has been accepted, but only if the line item product name contains certain words.

Is there something I'm missing?

Improve this question

1 Answer 1

Reset to default
2

You can't query child records from process builder. You'll have to use a record-triggered Flow, since flows can query and loop through child records.

Improve this answer
5
  • Thanks @David! I'm looking to update a field if certain wording is contained within the Product Name of the Quote Line Item within a particular Quote - I'm not really sure how to create the flow to do this. Are you able to provide me with an example?
    – Alexis Frisch
    Commented Apr 12, 2021 at 21:05
  • You'll have to build loops and use formula variables in the Flow, so look for tutorials on those. On a different tack, a rollup tool like Declarative Lookup Rollup Summaries might be able to rollup the line item count to the quote (depending on the complexity of your wording), then you could use process builder on the quote's rollup field.
    – David Cheng
    Commented Apr 13, 2021 at 13:53
  • I have DLRS, but I don't need the count of QuoteLineItems to a particular quote - I need to know if a certain string exists within the Product.Name field of a QuoteLineItem within a Particular Quote. Thanks for the advice, I'll look up Loops.
    – Alexis Frisch
    Commented Apr 13, 2021 at 13:57
  • You can use the count as part of your PB condition -- Quote is approved and line item count > 0, since the count would indicate how many line items' product names have the wording.
    – David Cheng
    Commented Apr 13, 2021 at 14:18
  • Ah, I see what you're saying - That's not a bad idea either. Thanks for the suggestion!
    – Alexis Frisch
    Commented Apr 13, 2021 at 14:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .