Re: Filemaker Pro Template for Orders

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25038
interpreted = N
texte = Hi John:Thanks John for the tip...for some reason I forgot that I could use append as a context. This was much simpler than I imagined. However, I have one remaining question.Currently, I am successfully capturing the customer information into a database via an append context. This includes name, address, etc. But, I would also like to capture what that person purchased and the amount they spent. Currently, on the thankyou page where I have placed the append context, it displays items purchased using [lineitems] items and amount information here [/lineitems]. So, I tried to place this within the [append] context like this:&purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal]But, this did not work. I think part of the trick is that I want to capture both single and multiple item purchases into one field in my capture database.Where am I going wrong?Tim> From: John Butler > You can use an [append] context. See the docs. You will be delighted to find > that you > can stuff your templates with loads of contexts all doing different things. > The basic > templates you got from general store is just a sample skeleton... you can > do LOTS > more... just need to familiarize yourself with webcat commands, contexts > (better to use > these over commands), and global tags... > > -John > > Timothy W. Killian wrote: > >> Thanks for the tip...but that leaves me with some additional questions: >> >>>> Have any of you created a Filemaker Pro file to import the standard WebCat >>>> Order file? Complete with real names of fields and all? If so, would you be >>>> willing to send me a copy of the template? >>>> >>>> Thanks... >> >>> Timothy you would be better writing all your orders to databases and >>> importing that. The orderfiles are great but they are still files, >>> you have much more flexibility with databases. >>> For example we write to 2 .dbs one has the shopper info with the >>> [cart] as key and the other has the products with [cart] again used >>> as a key. These 2 .dbs provide us with all the reporting we need. >>> >>> Micheal O Shea Email:micheal@com4u.ch >> >> I understand how to append information to a database. I am doing this on a >> different part of the web, where individuals can sign up for a mailing list >> and give us some information. >> >> Clearly, I would love to do this with my orders as well, capturing all >> information into a database so that I wouldn't have to get this info from >> the order file as you suggest. But, can I simply use the append command to >> write to a database at the same time I am using the shopping cart? >> >> Here is what confuses me. Currently, I am using the basic shopping cart that >> I took from the general store templates. The form already uses the hidden >> command showcart and purchase, and it is already calling the store db. >> Can I just additionally add a 2nd command to the same form, and call a 2nd >> db as well? How does this all work? >> >> Any help offered would be greatly appreciated. >> >> Tim >> >> ------------------------------------------------------------- >> 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 >> > > > ------------------------------------------------------------- > 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 > ------------------------------------------------------------- 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:

    
  1. Re: Filemaker Pro Template for Orders (John Butler 1999)
  2. Re: Filemaker Pro Template for Orders (Nitai 1999)
  3. Re: Filemaker Pro Template for Orders (Timothy W. Killian 1999)
  4. Re: Filemaker Pro Template for Orders (John Butler 1999)
  5. Re: Filemaker Pro Template for Orders (Timothy W. Killian 1999)
  6. Re: Filemaker Pro Template for Orders (Michael O Shea 1999)
  7. Filemaker Pro Template for Orders (Timothy W. Killian 1999)
Hi John:Thanks John for the tip...for some reason I forgot that I could use append as a context. This was much simpler than I imagined. However, I have one remaining question.Currently, I am successfully capturing the customer information into a database via an append context. This includes name, address, etc. But, I would also like to capture what that person purchased and the amount they spent. Currently, on the thankyou page where I have placed the append context, it displays items purchased using [lineitems] items and amount information here [/lineitems]. So, I tried to place this within the [append] context like this:&purchase=[lineitems][itempurchased][/lineitems]&totalspent=[grandtotal]But, this did not work. I think part of the trick is that I want to capture both single and multiple item purchases into one field in my capture database.Where am I going wrong?Tim> From: John Butler > You can use an [append] context. See the docs. You will be delighted to find > that you > can stuff your templates with loads of contexts all doing different things. > The basic > templates you got from general store is just a sample skeleton... you can > do LOTS > more... just need to familiarize yourself with webcat commands, contexts > (better to use > these over commands), and global tags... > > -John > > Timothy W. Killian wrote: > >> Thanks for the tip...but that leaves me with some additional questions: >> >>>> Have any of you created a Filemaker Pro file to import the standard WebCat >>>> order file? Complete with real names of fields and all? If so, would you be >>>> willing to send me a copy of the template? >>>> >>>> Thanks... >> >>> Timothy you would be better writing all your orders to databases and >>> importing that. The orderfiles are great but they are still files, >>> you have much more flexibility with databases. >>> For example we write to 2 .dbs one has the shopper info with the >>> [cart] as key and the other has the products with [cart] again used >>> as a key. These 2 .dbs provide us with all the reporting we need. >>> >>> Micheal O Shea Email:micheal@com4u.ch >> >> I understand how to append information to a database. I am doing this on a >> different part of the web, where individuals can sign up for a mailing list >> and give us some information. >> >> Clearly, I would love to do this with my orders as well, capturing all >> information into a database so that I wouldn't have to get this info from >> the order file as you suggest. But, can I simply use the append command to >> write to a database at the same time I am using the shopping cart? >> >> Here is what confuses me. Currently, I am using the basic shopping cart that >> I took from the general store templates. The form already uses the hidden >> command showcart and purchase, and it is already calling the store db. >> Can I just additionally add a 2nd command to the same form, and call a 2nd >> db as well? How does this all work? >> >> Any help offered would be greatly appreciated. >> >> Tim >> >> ------------------------------------------------------------- >> 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 >> > > > ------------------------------------------------------------- > 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 > ------------------------------------------------------------- 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 Timothy W. Killian

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:

Upcoming 2.1 Release and PCS Committment (1997) no global [username] or [password] displayed ... (1997) WebCat2 several catalogs? (1997) flushdatabases (1997) FileMaker and WebCat (1999) Order not created error (never mind) (1997) Sendmail truncation in Eudora Clients (1998) Text data with spaces in them... (1997) [OT] Live Chat with Video capability (2008) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) ShowNext Context (2004) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) HTML E-mails demystified (2002) dates and hex formatting (1997) Is [variable] a Number? (2007) [SHOWNEXT] Examples (1997) WC2b15 File Corruption (1997) webcat license???? (1997) Founditems (1998) Error:Too many nested [xxx] contexts (1997)