Hi @LThom,
What you’re trying to achieve is definitely possible within HubSpot. Whether or not it can be done without any code at all really depends on how accurate and detailed you want the gratuity calculation to be.
If you’re simply looking for a rough estimate based on a few general rules, then this can very probably be done using custom properties and simple workflows, without the need for external logic or code.
However, if you want to account for more complex scenarios, for example, employees whose salary has changed over time, and you want to calculate gratuity pro rata for each salary period, then it gets more technical. Handling these cases accurately would likely require some more data and coding, possibly with the help of an integration or custom code within HubSpot.
Also, for a fully accurate calculation, you’d need more inputs than just salary and joining date:
- Employee’s contract type (limited/unlimited),
- Reason for termination (resignation, dismissal, etc.),
- Total length of service,
- History of salary changes (if applicable).
So maybe you could clarify: are you aiming for a quick estimate, or a legally precise calculation? That would help determine the best approach.
Let me know if you’d like help mapping out a solution!