Re: shipping costs
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26723
interpreted = N
texte = I did have success with showif and hideif finally.buttaxes got screwy, since those are added to achieve the Grandtotaland I was hiding grandtotal and substituting subtotal in its place ifsubtotal was >50.00I'll try the new formula----- Original Message -----From: PCS Technical Support
To: WebCatalog Talk Sent: Saturday, January 29, 2000 7:34 PMSubject: Re: shipping costs> >I have a unitShipCost for each item in the database> >In formulas.db I have the shipcost set to 0.00> >> >This works out fine . . . . but one the total order equals $50.00shipping> >will be free.>> This one is a little bit complex, because you're basically asking it> to throw out the old shipCost calculation and replace it with a new> one 'after the fact'. I think the following formula should work:>> -- Formulas.db --> Name Formula> shipCost [math> show=f]tempSC=[lineitems][quantity]*[unitshipcost]+[/lineitems]0[/math> ][showif [subtotal]>50]-[tempSC][/showif][hideif> [subtotal]>50][tempSC][/hideif]>> This email will have a linebreak in the middle of the formula> somewhere; you should make sure this is all on one line to work> properly in your formulas.db.>> What we're doing with this formula is to first loop thru all the> lineitems and use math to compute the qty*unitshipcost total for all> items, then we decide if the order is more than $50. If so, we send> back a *negative* shipCost, which sort of 'removes' the original> shipping cost from the grand total. If the order is more than $50,> we simply return the shipCost we just computed.>> Technical Support **********************************> Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software> 16855 West Bernardo Drive | -------------------------> Suite 380 | eCommerce (WebCatalog)> San Diego, CA 92127 | Software & Site Development> 858.675.1106 | http://www.smithmicro.com> 858.675.0372 (fax) **********************************>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant MessagingServer.> To end your Mail problems go to .>> 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>>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
I did have success with showif and hideif finally.buttaxes got screwy, since those are added to achieve the Grandtotaland I was hiding grandtotal and substituting subtotal in its place ifsubtotal was >50.00I'll try the new formula----- Original Message -----From: PCS Technical Support To: WebCatalog Talk Sent: Saturday, January 29, 2000 7:34 PMSubject: Re: shipping costs> >I have a unitShipCost for each item in the database> >In formulas.db I have the shipcost set to 0.00> >> >This works out fine . . . . but one the total order equals $50.00shipping> >will be free.>> This one is a little bit complex, because you're basically asking it> to throw out the old shipCost calculation and replace it with a new> one 'after the fact'. I think the following formula should work:>> -- formulas.db --> Name Formula> shipCost [math> show=f]tempSC=[lineitems][quantity]*[unitshipcost]+[/lineitems]0[/math> ][showif [subtotal]>50]-[tempSC][/showif][hideif> [subtotal]>50][tempSC][/hideif]>> This email will have a linebreak in the middle of the formula> somewhere; you should make sure this is all on one line to work> properly in your formulas.db.>> What we're doing with this formula is to first loop thru all the> lineitems and use math to compute the qty*unitshipcost total for all> items, then we decide if the order is more than $50. If so, we send> back a *negative* shipCost, which sort of 'removes' the original> shipping cost from the grand total. If the order is more than $50,> we simply return the shipCost we just computed.>> Technical Support **********************************> Smith Micro, Internet Solutions Div | Formerly, Pacific Coast Software> 16855 West Bernardo Drive | -------------------------> Suite 380 | eCommerce (WebCatalog)> San Diego, CA 92127 | Software & Site Development> 858.675.1106 | http://www.smithmicro.com> 858.675.0372 (fax) **********************************>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant MessagingServer.> To end your Mail problems go to .>> 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>>-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Richard
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:
[WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011)
Post arguments problem mac? (1997)
Secure server question (1997)
[movefile] prob (2005)
PCS Frames (1997)
Reversed words (1997)
SiteEditPro (1996)
Drop Down Menus (2002)
searching with groups (1997)
linetiems in thankyou.tpl (1997)
Searching an Email database (1997)
TaxTotal Problem (1997)
[referrer] tag (1997)
web delivery (1997)
getmimeheader host on my local machine (2003)
RAM variables (1997)
Multiple security dbs (1997)
Dumb Question about Docs (1997)
[OT] KeepItUp for Windows (2003)
Migrating to NT (1997)