Format Rule Expensive?
Working on an app here. I have a table with the following columns… 1. Material 2. Alloy 3. Pricing
I have a form with dependant drop downs from 1 & 2, and a format rule that checks if that particular alloy has pricing, and if yes, highlights in green. Here’s my code…
It basically checks if the Alloy you have selected already has pricing. This is a quoting app, so before trying to calculate pricing, it is basically alerting the user if it does, or does not have pricing data.
This is triggering an alert…
“The condition of format rule ‘New Format Rule’ may be expensive and slow the user experience of your app”
Is there a better way to do this?