Web app for in store surveys

JavaScript and client side scripting.

Moderator: General Moderators

Post Reply
abhic
Forum Newbie
Posts: 10
Joined: Sat Sep 27, 2003 3:56 pm

Web app for in store surveys

Post 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.
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post 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 :P

4) fopen() fputs() fclose() etc.
abhic
Forum Newbie
Posts: 10
Joined: Sat Sep 27, 2003 3:56 pm

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
abhic
Forum Newbie
Posts: 10
Joined: Sat Sep 27, 2003 3:56 pm

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
abhic
Forum Newbie
Posts: 10
Joined: Sat Sep 27, 2003 3:56 pm

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply