We use a container field to store different employee's signatures to print on their different forms based on the employee assigned to a case.
Then we have a calculation field that has a case statement to determine which signature to use based on the employee assigned to the case.
However, we are running into an issue when an employee leaves and a new employee is assigned to the case, it will not change the signature. This issue is also happening if the user gets married and changes their name, the signature does not display at all. I need for these cases to update with the most recent signature.
Is there a function within the containers setup that allows you to not store calculated results and recalculate when needed like it is setup on regular calculations?
I did not build the database but I do plan to change the setup for the employees by creating their own table and such. However, I need a quick fix for now.
Thank you in advance.