How To Design Add New Partners Member Collaboration

Add New Partner Collaboration is a complex design  for even experienced web developer to design.
 Now, using myNet.OFFICE, not only you can create new collaboration, but also you can Do It Yourself.

 CASE STUDY
 There is no better sales and marketing than from the customers. Specially for small and mid sized businesses, a matter of fact, more businesses are created by customers. Company needs a tool that lets members add new partners to expand more businesses, using customers as indirect sales force. Back in the old days, we used to meet customers and ask them help for referrals. But on the Net, there are tens of thousands customers, all over places. It is impossible to meet all of them. Some time, we don't even know their faces.
• Also, this tool gives customers a quick send email and add new members. Without this tool, your customers have to make a call, talk or meet their friends, their family... Thus waste them too much time. Thus they will be less willingly do it for you. You don't want to waste their time.
 It doesn't matter if new referral members buy or not buy. The matter here is that they now know your company, your products. They are now connected, and are the potential buyers of your company. This will multiply your customers base very quickly.

The Solution: design Add New Partner Collaboration. Which is a tool that allows members add new referral partners.
The Problems
• There is no in-house web developers  available. Contact them, they said will take few days. Charge high consulting fees.
• There is no tool available. When design, they don't design a generic tool so that you can Do-It-By-Yourself. They design customized. Which means next time you need, you depend on them to re-design another interface.  
 • Not all web developers can do this. Or it will take a lot of time for them to build database, tools back end ... in order to support.
What do you do? Here is what you can do:
 1) Forget about it. Give up. Nothing we can do about this. Out of our control. No update. Leave it. Negative!
2) Bring in Web Developers Consulting as full-time staff, who can do serious programming. They design customized things the way you want. Make sure they design tools so that in case they leave you can handle the site by yourself. Yes it is costly but it is a big ROI if compared with the budget you spend for your real office. Positive.
3) Learn myNet.Office. Do it yourselves. Take control your website. Positive!
THE BENEFITS OF ADD NEW PARTNER MEMBER COLLABORATION  

Customers refereed other customers, and other customers are referred by other customer, and multiply. Thus you have a powerful sales force of people. This number will multiply very quickly. Customers always want to help your business success. Reward them.

We will show you how to create this Member Collaboration step by step.  Now, Let's Do It.

 DEFINE THE MEMBER COLLABORATION COMPONENTS

Member Collaboration Source Information
 It is the database table in order to store information of new members.
• Analyze the collaboration table:
- This table will store all info about the new referral members. They are potential real members. But they are not yet a members. Thus, you don't want to use the existing table x_customer to store the new referral members. Right! Thus you must create new table named: x_member_add_partners.

Next, define the Member Collaboration Attribute, which is the fields of this table. In general, what do you need to collect information about new referral members.

• Member Collaboration Key
- It is the field EMAIL of the login member who refers the new member. For example, the table  x_customer has contained this field. Just make sure the table you create contain field EMAIL of member. Because EMAIL on the Net is used as the USER ID for that member to login. It is like Member Key to distinguish between members John Smith and David Smith. It is different with Primary Key of the table that is used to distinguish between records.
- The only table you create that don't need Member Collaboration Key is when you use Task = Broadcast. For example, you create a table promotion for all members login will see the sample promotion: In December Shipping Is Free. In this case, you don't need EMAIL field of members in this table.

 • Member Collaboration Attributes
 It is the fields or columns of x_member_add_partners, the data you need to collect information about new referral members..
- Analyze:  Since they are potential real members. But they are not yet a members. Thus, you don't want to collect a lot information about them. When they order some things and become a true members. Then their info will be stored in the existing table x_customer. So, here is the data. You can add or delete columns or fields in the table x_member_add_partners.
• You can change the fields Member Collaboration Attributes by editing table x_property that stores all property of this collaboration.

New Table: x_member_add_partners
Fields or Member Collaboration Attributes: with ( * ) is required. Other fields are not important, you may remove or change or add extra fields
 
Member Collaboration Attributes or Fields Data Type Description
*** ID int not null auto_increment primary key - Since you don't know what primary key used for this table, just use key name = ID and Data type = int not null auto_increment is ok. Which means that every time a member add a new member, the row record will auto increase to 1.
- This ID is used as table Primary Key.
*** EMAIL varchar(20)
Used for Member Collaboration Key. Must use name EMAIL		 - Is the Customer EMAIL of the customer or member who refer this new member. The reason you use the EMAIL because EMAIL is used as Member Collaboration Key. Thus knowing their EMAIL, you can find out every thing about that customer.
- This EMAIL is used as Member Collaboration Key.
PARTNER_FIRSTNAME varchar(20) - First Name of the new referral member has 20 characters long.
PARTNER_LASTNAME varchar(20) - Last Name of the new referral member has 20 characters long.
PARTNER_EMAIL varchar(40) - Email of the new referral member has 40 characters long. You need the email so that you can contact this member.
PARTNER_PHONE varchar(30) - Phone of the new referral member has 20 characters long. You need the phone so that you can contact this member.
PARTNER_COMPANY varchar(30) - Company of the new referral member has 20 characters long.
SIGNUP_DATE Date - The Date that of this new referral member is referred to you. The exist member who refers this new member must input the data.
SUBJECT_INTEREST varchar(200) - The exist member, who refers this new member, enters few notes to explain why this new member is interested in your products or services. It has 200 characters long. Such as, "- John Smith is interested in this service ABC from your company.."
INTEREST_PRODUCTS_SERVICES Set ( 'Cryptopology', 'Hosting Server XP 35', 'Solidus Keyboard', 'Dell Notebook', 'Software Product', 'Ebusiness Services',
'Consulting Services', 'Training Services', 'Consulting Services', 'Onsite Services'),		 - It is the SET of your products and services that the referral partners like to know. For example, John Smith is the existing member, he knows George may be interest in become a partner. John adds George as partner and also select one or many your products and services
NOTES  varchar (200) Extra notes from the existing member John about George a new partner.
OFFICE_NOTES Text - For office used only. A history of follow up this new referral member is update by you in-house staffs. It is office used only. Since it is Text, it can hold up to more than 60000 characters.
NOTE You do not show or include this field as Member Collaboration Attributes in the form for member to enter.

You can always delete or add more fields. Make sure fields with ( *** ) are not removed or must have.

• Member Collaboration Task
Every time, you want members to add some thing, such as: Member Add New Address, Member Add New Credit Car Number (like in DELL, FUTUSHOP), Member Add New Member. Then Member Collaboration Task = ADD is applied.

Now, you have all info needed for all Member Collaboration Components.
 
CREATE THE ADD NEW PARTNER MEMBER COLLABORATION
To  create Add New Partner Collaboration, you need to do 2 things:

1) Create a new Table to hold the data. You use Code or Create New Table Template.
2) Create Add Collaboration. You use myNet.Office Member Collaboration Tool 

Let's Go to the Setup.
 
Create A Table to Hold Data of new Partners

Let's create new table x_member_add_partners. To create this table, you have 2 choices: Use code or use Create Table Template. Let do both examples.
 
USE  DATABASE PROGRAMMING CODE USE CREATE TABLE TEMPLATE TOOL
CREATE TABLE x_member_add_partners (
ID int not null auto_increment primary key,
email varchar(50),
Partner_FIRSTNAME varchar(20),
PARTNER_LASTNAME varchar(20),
PARTNER_EMAIL varchar(40),
PARTNER_PHONE varchar(25),
PARTNER_COMPANY varchar(30),
SIGNUP_DATE Date,
INTEREST_PRODUCTS_SERVICES Set ( 'Cryptopology', 'Hosting Server XP 35', 'Solidus Keyboard',' Dell Notebook', 'Software Product', 'Ebusiness Services', 'Consulting Services', 'Training Services', 'Consulting Services', 'Onsite Services'),
Notes varchar (200),
OFFICE_NOTES Text
)

- Copy and Paste the blue code in the [Code Area] of myNet.Dbase. The click [Submit SQL Code] button. It create the x_member_add_partners.
- Code is not case sensitive. SIGNUP_DATE or Signup_Date is same.
  1. From menu myNet.Dbase -> Select [Tables] to open Create New Table Template Tool.
     
  2. At ROW 1 for input the Table, enter table name = x_member_add_partners then click submit. Enter only 1 table.
     
  3. At ROW 2 for input the Primary Key, enter the name of the key is ID. Then click submit button. Enter only 1 primary key per table.
     
  4. At ROW 3 for input Fields of table, enter the field name. -> Select its data type. -> Select its size. -> Click on[ Submit] button. Repeat the same things for all fields.
     
  5. Finally, click on button [Create New Table]. one. See more HOW TO CREATE NEW TABLE USING CREATE TABLE TEMPLATE

Now, the table x_member_add_partners is create. Go to next steps to create Member Collaboration Add New Partner.
 
Create Add New Partner Member Collaboration
  1. From topmenu [Collaboration] -> [Create New Member Collaboration] -> A Window Gui pops up, in this screen, first, enter:
    1) Member Collaboration Tasks = Add New Partner. 2) Title = Member Add New Partner. 3) Select Member Collaboration Table = x_invoice from the pull down list of all tables. 4) Description: Enter more details explain for member to understand what about.


     
  2. Next, click Next button in Step 1. You is prompted the screen interface of step 2. In this screen, you select one of the Member Collaboration Task = List. Click to next screen of final step 3.


     
  3. Finally, in step 3, you select fields for Member Collaboration Attribute and click arrow ( -> ) to put selected fields in the right column. Then click OK button. DONE! Congratulation, you have just created another difficult Member Collaboration Add New Partner in just 10 minutes.



    Picture: Final step 3 of collaboration to assign fields for Member Collaboration Attributes.
    You can edit, delete, or modify these fields from table x_property used to store these collaboration property.

It is DONE. CONGRATULATION! You have just created a complex Add New Partner collaboration.
 
THE RESULT OF ADD NEW PARTNER MEMBER COLLABORATION

myNet.Office Member Collaboration Tool automatically generates this screen that has a Form that let members ADD new partners. And a List always comes with Member Collaboration ADD in order to list data after added new Partner. From the Action command of this List, member can Edit, Email and Delete that row record.


Picture: This is [Add New Partner Screen]. myNet.Office Member Collaboration Tool auto generates this screen. Under the form came with a list.
Member with email= ddanpros@hotmail.com logins and click on left menu Add New Partner. He enters data, fills the form. Then clicks on [Submit] button. The new partner = Robert is added in the list right away. The List is maintained by the member. He can edit, send email or delete this Robert partner.

List Action: Edit , Email , Delete , Sort , Not Display That Column

ANALYZE THE ADD COLLABORATION RESULT WHEN MEMBERS LOGIN
Looking at the screen, you can see:
- The Member Collaboration Task = Add New Partner is created as a menu item in the left menu.
- The Title = Member Add New Partner displays as title on the top new [Member Home]
- The Description = If you know any people ... displays under next line.
- The Member Collaboration Attributes like ID, EMAIL, PARTNER_FIRSTNAME...you selected, are used to generated the form. ID = the Primary Key of the table, and the member email ddanpros@hotmail.com = used as the Member Collaboration Key these two keys can't be changed or modified. Fields are required. Enter x if N/A. After submit, data is inserted in table x_member_add_partners.
- When ever you use Add Collaboration, it will create a FORM + a LIST.
- The FORM is created by auto generated by Member Collaboration Tool by looking up the Member Collaborate Attribute fields.
- The LIST is used to display right away all partners of this member when ever this member ddanpros@hotmail.com adds a new partner. This LIST is different from the List of Member Collaborate Task = LIST. In column [Action] of this LIST has 3 icons commands.


Picture: After ADD, a record of new Partner is saved in table x_member_add_partners. If Admin wants to contact Mr. Robert, he clicks on icon email.
 
THE ACTION COMMAND OF THE ADD COLLABORATION LIST

THE LIST EDIT 
When the member want to edit or change information about Partner Email, Partner Phone.. of its partner Robert H, he/she clicks on ID = 2 row. It will open an edit interface. So that this member can change the info.

Picture: When click on Edit icon from the LIST will show this Edit screen that allows member to modify the info of Partners. The check boxes are auto checked for the previous selections. Member updates info, re-check check boxes. Then click [UPDATE] button. Click [<Back] button to go back previous main screen.

 THE  LIST EMAIL

Click on the Action =  Email from the List will pop up this quick Email screen that lets this member sends a quick message to his partner after he added him as Become A Partner in list.

THE  DELETE 
The Action Delete is used by the member to delete item from the list.
For example, let's say the member sent email to the partner Robert, informed him he is added become a partner. But he doesn't like. Then this member can delete him from the list. When click on Delete, it asks again to make sure to you want to delete. Then it deletes that item.
NOTE: You may add an extra filed named STATUS = ENUM of ( "accepted", "not sure", "no thanks") in this table. Just in case the partner Roberts answers not sure.
 
OTHER APPLICATIONS OF ADD COLLABORATION

Depending on your creativity, You design new ADD COLLABORATION for :

• ADD EXTRA ADDRESSES, like DELL or FUTURE SHOP sites create.
• ADD EXTRA CREDIT CARDS, like DELL or FUTURE SHOP sites created.
• .. more..
 
CONCLUSION

• Design Add Collaboration is not easy even for web programming developer. However, as you see, you can design this kind of advanced collaboration for just 2 steps. 1) Create a new table. 2) Use Member Collaboration Tool. -> Follow 3 steps to create a new collaboration. Done.
• Use Add Collaboration to create more applications, such as: Add New Addresses, Add New Credit Cards, Add New Items...In Social Network Sites use Add Collaboration widely, for example, members Add New Connections, Add New Partners...
• Design your own collaboration tables, select your own fields. But make sure the table must include the Member Collaboration Key = Email used to store emails of the login member. So that the collaboration can distinguish who is the member collaborating.
• The new partner can't login as member of your site yet, after members add more new members. They can login login if they have account in table x_customer. It is up to you to do marketing to sign them on as a real login member.
• Believe It Or Not. This collaboration will grow your membership very quickly. Specially if your company is an organization. Since the contact list is in the database, your staffs can share, collaborate, contact them.
ROI from myNet.Office is paid off for a whole year if you just get one new referral partner from Add New Partner Member Collaboration.