Forums (Obsolete)

Member

sandip.patil-acapteam - 6/8/2009 5:57:20 AM

Create new e-form

Hi
I m creating new corporate website using portal engine.I have some problem in e-forms here is it

Site having members(Role) which logs in and request the material from the Manager(Role).When member fill the form and submit then records should be inserted into the database for future and same time one email with form data should be sent to the manager. Materials like books,pen,cards,papers etc.

This materials will be increase in future so i design tables like below

-------Item Table-----
temId | ItemName | Description

------------Material_Request Table--------------------
UserId | ItemId | Quantity | DateSubmited

How to do this?
Please help me.......

Kentico Developer

kentico_helenag - 6/8/2009 7:57:54 AM

RE:Create new e-form

Hi,

I would recommend you to use a BizForm. Please see here: http://devnet.kentico.com/docs/devguide/bizforms_module_overview.htm for more details.

You could retrieve data for e.g. dropdownlist items from database and it automatically saves filled forms to database to separate table.

Here is the sample code how you could send e-mail to manager just after saving of filled form: http://devnet.kentico.com/docs/devguide/modifying_the_code_of_standard_web_parts.htm

I hope this will be helpful for you.

Best regards,
Helena Grulichova

Member

sandip.patil-acapteam - 6/8/2009 8:45:09 AM

RE:Create new e-form

My form is like this

COURSE INFO
-------------------------------------------------------------
Client / Company: Textbox
Course: Dropdown list of courses
Course Dates: Dropdown list of start date and end date
No. Attending: Dropdown list of numbers from 1 to n

SHIPPING INFORMATION
------------------------------------------------------------
Name, address details labels and textboxes will come here

BILLING INFORMATION
------------------------------------------------------------
Name, address details labels and textboxes will come here

MATERIAL
-----------------------------------------------------------
Books
Pens
Posters
We will provide check box in front of material and dropdown list of numbers 1 to n for quantity at the end
e.g. checkbox Books dropdown list from 1 to n

For My form we have to use below tables schema

Order Table

OrderId(autoincremented) | UserId(foreign key) | Client/Company | Course | CourseStartDate | CourseEndDate | NoOfAttendance | ShippingAddress(foreign key) | BillingAddress(foreign key) | CreateDate

Material Table

MaterialId(autoincremented) | Material Name | Description

Material Request Table

MaterialRequestId(autoincremented) | OrderId(foreign key) | MaterialId(foreign key) | Quantity

Shipping Address Table

All the fields necessary for the address

Billing Address Table

All the fields necessary for the address

How to do this?


Kentico Developer	kentico_helenag - 6/9/2009 9:15:43 AM RE:Create new e-form Hi, Please try the mentioned BizForms you could ensure it with them. You could see them working e.g. on sample Corporate site and you could create your sample one with the help of this tutorial: http://devnet.kentico.com/docs/devguide/creating_a_new_bizform.htm Best regards, Helena Grulichova