Shipping Formula %
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47472
interpreted = N
texte = I see from the documentation how to figure shipping using a fixed percentage:shipCost
*.15 (in Formulas.db) So how would you write a formula using a floating discount schedule like this?Example: if subTotal is between $0.00 and $499.99, then shipCost = subTotal * 20%, if not then if subTotal is between $500 and $999.99, then shipCost = subTotal * 18%, if not then if subTotal is between $1000 and $1499.99, then shipCost = subTotal * 16%, otherwise shipCost = subTotal * 12% If someone could someone show an example (preferably in the XML syntax, but if not, that's O.K) of nested If statements using the above info, I'd greatly appreciate it.Thanks, Marc*--*--*--*--*--*--*--*--*--*--*--*--*--*--* Superior Shelving Systems P.O. Box 6949 Tacoma, WA 98406253-756-8138 253-752-1610 faxhttp://www.SuperiorShelving.comThe Storage Shelving Specialists Since 1984 *--*--*--*--*--*--*--*--*--*--*--*--*--*--* ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I see from the documentation how to figure shipping using a fixed percentage:shipCost *.15 (in formulas.db) So how would you write a formula using a floating discount schedule like this?Example: if subTotal is between $0.00 and $499.99, then shipCost = subTotal * 20%, if not then if subTotal is between $500 and $999.99, then shipCost = subTotal * 18%, if not then if subTotal is between $1000 and $1499.99, then shipCost = subTotal * 16%, otherwise shipCost = subTotal * 12% If someone could someone show an example (preferably in the XML syntax, but if not, that's O.K) of nested If statements using the above info, I'd greatly appreciate it.Thanks, Marc*--*--*--*--*--*--*--*--*--*--*--*--*--*--* Superior Shelving Systems P.O. Box 6949 Tacoma, WA 98406253-756-8138 253-752-1610 faxhttp://www.SuperiorShelving.comThe Storage Shelving Specialists Since 1984 *--*--*--*--*--*--*--*--*--*--*--*--*--*--* ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Sales
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Searching an Email database (1997)
[WebDNA] [sendmail] random duplicates (2010)
shipcost (1997)
E-mail loop ! (1997)
Country & Ship-to address & other fields ? (1997)
WebCatalog Plug-in for Webstar. (1997)
Add more fields to an existent data base (1997)
merchant accts. (1997)
multiple credit card merchant accounts/processors (1997)
Exclamation point (1997)
date (1999)
Search/sort in URL Was: GuestBook example (1997)
[SearchString] problem with [search] context (1997)
[WebDNA] Email Log.txt (2014)
Summary layout (1997)
Ongoing group search problems ... (1997)
WC 2.0 frames feature (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[append] (1997)
GuestBook example (1997)