Task completion linked to service's selection

Hi there !

I have 3 tables :

  • CONTACT
  • LEADS
  • ADMINISTRATIVE FOLLOW

If the customer pick one service in the table contact, I have multiple field checkbox set up to check to follow the process for this specific service (in the administrative follow table). Then i have a SUM formula that counts the number of checkbox checked to see task completion. This part works well and is perfect for me.

  • Service 1 : needs to get 10 checkbox checked to be completed
  • Service 2 : needs to get 14 different checkbok checked to be completed
  • Service 3 : needs to get 20 differents checkbox checked to be completed

Question is : How would you set up when a customer select let’s say 2 services (or 3) to affect the necessary checkboxs to show ? and then add a global task completion ?

Any clue ? thanks !

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.