automation stopped working after modifying a formula field
I've got an app where performance metrics are entered quarterly, and if the metric does not meet standard it will generate an entry on the Penalties table, and I've been working on a rather complicated net penalty formula that will
1. calculate the gross penalty amount
2. prorate based on any client or penalty maximums
3. zero out if a minimum event count is not met
been wrestling with that formula much of the day, deleting and importing a small test file of eighteen records to make all the numbers behave as they're supposed to. After altering something involving a summary field inside of this formula, suddenly the automation is no longer working.
It is still switched on in the settings, still says it will trigger if a certain checkbox in the parent record is unchecked, the requisite checkboxes are unchecked in the imported records, and yet the automation is not creating the penalty records. Does anyone have any idea how I may have broken this, and how I can unbreak it?
1. calculate the gross penalty amount
2. prorate based on any client or penalty maximums
3. zero out if a minimum event count is not met
been wrestling with that formula much of the day, deleting and importing a small test file of eighteen records to make all the numbers behave as they're supposed to. After altering something involving a summary field inside of this formula, suddenly the automation is no longer working.
It is still switched on in the settings, still says it will trigger if a certain checkbox in the parent record is unchecked, the requisite checkboxes are unchecked in the imported records, and yet the automation is not creating the penalty records. Does anyone have any idea how I may have broken this, and how I can unbreak it?
