Generate invoice from form

Does anyone have some suggestions on how I can generate an “invoice”
from a registration form?

The organization I’m supporting wants to collect registration
information from prospective members and automatically generate an
invoice.

I think I can do this with “forms to go” and send membership details
and an invoice via an email, but is there also a way to generate a
page with the same information that could be printed out? Could I use
mals to do this?

They also want to be able to see a current member database on the site
from these registrations but that’s something to challenge me down the
road.

Any help much appreciated.

Bill


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

This is one of those things that are simple if you know how, and
pretty hard to cobble together out of pieces if you don’t.

Basically, your customer would like a simple CRM (Customer Resource
Management) System. The way I would approach this would be to add a
MySQL database (or a table to an existing database) to the server,
and then put fields in that table representing each data point about
your members. Each successful form submission would add a row to the
database, and from there, your options as to presentation are
virtually unlimited.

You could make one view that showed a pretty and colorful
confirmation layout of the data just posted, another that is a
“printer friendly” layout, another that shows a table of all
registrants, etc. And of course, you could bundle up that same data
as an e-mail “tickler” to the client.

All of this is very basic data storage and retrieval, but it’s only
basic if you’re making the thing from scratch. Ironically, if you’re
trying to get packaged solutions (like FTG) to make the data layer
for you, then you’ve got to un-twist their code, insert your own,
hope that the next time you publish you don’t un-do what you just
added, etc…

If you want to learn how to do this (and I believe sincerely that
everyone who designs sites should know at least in principle how this
works) then the first port of call would be Keith’s PHP/MySQL
tutorials at http://thehelpful.com . If what you see there doesn’t
scare you off (as if!) then a Fat Book or two would be your next
step. It is certainly possible to learn this to a degree where you
can either do something simple, or at least be conversant with
someone you hire to do it, without a lot of time or effort.

Walter

On Oct 3, 2008, at 1:16 AM, Bill McCarroll wrote:

Does anyone have some suggestions on how I can generate an
“invoice” from a registration form?

The organization I’m supporting wants to collect registration
information from prospective members and automatically generate an
invoice.

I think I can do this with “forms to go” and send membership
details and an invoice via an email, but is there also a way to
generate a page with the same information that could be printed
out? Could I use mals to do this?

They also want to be able to see a current member database on the
site from these registrations but that’s something to challenge me
down the road.

Any help much appreciated.

Bill


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options