Introduction 6 Table Introduction How it works Twig for Template Designers Custom Tables for WordPress
Step by step 10 Overview Step 1: Creating a new Table Step 2: Adding fields to our table Step 3: Creating Submit Form Layout Step 4: Creating Catalog Layout
Field Types 40 Alias (For SEO Links) Article Author User Blob (Save file into the database) Change Log
Layout Tags 101 HTML {{ html.add }} – Add New{{ html.goback }} – Go Back Button{{ html.recordcount }} – Record Count text{{ html.checkboxcount }} – Record Selected count{{ html.print }} – Print Button{{ html.navigation }} – Navigation{{ html.batch }} – Batch Toolbar{{ html.searchbutton }} – Search Button{{ html.searchreset }} – Search Reset Button{{ html.pagination }} – Pagination Bar{{ html.button }} – Button{{ html.captcha }} – Captcha{{ html.message }} – Alert Message{{ html.recordlist }} – List of Records{{ html.importcsv }} – Import CSV{{ html.tablehead }} – HTML Table Head{{ html.toolbar }} – Toolbar{{ html.search }} – Search Box{{ html.limit }} – A select box to change the number of records per page{{ html.orderby }} – Order By (Sort By) Dropdown Record {{ record.id }} – record ID{{ record.number }} – Record Number{{ record.published }} – Published{{ record.link }} – Link to detailed page{{ record.count }} – Count{{ record.avg }} – Average{{ record.min }} – Minimum{{ record.max }} – Maximum{{ record.sum }} – Sum{{ record.joincount }} – Table Join – Count{{ record.joinavg }} – Table Join – Average{{ record.joinmin }} – Table Join – Minimum{{ record.joinmax }} – Table Join – Maximum{{ record.joinsum }} – Table Join – Sum{{ record.joinvalue }} – Table Join – Value{{ record.jointable }} – Join Table – Table{{ record.advancedjoin }} – Table Join{{ record.missingfields }} – Returns a List of required fields that are missing.{{ record.missingfieldslist }} – Returns an Array of required fields that are missing.{{ record.islast }} – Check if Record is Last in List Table {{ table.records }} – Record Count (filtered){{ table.recordstotal }} – Total Number of Records{{ table.recordpagestart }} – Page Start Record number{{ table.recordsperpage }} – Number of records per page{{ table.title }} – Table Title{{ table.description }} – Description{{ table.name }} – Table Name{{ table.id }} – Table ID{{ table.fields }} – Fields Tables {{ tables.getrecords }} – Get Records{{ tables.sqlselect }} – SQL SELECT Query{{ tables.getvalue }} – Get Value{{ tables.getrecord }} – Get Record Fields {{ fields.count }} – Field Count (number){{ fields.list }} – List of field parameters{{ fields.json }} – Field Json Array User {{ user.id }} – Current User ID{{ user.name }} – User Full Name{{ user.username }} – Username{{ user.email }} – Email{{ user.lastvisitdate }} – Last Visit Date{{ user.registerdate }} – Register Date{{ user.usergroups }} – User Groups{{ user.customfield }} – Custom Field URL {{ url.link }} – Link{{ url.format }} – Output Format{{ url.itemid }} – Menu Itemid{{ url.getint }} – Integer{{ url.getstring }} – String{{ url.getuint }} – Unsigned Integer{{ url.getfloat }} – Float/Decimal{{ url.getword }} – Word{{ url.getalnum }} – Alphanumeric{{ url.getcmd }} – Command{{ url.getstringandencode }} – Base64 Encode{{ url.getstringanddecode }} – Base64 Decode{{ url.base64 }} – Base64 Encode URL{{ url.root }} – Website Root URI{{ url.set }} – Set query parameter{{ url.server }} – Server Document {{ document.setpagetitle }} – Set Page Title{{ document.setheadtag }} – HTML Document Head Tag{{ document.jslibrary }} – Add JavaScript Library{{ document.setmetakeywords }} – Set Meta Keywords{{ document.setmetadescription }} – Set Meta Description{{ document.languagepostfix }} – Language Postfix{{ document.attachment }} – Email file attachment{{ document.sitename }} – Site Name{{ document.set }} – Set Variable Value{{ document.get }} – Get Variable Value{{ document.config }} – Get Custom Tables Configuration Parameter{{ document.cookie }} – Get Cookie Value{{ document.script }} – Add JavaScript Script{{ document.style }} – Add CSS styles{{ document.layout }} – Extend Layout Twig Filters {{ | json_decode }} – JSON Decode{{ | json_encode }} – JSON Encode{{ | ucwords }} – Uppercase Words{{ | md5 }} – MD5 Hash{{ | base64decode }} – Base64 Decode{{ | base64encode }} – Base64 Encode
Menu Items, Modules and Plugins 5 Web Services – Custom Tables Plugins: Custom Tables Module: Custom Tables – Add Record Module: Custom Tables – Catalog Menu Item
Advanced Examples 9 Setting up a Read-Only MySQL User Loading Screen Records created by a user Table Join (Lookup Table) Include Layout
