+ Reply to Thread
Results 1 to 15 of 15

HTML or a Web Form using Excel as the database....

  1. 03-30-2013, 03:01 PM #1
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    HTML or a Web Form using Excel as the database....

    Hi All,

    I知 requesting for help to Create a Web / HTML Form.

    1. I get a CSV / XLSX file daily which has some data (Demographics part of the attachment)
    2. Request is to be able to upload this file on an interface. Each entry can be filtered by using the unique code in each line using a dropdown menu
    3. After filtering I値l need to deal with each entry individually my team needs to plug in the feedback (The questions in the attached Feedback form should appear on the web form similar to a survey link / feedback form)
    4. Once the data is fed I should be able to extract the complete dump in the form of a CSV / XLSX file with details

    I知 not sure if this can be done, and if this is the right place to post this query.

    I値l appreciate if someone could help me create this or direct me to the right path.

    Thanks a lot in advance!

    Spi
    Attached Files Attached Files
    Last edited by spiwere; 03-31-2013 at 02:13 PM.
    Reply With QuoteRegister To Reply
  2. 03-31-2013, 01:45 AM #2
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Create a Web Form for populating data and then exporting results in Excel

    Request some guidance and help on this...

    Please advise....

    Thanks!
    Reply With QuoteRegister To Reply
  3. 03-31-2013, 03:21 AM #3
    AndyLitch
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Create a Web Form for populating data and then exporting results in Excel

    Attachment 224702

    is this the kind of thing you're looking for ?
    Reply With QuoteRegister To Reply
  4. 03-31-2013, 04:55 AM #4
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Create a Web Form for populating data and then exporting results in Excel

    I don't have access to my system currently, which is why I haven't been able to see what it exactly looks likes.

    What I'm actlually looking for is a weblink or similar where I can upload a file with Demographic details, and my team can then use it to provoide feedback,with the goal of getting it back in an CSV of XLS format. The data needs to get cumumative at the backend with giving us flexibility to retrive back in excel.

    Thanks for your help!

    Please let me know if you have any questions.

    Best regards,
    Spi
    Reply With QuoteRegister To Reply
  5. 03-31-2013, 06:40 AM #5
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Create a Web Form for populating data and then exporting results in Excel

    Dear Andy,

    I just saw the awesome piece of work you've shared with me it is phenomenal. I'm absolutely amazed with the type of work you all do here and help keen learners and xl enthusiasts like me learn and help solve our problems. Much appreciative of everything is all I can say....

    Truly a superb piece!

    Just wanted to check if you got a chance to review my request in post 4. Please let me know if you have any questions or with directions as you deem fit.

    An example of what I'm really after at this point is something on these lines: http://smaudience.surveymonkey.com/S...ctRequest.html or something similar...

    Thanks!
    Reply With QuoteRegister To Reply
  6. 03-31-2013, 08:06 AM #6
    AndyLitch
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Create a Web Form for populating data and then exporting results in Excel

    Thanks for the compliment but I have to say the questionnaire generator wasn't my piece of work.. It was uploaded to the forum by somebody who's name eludes me now.. I thought it may fit the bill for what you were looking for so there's no point in me re-inventing the wheel.
    As for web based stuff, I really can't help you there I'm afraid.
    Reply With QuoteRegister To Reply
  7. 03-31-2013, 08:25 AM #7
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Create a Web Form for populating data and then exporting results in Excel

    No worries! Your interest in helping in one way or the other keeps our motivation going!

    Do you think a web form like the one I am looking for can be done without a database as such i.e. using excel 2007 or 2010?

    Actually, am I seeking the help in the right direction is what I want to know...

    I'll also try and embed my questions in what you've shared to see if it helps.... I'm assuming it is dynamic enough in terms of adding more questions etc...The only concern is about pre-loading the Demographics in this questionnaire (my first part in the doc I shared in the first post).

    Thanks for all the great help!

    Please advise...
    Reply With QuoteRegister To Reply
  8. 03-31-2013, 08:50 AM #8
    AndyLitch
    AndyLitch is offline
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Create a Web Form for populating data and then exporting results in Excel

    I'm pretty sure it's possible to create a questionnaire in Excel and upload it to the web but don't quote me LOL....
    Reply With QuoteRegister To Reply
  9. 03-31-2013, 09:22 AM #9
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: Create a Web Form for populating data and then exporting results in Excel

    Thanks a ton! Wish you good luck on all your endevaours. Hoepfully, I'll get to what I need with some assistance of experts like you!

    Cheers!!!
    Reply With QuoteRegister To Reply
  10. 03-31-2013, 02:16 PM #10
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: HTML or a Web Form using Excel as the database....

    Hi All,

    I'm in need of some help with creation of a HTML or a Web Form that can be used to populate data. Please advise...


    Best regards,
    Spi
    Reply With QuoteRegister To Reply
  11. 03-31-2013, 10:30 PM #11
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: HTML or a Web Form using Excel as the database....

    Hi All,

    Request is for some help with creation of a HTML link or a Web Form that can be used to populate data, which get captures at the backend in excel. Is this possible?

    Please advise...


    Best regards,
    Spi
    Reply With QuoteRegister To Reply
  12. 04-01-2013, 04:39 AM #12
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: HTML or a Web Form using Excel as the database....

    No it isn't, at least not reliably - Excel is not a web medium.

    Why not have a look at google forms?
    Reply With QuoteRegister To Reply
  13. 04-01-2013, 04:50 AM #13
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: HTML or a Web Form using Excel as the database....

    I did, but with very little use knowledge I couldn't figure out how to do it. Could you please assist...

    Thanks for your reply!
    Reply With QuoteRegister To Reply
  14. 04-01-2013, 08:17 AM #14
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: HTML or a Web Form using Excel as the database....

    Hi All,

    Google Forms was pretty easy though not a complete solution to my problem!

    While I research to get to what I'm looking for. Could any one advise if there is a way to add a CSV / XL file with some pre-populated data that can be filtered on the Google Form itself depending upon the criteria on which the form is to be filled like: Date, Name Branch, etc..

    Ideally, I would like to upload a CSV file with some Demographics etc. That need to be filtered before filling the form. Is it possible with Google Forms? I need to do this daily, and the explanation and provision here does not cater to what I need, unless I'm missing anything....

    Pre-populate form answers

    ****
    If you'd like to send respondents a form with some fields already filled in, Google Forms makes it easy. Here's how to pre-populate form answer fields:

    While working on your form, click the Responses menu, then select Get pre-filled URL.
    Fill in any answer fields you'd like to pre-populate.
    Click Submit.
    To send the pre-populated form to respondents, use the URL provided.
    ****
    Please advise.
    Reply With QuoteRegister To Reply
  15. 04-03-2013, 01:52 PM #15
    spiwere
    spiwere is offline
    Forum Contributor spiwere's Avatar
    Join Date
    01-11-2013
    Location
    IN
    MS-Off Ver
    Excel 2007
    Posts
    410

    Re: HTML or a Web Form using Excel as the database....

    Hi All,

    I've found something very good while I was trying to determine a solution here...

    Not sure how relevant it would be though for you

    However, for the benefit of everyone. I'm sharing this here...Hope this comes handy.

    Do check this out:

    http://www.surveycrest.com

    Super, Easy, Perfect is all I've got to say.

    Cheers!!!
    Last edited by spiwere; 04-03-2013 at 01:56 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1