Calculating data using custom object fields | Community
Skip to main content
M
Megan_Koelemay
New Participant
May 18, 2023
Solved

Calculating data using custom object fields

  • May 18, 2023
  • 1 reply
  • 1835 views

Is there a way to use two fields in a custom object to calculate a third field?  For example, I have two fields on my custom object - one for the date a trip begins, and another for the number of days a trip lasts.  Can I somehow calculate the date a trip ends?  Webhook or something?

 

The trip end date doesn't necessarily need to be an additional custom object field, it could be calculated elsewhere - just in a way that I could use a smart campaign filter or trigger to send emails (e.g., "welcome home from your trip!") based off that data.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Sure, you could call a webhook-compatible service.

 

The service loops back and loads the COs using the REST API, then can do calculation/aggregation and write data back to a Person field and/or update the CO record itself.

 

It’s a niche need but something we’ve done before — for example, writing the total # of a certain type of CO records to a Person field.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
May 18, 2023

Sure, you could call a webhook-compatible service.

 

The service loops back and loads the COs using the REST API, then can do calculation/aggregation and write data back to a Person field and/or update the CO record itself.

 

It’s a niche need but something we’ve done before — for example, writing the total # of a certain type of CO records to a Person field.

    M
    Megan_KoelemayAuthor
    New Participant
    May 18, 2023

    @sanfordwhiteman Many thanks!  We also may have need for the other scenario you mentioned, so that's great to know.  

    Terms & ConditionsAccessibility statement

    Loading footer...