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:
autocommit problem (1998)
[WebDNA] db admin tool (2008)
[protect admin] (1997)
[OT] Bad Cookie / Internet Option / Internet Explorer (2004)
WebCommerce: Folder organization ? (1997)
Setting up shop (1997)
Emailer (1997)
Resume Catalog ? (1997)
os 8.5 (1999)
WebCatalog Hosting (1996)
Setting a null value for reply to address using sendmail... (2001)
'page impression' techniques for banner ads (1999)
Search in 2 or more catalogs (1997)
Country & Ship-to address & other fields ? (1997)
Re:no template caching (1997)
Still can't interpret encrypted templates. (2003)
Summary search -- speed (1997)
cookies (2004)
[isfile] ? (1997)
Sort Order on a page search (1997)