Hi,
I would like to show you how to sort information in a table and auto-tick based on the number of row selections with an automation block.
-
Firstly we need 2 tables. This is due to we are not able to sort in the main table.
1-> Main Table
2-> Duplicate of the Main Table -
Main Table by default no tick & Module ID not in ascending order
-
Do Automation in the Activity Form
NOTE: In the Activity Form should have the Main & Duplicate Table
Automation for Sort
-
Check the Main table have more than 1 row
-
After that you need to sort the Module ID in ascending order.
-
Then, define a variable for each row and create new row for each information found. before that you will need to check if the Main table row and Duplicate table row are equal else it will have an infinite loop.
Let’s see the result at the Client.
Automation to auto-tick based on the number of row selections with an automation block.
-
Row selection 1-10, 11,20 and etc
-
You need to check Duplicate table row is more than 0. If True, then do condition for each selection.
My condition for row 1 till 10 to tick True i select #Form #Row ==‘1-10’
-
Next, you need for loop in range of 10 and a condition to check less or equal 10.
So that if your table only have 9 rows and it will only loop till 9 line
-
Next, you need Action block to find Table No equal with the loop range, then set to True
-
So what if you select to tick True to line 11-20? The steps are below.
-
You would need to do a condition for each selection and the range.
Let’s see the result at the Client.
Row 1-10
Row 11-20
Automation to reset the tick if from 1-10 to 11-20
-
Add Trigger Block and type #From#Row
-
For each the Duplicate Table
-
Next, set the Tick to None and link to the first selection condition
Automation to update the result to the Main Table
-
Do Automation in the Activity, Do After
-
Condition to check if the Duplicate Table row is more than 1
-
Finally you need to Perform Edit the same entry and pass duplicate table data to Main Table
