Block - Set Table Rows with Multiple Columns

[viti]

This sample shows how to add rows with some value for multiple columns when creating an entry.

Default form

1. In form design
2. Enable automation
3. Drag & drop Action block
4. Add Action
5. Select Create
6. Set Variable set such as [[“Row 1”, “1”], [“Row 2”, “2”], [“Row 3”, “3”]]

7. Click OK

8. Drag & Drop Condition block
9. Write #Form#Table.Count <= 0

#Table is the table name in this form. I have to set the variable in this table rows when the table is empty (Count <=0 or Count == 0)

10. Drag & Drop For block
11. Select #list and each type ‘x’ (any name to define each of the items from the variable)

12. Drag & drop action block
13. Click add action
14. Select ‘Create’
15. Add Value: #addRow(#Form#Table)
16. Click OK

17. Click add action
18. Select ‘Set’
19. Variable, choose #AddTable
20. Expand Property
21. Add value #Text and Set #x[0].ToString()
    x[0] is to set the first value (Row 1) in Text column
22. Continue add other value, #Number and Set #x[1].ToString()
23. Click OK

Here is the full view of the automation

Result in Client

Note:
No column is set Formula to set the auto row number.

Formula script - How to auto-increment the table number

Hi friends , If you want to auto-increment the number of the table. You may use ‘rowNumber()’ in the formula script. [image] Result: [Template Testing]