Skip to main content
I have a custom object titled "Meeting" where it is related to a contact record.  I have created a checkbox called "First Meeting."  I want the checkbox to check off ONLY when it is the FIRST MEETING with that contact.  All subsequent meetings the checkbox would remain null because the workflow would recognize a meeting has already occurred.  I have tried to right a few different workflows, but it seems to keep checking the box off regardless if it was the first meeting or the 4th meeting.  Can someone please help me figure this out? 

 

I keep running into some minor nuance in my workflow and would be very thankful if someone can point me in the right direction.  Appreciate it!  

 

Mike 
14 answers
  1. May 14, 2019, 4:41 AM
    Hi Mike, 

     

    To do something like that, there are 2 approaches I can suggest:

     

    1. You'd need to be able to count the number of meetings an account has. If you have a master-detail relationship, that's easy: create a rollup field that counts meetings. Otherwise, you can use a 3rd party tool like DLRS or Rollup Helper.

     

    Once you have this count, use process builder to check the number upon a meeting record creation. Set your First Meeting checkbox to something like :

     

    Account__r.Meeting_Counter__c = 0

     

    (it might be = 1 depending on the tool you use to count)

     

    2. You could create a flow that receives the meeting ID and account ID as input variables. The flow will query for any other meetings on the same account, and if 0 results are returned, mark the meeting as a first. You can launch the flow with process builder as soon as a meeting is created.