+ Reply to Thread
Results 1 to 1 of 1

Inactive between database and webpage?

  1. #1
    Forum Contributor
    Join Date
    09-10-2016
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    680

    Inactive between database and webpage?

    Let us say, I want to perform data analysis (average income of a large population), and randomly select some person as sample.
    There are two tables (Income & Error) in database. Questionnaire data is manually entered into table Income.
    A program is designed to clean the table Income data. If the questionnair can be fixed, then fix it. If it cannot be fixed, leave it as it is.
    • Person 111/112/113/114: All of them do not answer the questionnaire properly/correctly.
    • Person 111/113/114: After running the program, their data is fine now.
    • Person 112: The data cannnot be fixed, it cannot be included for data analysis.
    • Person 115: Original data is clean already, so it does not show up in table Error.



    As mentioned above, the original data is manually entered into table Income. If it is changed to internet data collection, that being said, there will be webpage to collect data, something like online survey.
    Now here are three questions:
    1. When person clicks Submit button on webpage, how to transfer webpage input data into database table Income? What knowledge/what programming language is needed to learn?
    2. After clicking Submit button, how to automatically trigger the program to run on the his/her submitted data? What skill is needed for this step?
    3. If the submitted data is not clean, how to pull error message from table Error and display the error message on the webpage? What skill/what programming language is needed? For person 111/112/113/114, I prefer to display error message for all of them, and let every one to submit clean data only.


    I want something like online credit card application process: if application form data is good, then the application can be successfully submitted, and data will be transferred to database table; if applicant form data is not good, then applicant needs to fix the data, then submit again, until application form data is clean.
    Attached Images Attached Images
    Last edited by VAer; 06-20-2018 at 08:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Webpage doesn't get fully loaded. Want to use a VBA code to wait for the webpage.
    By Danzong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2017, 02:55 AM
  2. Webpage not updating with values entered into webpage inputbox
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2016, 08:16 AM
  3. Vba code for using webpage ( Tracking Goods c/ment on webpage)
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2013, 06:03 AM
  4. [SOLVED] Load webpage on TOPMAN website, extract prices from webpage into Spreadsheet
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 11:49 AM
  5. Macro to Open webpage, then save webpage as txt file.
    By jasocke2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2012, 04:25 AM
  6. Creating Dynamic Database to Webpage - Details Inside
    By cjm2010 in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 03:38 PM
  7. Extract database from webpage
    By Bru86 in forum Excel General
    Replies: 0
    Last Post: 08-04-2008, 10:01 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1