Block - Retrieve group of records in table

[Tivisah]

Hi,

Example: When select Department A, show the list of staff in the department.

1. Go to the Default form

2. Open and Scroll all the way and Click Add Automation

3. Drag & Drop Condition block
   

   

4. Type condition #Form#Department is not None and #Form#Details.Count ==0

   • This indicates that when select Department and if my table is still empty then execute the following automation.

5. Drag & Drop Action block

6. Click + Add Action

7. Select Find All
   

   

8. Select Module: FETIAS User

9. Filter
   Click + new condition
   Click on ID and Select Formula
   Click on ID again and select Department.
   Type formula: #Form#Department

10. Drag & Drop For block
    

11. Input #FETIAS User List Found

12. Input item under each

13. Drag & Drop Action block

14. Click + Add Action
    

15. Select Create

16. Input Value : addRow(#Form#Details)
    

    

17. Click Ok

18. Click + Add Action

19. Select Set

20. Input Variable : Variable 1

21. Value : Entry → #item
    Date → #Today
    CurrentUser → #Current User
    

    

22. Click OK

23. Click Save

Result