rvfowler2
asked on
Filemaker Sending Email on Calc Change Problem
Thought I had solved the problem with setting a trigger to a calculated field (which sends an email). I compare this calculate field (Real Estate CAP rate) to an Old_CAP field and if they are equal, it is not supposed to send the email. However, every time I click into an income or expense field or basically anytime it recalculates, it doesn't seem to recognize that is equal with the old field if no changes are made. Any solutions? Currently, my trigger is not on the CAP field, but OnRecordCommit on the Layout.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The CAP rate just changed, which means Price and/or NOI (Income-Expenses) has changed. See below for the field(s) affected:
(RANDY: REVISE CRAIGSLIST & LOOPNET PER CHANGES BELOW.)
Property: - Lincoln plaza - shopping center
Address: 2904 Long Beach Rd., Oceanside
New Gross Income: $539,180.00
Old Gross Income: $539,180.00
New Expenses: $186,027.00
Old Expenses: $186,027.00
New NOI: $353,153.00
Old NOI: $353,153.00
New Asking Price: $4,400,000.00
Old Asking Price: $440,000.00
New CAP Rate: 8.03 %
Old CAP Rate: 80.26 %