Re: Change Subtotal
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36451
interpreted = N
texte = Look in your local downloaded webcat HTML reference, in here- WebCatalog/WebCatReference/FormulaFormat.html and notice the things that can have a formula.Discount is not one of them.The below is as if saying- 'discount' = [value_of_lookup]price=([subtotal*.5)which makes no sense.you want a formula that says- 'price' = (see if I am a special discount lineitem, *and if so* then my price equals a negative (.5*[subtotal]) (or whatever is the criteria for the determining the discount). If I am not a special discount SKU, then my price equals [lookup into product.db for my sku]add a record in formulas.db with price on the left side and whatever you need on the right side to figure out the amount the appropriate discount should be-JohnGlenn Busbin wrote:> > > >In the formulas.db I put this formula: > >Discount [lookup > >db=dbname&lookinfield=sku&value=2&returnfield=price]price=[math][subtotal]*. > >50[/math]] > > > > Looks like customers get the 50% discount no matter what they order. Is > this so? If it is, I'd just drop all prices 50% and forgate the > complications. > > If not, use the criteria used to determine if the discount is warranted, If > it is, THEN reduce the price accordingly. In the Formulas.db: > > I really can't tell what your basing the discount on. > > Glenn > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Look in your local downloaded webcat HTML reference, in here- WebCatalog/WebCatReference/FormulaFormat.html and notice the things that can have a formula.Discount is not one of them.The below is as if saying- 'discount' = [value_of_lookup]price=([subtotal*.5)which makes no sense.you want a formula that says- 'price' = (see if I am a special discount lineitem, *and if so* then my price equals a negative (.5*[subtotal]) (or whatever is the criteria for the determining the discount). If I am not a special discount SKU, then my price equals [lookup into product.db for my sku]add a record in formulas.db with price on the left side and whatever you need on the right side to figure out the amount the appropriate discount should be-JohnGlenn Busbin wrote:> > > >In the formulas.db I put this formula: > >Discount [lookup > >db=dbname&lookinfield=sku&value=2&returnfield=price]price=[math][subtotal]*. > >50[/math]] > > > > Looks like customers get the 50% discount no matter what they order. Is > this so? If it is, I'd just drop all prices 50% and forgate the > complications. > > If not, use the criteria used to determine if the discount is warranted, If > it is, THEN reduce the price accordingly. In the formulas.db: > > I really can't tell what your basing the discount on. > > Glenn > > ------------------------------------------------------------- > 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/
John Butler
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] ONLY the FIRST continuous run of numeric chars? (2008)
Sandbox DB permissions (2005)
Form/HTML Help (2000)
[WebDNA] WebDNA code validator (2011)
problems with WebCat-Plugin (1997)
WCS Newbie question (1997)
{Grouping} Docs (1999)
Converting characters to numbers ... (1997)
Adding order weight (1999)
can webcat determine an image's pixel dimensions? (2000)
Test (2002)
Why are some admin pages not encrypted? (2000)
Mac 2.1b2 speed (1997)
Multiple edits/replacementsd to db. Possible? (1997)
WebCat2 beta 11 - new prefs ... (1997)
Delayed Redirect (2000)
Include error (2000)
Cookie Question (1999)
Shopping Cart Best Practices (2006)
2.0Beta Command Ref (can't find this instruction) (1997)