Php / mysql mobile web form with csv export and extra options
- or -
Post a project like this2364
$
- Posted:
- Proposals: 19
- Remote
- #1737266
- Awarded
PHP, Wordpress, Drupal, Magento, Data Entry, Administrative and Technical Support, SEO, Digital Marketing
Kingston
13070812534811855938185343918401551726490171009516327881623145138486413097481195749
Description
Experience Level: Entry
General information for the website: Digitization of checklist forms for a food processing company
Description of every page/module: The company makes ready-to-eat salads. These are distributed through supermarkets in Belgium, Germany and The Netherlands.
There are 5 production lines and we need to do a checklist before during and after a production run on each line.
Here is the workflow we came up with...
1. Start Production Run
You see the 5 production lines including their status (free, pre-production, production) If you want to start a production you choose a production line that's free (let's use Line 3 as an example.) When you click on Line 3 it will display a form with 16 fields to complete. Once all completed you can click send. The data is stored (including the date and time when it was sent) and the website returns back to the main screen. Here you'll see Line 3 will be in pre-production.
2. Pre-Production
After about 10 salads have been made we need to do another checklist. You click on the link of Line 3 and it takes you to another form that has 15 fields to complete (some text some checkboxes). You have to complete them all. When you've done that you click send and the data will be stored including the timestamp when you clicked send.
The screen returns to the main window and you see the 5 production lines again, the status of Line 3 will now be Production
3. After production
When production has finished you click on Line 3 again and the system takes you to yet another form with 10 fields to complete. Once you've done that and click sent the timestamp will also be stored in the database
Description of requirements/features: see description of every page / module
CMS and Admin requirements: So we've collected a lot of data in a MySQL Database but we need a CSV export (or excel export) and a very important issue is that all the data of a production run has to be one record (one line in the csv or excel export) So the three different forms have to be combined into 1 record in the csv or excel export.
Similar urls: forms.google.com
Extra notes: We will enter the data with a smartphone (android) so the website should be mobile friendly
This is only one form, we've got to do many forms. A few of them I can make easily in google forms but some of them need more attention so if this project goes well, there might be more to come...
Description of every page/module: The company makes ready-to-eat salads. These are distributed through supermarkets in Belgium, Germany and The Netherlands.
There are 5 production lines and we need to do a checklist before during and after a production run on each line.
Here is the workflow we came up with...
1. Start Production Run
You see the 5 production lines including their status (free, pre-production, production) If you want to start a production you choose a production line that's free (let's use Line 3 as an example.) When you click on Line 3 it will display a form with 16 fields to complete. Once all completed you can click send. The data is stored (including the date and time when it was sent) and the website returns back to the main screen. Here you'll see Line 3 will be in pre-production.
2. Pre-Production
After about 10 salads have been made we need to do another checklist. You click on the link of Line 3 and it takes you to another form that has 15 fields to complete (some text some checkboxes). You have to complete them all. When you've done that you click send and the data will be stored including the timestamp when you clicked send.
The screen returns to the main window and you see the 5 production lines again, the status of Line 3 will now be Production
3. After production
When production has finished you click on Line 3 again and the system takes you to yet another form with 10 fields to complete. Once you've done that and click sent the timestamp will also be stored in the database
Description of requirements/features: see description of every page / module
CMS and Admin requirements: So we've collected a lot of data in a MySQL Database but we need a CSV export (or excel export) and a very important issue is that all the data of a production run has to be one record (one line in the csv or excel export) So the three different forms have to be combined into 1 record in the csv or excel export.
Similar urls: forms.google.com
Extra notes: We will enter the data with a smartphone (android) so the website should be mobile friendly
This is only one form, we've got to do many forms. A few of them I can make easily in google forms but some of them need more attention so if this project goes well, there might be more to come...
Frank B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
6 Oct 2017
Belgium
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Frank
TASK
I. three different forms have to be combined into 1 record in the csv or excel export
Can you share an example final format?
This need to be exported from the website?
515245
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies