Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Auto Entry while Importing


Recommended Posts

I am working on making a product and pricing database. I have set it up so there is a field for the current price, old price, cost, earnings, and price drop. Price drop is a calculation (current price - old price).

I would like to set it up so whenever I edit the current price, the old price automatically becomes what the current price used to be. I usually import the data, and would like to be able to easily see which items had a price decrease or increase.


Is there any way for me to accomplish this in FileMaker Pro? I am currently using version 5.5.


Cordell Davis

Link to comment
Share on other sites



If you make your current price field a button that takes you to another layout, maybe called edit price you can do the following.


Create a field HoldCurrentPrice (Global Number)

Create a script called hold current price


Set Field (HoldCurrentPrice,Current Price)

Go To Layout (Change price)


Then create a script from that layout called Check Price Change.


If (Current Price = HoldCurrentPrice)

Go To Layout (Main layout)


Set Field (Old Price , HoldCurrentPrice)

Set Field (HoldCurrentPrice, "")

Go To Layout (Main layout)

End If


Gets the ball rolling on the topic anyway.

Link to comment
Share on other sites

This topic is now closed to further replies.

  • Create New...

Important Information

Terms of Use