Page History

1. Start Joget Server and open the App Center.
   
   
2. Log in as admin and click on the pencil icon on the Expenses Claim to open the Design App. (see Figure 1)
   
   
3. Click on "Create new form" and fill up the Form Details as follows:
   1. Form ID: advGrdTest
   2. Form Name: Advanced Grid Test
   3. Table Name: test
4. Click on the Save button and you will be directed to the Form Builder.
   
   
5. Drag and drop the Advanced Grid element on to the canvas.
   
   
6. Hover the mouse over the Advanced Grid element on the canvas and click on Edit to open up the Edit Advanced Grid properties (see Figure 2)
   
   
7. Fill up

1. the Edit Advanced Grid properties as follows and click on OK (see Figure 3):
   1. ID : entries
   2. Form: Expense Claim Entry

   3. Columns : 

      Field ID*	Label	Format Type
      date	Date	Date
      category	Category
      purpose	Purpose
      amount	Amount	Decimal

2. Click on Preview to open up the Preview tab and try clicking on each column in the Advanced Grid. (see Figure 4)
   
   
3. When we configured the Advanced Grid (as shown in step 7), what we did was selecting a target form called Expense Claim Entry and mimic the fields we listed in the step 7c from said target form. (see Figure 5)
   
   

Min Number of Row Validation (Integer)

Max Number of Row Validation (Integer)

Max Number of Row Validation (Integer)

Error Message