I've an app that records new clients & another app that has deliverables for a project. I need the number of new clients in a month to appear in the Deliverables app to see how we are doing against target & wondered if this can be done with a calculation?

  • Hello,

    Yes, you can achieve this with a calculation! Here's a possible solution:

    1. Set up a connection between the two apps (e.g., API integration or data syncing).
    2. In the Deliverables app, create a new field (e.g., "New Clients This Month").
    3. Use a calculation formula to pull the data from the client app, such as:

    COUNT(Clients.CreatedDate) WHERE MONTH(Clients.CreatedDate) = MONTH(TODAY())

    This formula counts the number of new clients created in the current month.

    1. Display the result in the Deliverables app to track progress against your target.

    Consult your app's documentation or support team for specific implementation guidance.

     

    Selected as Best
  • Hello,

    Yes, you can achieve this with a calculation! Here's a possible solution:

    1. Set up a connection between the two apps (e.g., API integration or data syncing).
    2. In the Deliverables app, create a new field (e.g., "New Clients This Month").
    3. Use a calculation formula to pull the data from the client app, such as:

    COUNT(Clients.CreatedDate) WHERE MONTH(Clients.CreatedDate) = MONTH(TODAY())

    This formula counts the number of new clients created in the current month.

    1. Display the result in the Deliverables app to track progress against your target.

    Consult your app's documentation or support team for specific implementation guidance.

     

    Selected as Best
  • Thanks @Michael Gardner​ . I tried this using COUNT(@All of Date of First Contact) WHERE MONTH(@All of Date of First Contact) = MONTH(TODAY()) - Date of First Contact is the field that records when the client contacted us, but I'm getting an error - Script syntax error: unexpected identifier. Not sure what I'm doing wrong! Any help gratefully received!