auto flag checkbox fields via tresholds
Any suggestions for the following challange. I'm working on a change request application. It;s not unlikely that requests that meet certain criteria will need to be 'auto-approved' ie cost < $50 ...
Forum Discussion
The relationship will be
1 Treshold -< many CR's
When I say to lock it just mean no one can add or delete the record which holds all your threshold settings. It will always be Record ID#1
Of course, authorized Roles can be allowed to edit that recrd and as Admin you will create all your threshold fields there.
It is like another way to do an application variable, except that any fields that you need in any details records will need to come in via a Relationship. The Record ID which holds the settings is Record ID 1, so in the details side, you need to have a formula that is also 1.
1 Treshold -< many CR's
When I say to lock it just mean no one can add or delete the record which holds all your threshold settings. It will always be Record ID#1
Of course, authorized Roles can be allowed to edit that recrd and as Admin you will create all your threshold fields there.
It is like another way to do an application variable, except that any fields that you need in any details records will need to come in via a Relationship. The Record ID which holds the settings is Record ID 1, so in the details side, you need to have a formula that is also 1.