How to Design Member Collaboration Form To Collect Data, Upload Files, Resume, Pics
Member Collaboration Form allows you, when members login, you request them to submit information through a Smart Form that is used to collect form data and saved data into databases, such as: Customer Service Database, Dealer Register Database, Account Info Database, Feedback database, Resume with Photos Database...
Case Study
The Company needs to collect different data from its private members for its different databases. Such as, company needs to collect different addresses for its Customer Addresses Books database, or Feedback database or collect data for Customer Service Database, Dealer Register Database... In this case study, the company requires you to design A Request For Training and Services Database and send out to its 5000 members see if who are interested in this Training and Services that will be organized next month. So in order to collect this data, you use 2 methods:
- Send Email with Private Url Link Form to all members using eCAMPAIGNER. When members click on that link, will take them to the form and fill out info.
- Use Member Collaboration Form to collect data when members login. Emails send out can be lost or forget or deleted. But Member Collaboration Form is always there available when member logins.
Another case study: Your company needs to have a resumes with photos database. Can you do it without any web skills?
The Solution
myNet.Office. Not only, without web skill, you can design it in 15 Min. But also you can design and modify Member Collaboration Form.
If you can't afford in-house web developer then learn to take control your online destiny.
LOGIN IN YOUR WEBSITE AS ADMIN. LET'S DO IT.
It involves 2 steps. Step 1) Create the Request For Training and Services Database Step 2) Create a Member Collaboration for Request For Training and Services Database using Member Collaboration Action = FORM.
STEP 1 - Create new Database of Request For Training and Services
| CODE DESCRIPTION | DATA COLLECTION DESCRIPTION |
CREATE TABLE dm_request_for_train_service ( ID int not null auto_increment primary key, EMAIL varchar(60) , Fname varchar(30), Lname varchar(50), Title varchar(30), Company varchar(50), Phone varchar(25), CellPhone varchar(25), Address varchar(200), City varchar(25), State varchar(25), Zip varchar(25), Country varchar(25), Available_Date datetime , type_train enum ("Web Seminar", "On Your Location", "In Our Location", "One On One", "Lunch Time"), Certification enum ("Yes", "No", "Other"), COMMENT text, LIST_PRODUCTS_SERVICES Set ("Product A", "Product B", "Product C", "Product D", "Service A", "Service B","Service C", "Service D"), Office_Used text, Office_Used_DEPARTMENT_RESPONSIBLE enum ("Support Dep", "Sales Dep", "Service Dep", "Marketing Dep", "Any Dep") ); • Copy this blue code. Past in myNet.Dbase Code Area. And click on button [Submit SQL Code]. New database dm_request_for_train_service is created. • You can use Create New Table Template to create this database as well.
|
• CREATE TABLE =
The syntax to create a new table. No case sensitive. • dm_request_for_train_service = Name of the database. Use small case better. • ID int not null auto_increment primary key = Database primary key. It is auto increase when new record inserted. EMAIL varchar(60) = Email of customer. Its field type is text maximum 60 characters. Example: hello@yahoo.com = 15 characters. No case sensitive. Fname varchar(30), Lname varchar(50), Title varchar(30), Company varchar(50), Phone varchar(25), CellPhone varchar(25), Address varchar(200), City varchar(25), State varchar(25), Zip varchar(25), Country varchar(25), Available_Date datetime = The Date and Time for Train or Service. Example, 2009-03-15 13:30 (yyyy-mm-dd Hh:mm). Must include Time. type_train enum ("Web Seminar", "On Your Location", "In Our Location", "One On One", "Lunch Time") = It is ENUM type. Select one from option list. Certification enum ("Yes", "No", "Other") = It is ENUM type. Select one from option list. COMMENT text = Big Text Area contains up to 65000 characters. Used for Member if they have any question or comments, or request. LIST_PRODUCTS_SERVICES Set ("Product A", "Product B", "Product C", "Product D", "Service A", "Service B","Service C", "Service D") = It is SET type. Select as many from check boxes [v]. Office_Used text = It is big Text type. Notes used by in-house staffs. Customers will not see on the form. Office_Used_DEPARTMENT_RESPONSIBLE enum ("Support Dep", "Sales Dep", "Service Dep", "Marketing Dep", "Any Dep") = ENUM filed type. Used by in-house to specify which department is responsible for this Train or Service. Customers will not see on the form. |
Picture: Create new database use code. Copy the above blue code. Past
in myNet.Dbase Code Area. Click on button [Submit SQL Code]. New database
dm_request_for_train_service is created. -> First default empty record. Click on the first column key to enter
data. On the right column is list of all databases to open.
STEP 2 - Use Member Collaboration Action = FORM To Create Collaboration for
Request Train and Service Database.
From topmenu [Collaboration] -> [Create New Member
Collaboration] -> A GUI window pops up [Step 1 of 3]
Picture: Create Member Collaboration Step 1 of 3. Fill all request
info like this picture.
After done STEP 1, click next to go to STEP 2.
Picture: STEP 2: Select Member Collaboration Action = Form [Nifty
format]. A rounded corner blue form format.
After done STEP 2, click next to go to STEP 3.
Picture: STEP 3: Select Member Collaboration Fields. Leave 2 fields
office used. Members are not using these fields, for in house office
used only.
CONGRATULATIONS! YOU HAVE JUST CREATED THE MEMBER COLLABORATION USE
FORM FOR
DATABASE
REQUEST TRAIN AND SERVICE
IN JUST 2 STEPS.
THE RESULT OF THIS MEMBER COLLABORATION JUST CREATED
Now, let say member with email =
ddanpros@hotmail.com logins [Member
Home]. He will see a new member Collaborate Menu =
Form_Train_Service = Task Name, is created (the one high lighted).
Picture: This is [Member Home] when
members login. All Member Collaboration Tasks have created in
the Left Menu. This member clicks on Task = Form_Train_Service. This form
below opens.
Picture: The Member Collaboration Form for database Request Train and
Service. This member fills all data.
- Click on Submit button. After submitted, the Submit button is disable to
prevent second submission.
- The TITLE, and the DESCRIPTION : entering in STEP 1, display on top. All
check boxes auto created for SET data field.
Picture: The same form but selected Table format, not in the blue
Nifty format like the above. The Description displays under the Title.
- The field LIST_PRODUCTS_SERVICES has data type = SET is
automatically converted in to check boxes [v].
- The field TYPE_TRAIN, CERTIFICATION has data type = ENUM are automatically
converted in to pull down list.
Picture: New record is created for database. The SET of multi selection from check boxes [ v] in field LIST_PRODUCTS_SERVICES. Fields used by in-house office are empty because they are not selected. But staffs will fill these info later.
Picture: Data Entry. In house staffs click on record ID = 2 enter data for office used fields. All check boxes fields are automatically checked.
• Later, you want to change the selected Fields, Title, Table for this Member Collaboration, all you need is to use [MEMBER COLLABORATION MANAGER]
Send Email the url link of the form to all Member's Email. They click and fill the form. No need to login
NOTE: You can send email the URL link of this form to all member's email so that they open email, click the link, and fill the form. No need to login.
Using this format:
http://www.yourcompany.com/mynet.office/member/MemberCollaNiftyForm.jsp?Tablename=dm_request_for_train_service&Task=Form_Train_Service
Just change the red data:
- yourcompany = Your domain name website. Example: netthruoffice
- MemberCollaNiftyForm.jsp or MemberCollaTableForm.jsp = the form builder format file name.
- dm_request_for_train_service = the name of database this form connected.
- Form_Train_Service = The Task name you creates in STEP 1.
Go ahead. Create more forms, more web databases like these:
Application Form, Meeting Appointment Form, Upload Files Form, Employee Form, Message Center Form, Support Center Form, Book Address Form, Business Card Form, Office Meeting Form, Survey Form, Register Form, Lead Generation Form, To-Do List Form, Online Petition Form, Contact Form, Customer Satisfaction Survey Form, Customer Service Form, Pricing Survey Form, Invitation Form, Tracking Form, Birthday Party Form, Guess House Form, Recipe Form, Diet Log Form, Personal Diary Form, Ware House Inventory Form, Event Planer Form, Dealer Registration Form, Supply Form, Parts Inventory Form, Seminar Form, Workshop Registration Form, Mailing List Form, Resume Form, Ask/Feedback Form, Appointment Form, Booking Reservation Form, Become A Partner Form, Business Affiliate Form, Sales Inquires Form, Rma Form...
Another example of MBC -> FORM -> Upload Form -> Create A Database Resumes with Photos and A Submit Form.
In this Member Collaboration, Members Upload their Resumes, Photos, Files stored in a database so that HR can access, share, collaborate to all resumes.
You can do without any web skills in 15 minutes.
1) Create a table to store Resumes, Photos.. named: my_upload_files (what ever name)
CREATE TABLE my_upload_files (
ID int not null auto_increment primary key, /* This is database Table Key. */
Email varchar(50), /* This is Member Collaboration Key. */
FIRST_NAME varchar(20),
LAST_NAME varchar(20),
PHONE varchar(25),
COMPANY varchar(30),
SUBMIT_DATE Date,
UPLOAD_RESUME varchar(50),
UPLOAD_COVER varchar(50),
UPLOAD_PHOTO varchar(50),
UPLOAD_PDF varchar(50),
UPLOAD_DOC varchar(50),
UPLOAD_EXCEL varchar(50),
NOTES Text
)
NOTE: You can add more fields for this Resume Database, such as: APPLY_FOR, JOB_TITLE...
2) Create Member Collaboration Task = UPLOAD. See above picture of GUI Steps 2 of 3. Everything is automated. DONE!
** CONGRATULATION! You just built an Online Resume Database System in 15 minutes **
Not only you just created a Resume Database with Photos, but also you created an Upload Resumes Form that lets members upload their resumes and photos. You do it without any web skills. To build a resume database and form like this is not easy even for the pro-web developers.
** Now your company has a beautiful resume database that is easy managed, searchable for every one collaborating, and and sharing anywhere.***
- You can see photo of the job applicant. Resume Files in DOC, PDF... uploaded are store in web server folder. One click, you can open files and view.
NOTE: You don't store the content of resumes in database. Which makes database big and heavy. You store resume files in website server folders. And you store the data of resume, like FNAME, LNAME, PHONE, JOB TITLE in database.
- myNet.Dbase lets you query, search resume database by Name, Title, Demographics...If you add more fields for people to submit form.
- Collaboration Manager lets you go back, Edit or Modify the Member Collaboration Attribute of the Resume Database, and the Form by adding more table fields, changing fields, with no effect on existing data.
- NOTE: You can email the URL Link to Member's email. They click on the link and submit requested files and resumes. No need to login.
** This is just an example that unbelievably you can do this with myNet.Office Member Collaboration Tool **
ASK YOUR WEB DEVELOPER TO DESIGN A RESUME DATABASE SYSTEM LIKE THIS.
SEE HOW LONG THEY CAN DO IT!
• To collect data from members, you have no choice but to use Member Collaboration Form. Data collected saved in database.
• Use the same design concept, you can create all kinds of databases and use Member Collaboration Form to collect data.
• Email the url link Member Collaboration Form to all Member's email. They open email, click on the url link, and fill the form. No need to login.
• Design this Member Collaboration Form is not easy. But, as you see, we show you few steps that you can design without any web skills.