cancel
Showing results for 
Search instead for 
Did you mean: 

Checkbox on Case "Work Order Created"

Roast Chef
Roast Chef

Checkbox on Case "Work Order Created"

I'm drawing a blank here.  I want a checkbox on the Case object to update to True when a Work Order is created.  I thought I had this addressed by creating a custom report of Cases with/without work orders, and then adding criteria to work order = null, but apparently that doesn't work  (and never has).

0 Likes
Reply

Re: Checkbox on Case "Work Order Created"

Hi Dan,

Have you tried creating a rollup field on case with the count of work orders associated to the case? If no work orders found, the field will show up as 0.

0 Likes
Reply
Employee
Employee

Re: Checkbox on Case "Work Order Created"

Your issue is with the automated process to check the box of cases when a work order is created or your issue is with the report?

0 Likes
Reply
Roast Chef
Roast Chef

Re: Checkbox on Case "Work Order Created"

Hi Omar,

My issue is with the automated process to set the checkbox to "True" on the Case Object when a work order is created from said case.

0 Likes
Reply
Highlighted
Staff Chef
Staff Chef

Re: Checkbox on Case "Work Order Created"

Hi Dan Schiess , are you looking for one report that has cases that have work orders and ones that don’t. But you can tell which have work orders and which don’t? Or are you looking for a report of only cases that have no work orders. Or are you looking for a report of only cases that have work orders. 


Regards, Richard

~If my post was useful, please give me a thumbs up! Mark correct answers as 'solutions' so we can all find answers faster!~
0 Likes
Reply
Roast Chef
Roast Chef

Re: Checkbox on Case "Work Order Created"

Hi Richard, not really looking for a report solution (not yet at least).  Looking to just get a checkbox on the Case object marked to "true" when a Work Order has been created.  Once I have the checkbox working correctly, the reporting will be easy.

0 Likes
Reply
Employee
Employee

Re: Checkbox on Case "Work Order Created"

Dan, any workflow or process builder worked for this?

0 Likes
Reply
Roast Chef
Roast Chef

Re: Checkbox on Case "Work Order Created"

Struggling with tying in across objects.  The Work Order information shows up as a Related List in the Case, but I can't tie to it.

0 Likes
Reply
Roast Chef
Roast Chef

Re: Checkbox on Case "Work Order Created"

Tried both Process Builder and workflow rules/field updates within setup as well.

0 Likes
Reply
Employee
Employee

Re: Checkbox on Case "Work Order Created"

I think I have an idea if your issue.   Updating from Parent to Child and Child to Parent its completely different.   Also, if the objects dont have a master detail relationship.  I will recommend to open a case with Salesforce Support, but probably you will need a flow for it.  Open a case with Salesforce and let us know!

0 Likes
Reply
Roast Chef
Roast Chef

Re: Checkbox on Case "Work Order Created"

Thanks - that was my next step.  Will report back!

0 Likes
Reply
Sushi Chef
Sushi Chef

Re: Checkbox on Case "Work Order Created"

If you use SFM to create Work Order from Case, you can try to use "Source Object Update" in that SFM to update the field you want on your Case (Source) when the Work Order is Created. Update a filed on Case called "Has Work Order" to "True". 

On your report question for report type "Cases with/without work orders" I believe you will need to add Cross filter for that b/c you are including by default in your report type Cases that have and do not have Work Orders.

Snap7.jpg

This should get you only Cases that have work orders..

~If my post was useful, please give me a thumbs up! Mark correct answers as 'solutions' so we can all find answers faster!~
Pastry Chef
Pastry Chef

Re: Checkbox on Case "Work Order Created"

Casey Palmer​ is right. We are also using the "Source Object Update" feature to update the Case upon Work Order creation. We also use this feature for several other use cases across our service solution.

Line Chef
Line Chef

Re: Checkbox on Case "Work Order Created"

@dan schiess

Are you using only SFM  to create the Work order from the Case?

If yes when setting up the SFM in the SFM transaction designer you can select the "Source Object Update" and setup for the case to be updated with the information you want upon creation.

Otherwise you can also use the declarative rollup summary app from the appexchange it will enable you to create rollup summary

0 Likes
Reply