Hi Beth,
Actually this is a mathematical problem. You can check math forums for an answer. I have shared a microflow that checks a range against an existing range. You can find it here
Regards,
Jeroen
Beth,
You could accomplish this with a microflow that determines the max FICO score of the previous record and sets the min FICO score for a new record to the previous min + 1. If your domain model looks like:
When you create a new Rate object for a given product, you would call a microflow that would:
On the page where the Rate objects are edited, you could make the min FICO score field uneditable, if this fits with your business rules. In this way, the min FICO score is always set to the next sequential number based on existing objects.
The only other thing to take care of is the case where there are no existing Rate records for a Product. In this case, you could set min FICO to a fixed number like that fits with your business rules, or offer the user the opportunity to edit that number.
Hope that helps,
Mike