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.
Web app for in store surveys
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
1) Use simple html forms:
2) time() and date()
3) More html
4) fopen() fputs() fclose() etc.
Code: Select all
<select name="something">
<option value="some_value">Some Value</option>
<option value="some_value2">Some Value 2</option>
</select>3) More html
4) fopen() fputs() fclose() etc.
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.
As for how to handle textfiles, check out the PHP online manual - there's tons of stuff there.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
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:
as an example
Code: Select all
CREATE TABLE surveys (timestamp int(11), name varchar(255), question1answer text, question2answer text);Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
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.
If you wouldn't mind I would like some help getting this app going.
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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.