Donkick Posted October 5, 2007 Share Posted October 5, 2007 I need to build an automatic price calculator for my T-Shirt printing company where the user enters some key info and it spits out an exact price per shirt. Where do I even start with this one? 1. User chooses a shirt from a pull down. Shirts are a set price, this should be simple. 2. User chooses number of colors for the front, back, sleeve, etc... Number of colors effects the run price. (2 colors is less than 5 for example) each color requires one screen. ( 2 color front and 2 color back = 4 Screens X 12.50ea flat fee in attition to the run price) 3. User enters number of shirts to be printed. The more shirts printed the lower the price per print. 2 colors printed on 20 shirts is more expensive than 2 colors printed on 100 shirts. Any help is welcome! :) Link to comment Share on other sites More sharing options...
Inky Phil Posted October 5, 2007 Share Posted October 5, 2007 I settled a similiar, though much more complex, problem by use of a script. This can be attached to a button that the user has to press to get their final price. Another advantage of using a script is that you can check the customers entries are valid before you do your calcs. HTH Phil Link to comment Share on other sites More sharing options...
comment Posted October 5, 2007 Share Posted October 5, 2007 Define a price table with a record for each price level and its minimum amount. Then lookup the unit price from there, using 'lookup next lower'. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6183 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now