January 2, 200818 yr We use a sliding scale to charge our customers for shipping. I have been playing with different implementations of this and have gone as far as writing a really long calculation field, but there's gotta be a better way. I've attached an image of our sliding shipping scale. It's pretty straight forward until your order reaches $300 and then you start adding percentages. I'm using this data as part of a database to calculate item costs. I'd like to be able to select the shipping method (in a Shipping Method field) and then have it use the data in my Price field to retrieve the related shipping charges from the table (attached). Can anyone lend a hand?
Create an account or sign in to comment