Tables in Doctype

Add and Configure Child Tables / Data Tables in Officexlr Doctype

Table Enables to capture data in Tabular Form, Tables works as sub-forms in Doctype form view, by configuring fields in the table you can add columns in Table and User can add multiple rows in each data table, Use Configure Table Columns button in Field Editor of the Table to Manage Table fields,

Examples of table usages -

  1. Item, Rate, Qty, Amount in Invoice, Purchase Order

  2. Earning Category, Amount in Salary Slip

  3. Ledger Account, Tax-rate and Tax amount in Tax Table.

Add Table in Doctype:

  • In Doctype Editor, Drag and Drop "Table" Field from left side panel to editable area

Add table in Doctype

‚Äč

  • Open Field Editor for Table field (Click on "Edit" icon, beside Table field ,"Edit" icon will appear on mouse-over to the field in Doctype Editor)

Edit table properties
  • Click on "Configure Table Columns", to Add or Configure Columns (Fields) in Data Table.

Configure Table Columns
  • On clicking "Configure Table Columns" Button, you will be landed to new form editor window similar to Doctype editor, here you can drag and drop fields to configure your table columns.

Note: Check "In list view" option in field editor for field which you want to display in the table columns.

  • Table Editor will autosave your changes, to go back to Doctype editor - Click on "Close" button in Table editor.

Close Table Editor