Page 1 of 1
Web app for in store surveys
Posted: Fri Nov 12, 2004 7:56 am
by abhic
Hello
I am just helping my wife start out her new store and we needed some quick instore data entry. So I created a nice Excel sheet for it.
We couldn't afford more than one MS Office license so we had to use OpenOffice on one of our computers. Now OpenOffice wont run macros or anything with VBA. So I need to do something like this file, only online and hopefully something very simply like a text file to write the data down.
Basically what I want to do is:
i. Choose pre set drop down values in pre set categories
ii. autodate each entry
iii. easy web based form style
iv. simple text file backend
If you guys have any idea that would be great. Thank you
Regards.
Posted: Fri Nov 12, 2004 8:09 am
by kettle_drum
1) Use simple html forms:
Code: Select all
<select name="something">
<option value="some_value">Some Value</option>
<option value="some_value2">Some Value 2</option>
</select>
2) time() and date()
3) More html
4) fopen() fputs() fclose() etc.
Posted: Fri Nov 12, 2004 11:11 am
by abhic
Hi,
thanks. I am working on creating that list up in those forms. But I have no clue about auto inserting time() and date() into the text file and how to handle the text file. I am not much of a coder. thanks anyway.
Posted: Fri Nov 12, 2004 4:25 pm
by pickle
Is there a reason you'd rather use a text file than a database? Using a database, it'd be much easier to create statistics. It's also a little less cryptic I think, on how to handle data in a database as opposed to a textfile.
As for how to handle textfiles, check out the PHP online manual - there's tons of stuff there.
Posted: Fri Nov 12, 2004 4:48 pm
by abhic
hi Pickle,
No not a specific reason, just thought importing data from a text file into a excel sheet on a regular basis to crunch the figures would be much easier than taking it out of a mysql db. But if I can get the exact commands to add those tables in the existing db, that would be great.
Posted: Fri Nov 12, 2004 5:12 pm
by pickle
Well, in my experience, it's just as easy to pull data out of a database and massage them into a spreadsheet, than it is to pull data out of a file and massage it. Creating tables in a MySQL database is easy once you know the syntax:
Code: Select all
CREATE TABLE surveys (timestamp int(11), name varchar(255), question1answer text, question2answer text);
as an example
Posted: Fri Nov 12, 2004 5:30 pm
by abhic
Alright that helps. Yeah I am not a web coder guy I generally use copy paste stuff and figure my way out whenever I need to. You could check out my site at
http://www.vritti.net
If you wouldn't mind I would like some help getting this app going.
Posted: Fri Nov 12, 2004 5:38 pm
by pickle
The site looks pretty good design-wise I must say. If you want people to help you out on a project, your best bet is to post something in the "Volunteer Work" board. If the project is simple enough, you might be able to find someone. The majority of the time though, people will be WAY more willing to help you with questions you may have as you're building an app, than they will to just do the whole thing for you.