I'm writing a script that relies on data from multiple tables and I'm having trouble tying it all together. The script would check for two criteria before checking a tick box that allows another script to perform an action on the record. This script would check to see if an employee is active and that they have been with the company for 90 days before marking them as eligible to receive a tool allowance.
I currently have the active field in tool allowance as an unstored formula that checks to see if an employee is active on the employee info tab. When creating a new tool allowance it always works to mark them as active on a new employee but it never seems to catch when an employee has been moved to non active and leaves the checkbox ticked.
Then there is a formula that checks if the employee is eligible it will distribute a monthly tool allowance of $50 into their account. I'm not sure how to make this formula check for multiple criteria however.