Managing data in custom tables

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

The administration interface for management of data items stored in custom tables is located in CMS Desk -> Tools -> Custom tables.




In the following example, you will learn how to add data into the sample People custom table we have created in the Creating custom tables chapter. The procedure is the same for any other custom table (except for the fields, which are always specific for a particular table):


1. Click the Edit (Edit) icon next to the People table. A blank page with a header as in the following screenshot will be displayed. The page is blank because there is no data in the custom table yet.




2. Click the NewRecord New item link. The form that you can see in the following screenshot will be displayed. Enter some testing data and click OK.




3. The data you entered has been saved into the custom table. Now you can either edit it or use the NewRecord Create another link to create another data record. Try creating at least two other records.


4. When you're finished, switch back to the Custom tables listing in CMS Desk -> Tools and choose to Edit (Edit) the People custom table. You should see a list of entries where the blank page was in step 1, before entering the records.


The data records can be Edited (Edit) or Deleted (Delete). You can also re-order records in the listing using the Up (Up) and Down (Down). The order is be stored in the ItemOrder property of each data record.




5. You can choose which fields should be displayed in the listing by clicking the SelectFields Select displayed fields link. The window depicted in the following screenshot will be displayed. Using the check-boxes, you can determine which fields are to be displayed in the listing. When you make the selection and click OK, you should see the result immediately.




6. If you click the View (View) icon next to any of the data records, detailed information about the record will be displayed in a pop-up window. All details will be displayed, no matter which fields are selected to be displayed in the listing.




Page url: