asked on How to Replace field with results of calculation
I need to update a field with the results of a calculation every time I enter a record.
The destination field cannot be a calculated field because FMP does not allow indexes on calculated fields.
The destination field must be indexed because it is used for a portal.
Example:
Original entry $234.37 into Amount Paid.
Calculation Results will be 2 into Amount Category field since the amount is between $200 and $299.
The portal will show all payment processing rules for a payment in that amount range.
The destination field cannot be a calculated field because FMP does not allow indexes on calculated fields.
The destination field must be indexed because it is used for a portal.
Example:
Original entry $234.37 into Amount Paid.
Calculation Results will be 2 into Amount Category field since the amount is between $200 and $299.
The portal will show all payment processing rules for a payment in that amount range.
FileMaker Pro
Last Comment
ErikCayre
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
For each rule define a minimum amount and a maximum amount that that rule applies to, then create the relationship such that:
Amount Paid >= Minimum Amount
Amount Paid <= Maximum Amount