Base Request: How to create table custom field in

Đã sửa đổi vào: Mon, 31 Tháng 3, 2025 lúc 5:26 CH

To add a table custom field to the request form, you visit https://request.base.vn >> Settings page >> All request groups >> Select the request group which you want to add the custom field.
Next, in the Request Form tab, you can choose one of two ways: create directly or create using Excel.

Method 1: Create directly on the system

Step 1: Select the Add button
Step 2: Select "Input Type" as Table and set up the table information:

a. Column name:  Name the column

b. Import:  Supports custom fields in each column:

• Integer, decimal
• Short text
• Date, date and time
• One choice, many choices

Options separated by commas 

• Formula: Supports addition, subtraction, multiplication, division and excel functions

- Enter $ to display variables, variables are cells of integer, decimal, and selection types created above

- Example formula:c. Enter the Width field 

Width is calculated as a ratio between cells. 

For example, a cell with a width of 2 will be twice as wide as a cell with a width of 1.

d. Enable Required values for each column

e. Total:

Sum only columns of type Integer, Decimal, Formula.

When entering data, a final row will be displayed showing the Total value of that column.

Method 2: Import table custom fields from Excel:
Step 1: Download the sample Excel file by clicking on View template here:

Step 2: Enter data into the Excel file

- Sheet  1 : Create input-table field and other custom fields:

   Name : Name of the custom field

   Type : Type of the field (  int, float, text, select, m-select, input-formula)

   Content : description of the field

   R equired : 0 (optional, 1 (required)

   Input key : Code of the custom field

- Sheet 2 : Add a separate sheet for each table (the name of the sheet must be the input_key of that table) 

Step 3: After entering the data, you will upload this file to the system by dragging and dropping the Excel file into the Request Form section. 

Câu trả lời này có giúp ích cho bạn không? Yes No