Sximo NET

Go to : Control Panel -> Code Builder-> Your module -> Click button gear -> Edit  -> Form

Form is the most important feature from CRUD activity . Form only can work on single table , this mean you only can manage operation such insert and update into one table at the same time.

At this moment , system only able to work with , Hiddem Form , Text Form , Date Form , Date Time , Select , Checkbox , Radio

Hidden

type is used for Primary Key with autoincreament

The important thing from the form is your table Must have field type auto increament. this will be KEY for insert or update row table.

Now for auto increament field , you must make type form HIDDEN , NO REQUIRED and SHOW.

Text Text type is used for collecting text or number from users

Date Date type is used for collecting date input , the input will have popup datepicker to make sure user input right type of date . Your field table must be set as date field ( Y-m-d ) Date Time Datetime type is used for collecting date+time input , the input will have popup datepickertime to make sure user input right type of date . Your field table must be set as date field ( Y-m-d H:i:s )

Textarea Text type is used for collecting long text or number from users Textarea with Editor Text type is used for collecting long text or number from users with editor Select Select used for value with option as your own defined , the format value as below Key_value : display_value

Select Lookup Select used for value with option from database , the format value as below Database Table Primary_key Display_name1 ( required ) Display_name2 ( optional ) Display_name3 (optional)

Select Nested Lookup ( Cascade ) Example you have 3 database tables Customer , country and city Step 1 , create module as usualy for customer using code builder Step 2 , edit form, make county_id as select lookup to table country Step 3 , edit form, make city_id as select lookup to table city Screnario everytime you select country , all city list should change following selected country_id Now go to editor form tab and edit field city_id , check parent filter checkbox and fill the input form with country_id Last Step rebuild the form and you will see , everytime country selected , all city list will changed

Checkbox Checkbox used for value with option as your own defined , the format value as below Key_value : display_value Key_value2 : display_value2

Upload ( File / Images ) Upload type is used for collecting image or file from users . All files and images stored at spesific folder So make sure you create directory at uploads/your_directory_name

Files : Used for download 

Images : Used for display as image