Quote Database

I have a Filemaker database that we use to log and track our quotes. The file is shared with Instant Web Publishing and I get info out of the database with Crystal reports. The database needs to be rebuilt so that I can get more info out of it.

The main problem with the database is that the items that are quoted are in text block and that makes the information less usable once I export it. I tried to make the item a repeating field, but then I cannot export the information.

The database needs to be accessible for updates via the web for users to enter their quotes. I need to be able to get the data out to use in excel (either through Crystal Reports or as an export to Excel).

The database fields will be

Salesperson (needs to be limited to certain values)

Quote Date (format checked)

Quote number (auto generated in sequence)

Customer Name (drop down, from a lookup to another table)

Status (drop down, needs to be limited to certain values)

Chance of Winning (drop down, needs to be limited to certain values)

Order Expected (drop down, List of Calendar months)

Comment (text field)

The following items will appear 10 times

Quantity (numerical only)

Item (drop down, lookup to table with list of items)

Price (numberical)

Extended Price (Quantity * Price)

After the 10 fields we need a Total Quote, which will be the total of the extended price fields.

All fields are required to submit the entry.

**I am open to discuss solutions with programs other than Filemaker Pro (MySQL or whatever else might work). That is what I have used because it's what I know. Whatever will get the job done is fine. The database must be reliable, web accessible, and provide me with the information I need. Via the web users must be able to enter records, but then also be able to search for them update them at later date**

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

The database with reside on a server that runs Windows Server 2003.

Habilidades: Administração de Bancos de Dados, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: working solutions data entry, winning quote, what is database entry, what is a data entry form in a database, web publishing information, web pro solutions, track quotes, submit a quote, site update solutions, salesperson hire, pro web solutions, order form format in excel, open source data entry software, number sequence solutions, mysql customer database, make a calendar in excel, i need to hire a salesperson, file status 22, filemaker work, excel data entry form 2007, engineering job search, data entry software programs, data entry software open source, data entry programs list, data entry form excel 2003

Acerca do Empregador:
( 46 comentários ) United States

ID do Projeto: #2967786

Concedido a:


See private message.

$595 USD em 20 dias
(17 Comentários)