5 Replies Latest reply on Oct 14, 2013 5:35 PM by FredStrong

    Decrease price in all records by a specified perctage or amount

    FredStrong

      Title

      Decrease price in all records by a specified perctage or amount

      Post

           We have managed to build an inventory. But periodically we want to decrease the price of of goods. For example we might want to have a sale and so cut the offered price we have listed in the price field of all our records by say 10% or 15% or 20% or maybe decrease it by a fixed amount like £10 or £20, etc.

           We'd be very grateful if someone could explain how we might do this. To repeat, we want the price of each item in every single record to be reduced (or maybe even increased) by a percentage or fixed amount. Please bear in mind we are like sub zero literate when it comes to this kind of thing (it took us 6 months just to build the inventory database!).

           Many thanks for your kind attention to this matter.

            

        • 1. Re: Decrease price in all records by a specified perctage or amount
          RickWhitelaw

               You should have a price or rates table and current prices should be looked up from this table. That way you preserve the history of prices charged over time. If you're not concerned with preserving history, and I hope this is not the case, you can simply create a found set and use SetField to change all the prices in the found set.

          • 2. Re: Decrease price in all records by a specified perctage or amount
            FredStrong

                 Thanks for your reply. We don't need a price or rates table, and even if we did we wouldn't have a clue how to set one up. All we need to do is reduce (or increase) our prices across all records. Tracking reductions (or increases) is of no use to us. I'm sure others need to preserve their history but we can't see why we would want to do that.

                 As for SetField, where is this please? As I say our level is way below even very basic stuff when it comes to using Filemaker. We aren't very skilled by any means. What is like standard for us is quite tricky for us to understand. 

                 So we have an inventory with each record in the inventory showing a field for the price of an item. But we want to reduce (or sometime increase) the whole inventory by a set amount, like reduce everything by 10% or 15% or by £5 or £10. Thus every single item is showing a reduced price, less by 10% or 15% or £5 or £10 or whatever. How?

                 Never heard of SetField and don't know where to find it. Have looked in the menus but it's not there. If SetFieled is the way to do what we need to do then then that's great, but where, how?

                 Once again many thanks for your reply.

                  

                 Frank.

            • 3. Re: Decrease price in all records by a specified perctage or amount
              symbister

                   OK, but beware - this is undoable, so make a backup copy of your file first in case things go wrong..because what you are about to do is a permanent change to a particular field for all records

                   In Browse mode (that's the normal mode for entering data etc), Select View>View As Table, then all your records should be displayed like a spreadsheet. Click on Show All to be certain that you have all records displayed.

                   Select the field you want to change, click on Records>Replace Field Contents, you will be presented with a dialog box with three options:

                   1. Replace with.....[where you can enter a fixed string to update all records]
                   2. Replace with Serial Number ....[where you can renumber records]
                   3. Replace with Calculated Result ... [this is what you want]

                   So Select the last option, then click on Specify, you will be presented with the Specify Calculation Dialog Box, where you can specify a calculation for your field, for example:

                   type in:

              nameofyourfield * 0.90 to reduce all the prices by 10% (include bold text only - use your field name), or

              nameofyourfield + 5 to increase all prices by 5, or

              nameofyourfield *1.1 to increase all prices by 10%...etc

                   you'll be able to select your field name from the list of fields on the left...

                    

              • 4. Re: Decrease price in all records by a specified perctage or amount
                philmodjunk

                     Many businesses use a separate, related table for pricing that includes an effective date. Not only does this preserve previous pricing and the dates for which they applied, but it allows the user to "schedule" a price change by entering a future effective date and the prices that will go into effect on that date.

                • 5. Re: Decrease price in all records by a specified perctage or amount
                  FredStrong

                       Amazing. Works perfectly. Like a dream. Simple too. Just wondering why the Filemaker Help thingy doesn't explain it as clearly as you have done. Thanks again.