Title
Keep the calculation field from continuously updating field
Post
Hi there,
Using fmpro12 for invoicing. using calculation field to lookup price of product. Is there a way to prevention the calculation field from updating a paid invoice? ie. Allowing the calculation running only once?
I tried wrapping the formula if(price="", price formula). Didn't work.
I searched the forum. I found article mentioning about changing user rights to restrict access to the invoice record. Not really what I am looking for. I need to prevent calculation field on paid invoice from updating when there is a price change in the future. Not worry about user. I am worry about the calculation field. any ideas?
Thanks in advance.
Henry
You want to LookUp today's price and have it in an invoice.
If the price goes up tomorrow, you do not want it to change.
A Looked Up Value is explained in the links in this Google
Google "filemaker looked up value site:filemaker.com"
https://www.google.com/search?q=filemaker+looked+up+value+site%3Afilemaker.com