I have several lists which are needed to be updated by users. So, I have created a module with a flat list (contains numbers 1,2,3.....100) and line items with these lists names. Created saved views with one column (i.e. List named line item) and imported this column data in the list. Added a "Run import" action button so that user inputs the list members, run the process and the list gets populated.
To delete, I have one "SYS List Module" which has a "delete?" boolean, it gets triggered if the row number in user input module doesn't match with a list property (a number given to every member, it is given sequentially). Added this delete action button. If the member changes its place in the column, the delete boolean turns true.
To understand the problem, Let's assume a flat list with members 1,2,3,4,5,6
Now the user wants to input a new member between 3 and 4. If he cut 4,5,6 and paste down one cell and then enter 7 like 1,2,3,7,4,5,6 and run import process then "delete" boolean turns true for 7,4,5,6 because their row number doesn't match with the list property. Earlier it was like
Row number Earlier | List Property | List member | Delete Boolean |
1 | 1 | 1 | False |
2 | 2 | 2 | False |
3 | 3 | 3 | False |
4 | 4 | 4 | False |
5 | 5 | 5 | False |
6 | 6 | 6 | False |
After 7 is typed between 3 and 4
Row Number Now | List Property | List member | Delete Boolean |
1 | 1 | 1 | False |
2 | 2 | 2 | False |
3 | 3 | 3 | False |
4 | 7 | 7 | True |
5 | 4 | 4 | True |
6 | 5 | 5 | True |
7 | 6 | 6 | True |
How should I setup my modules and delete boolean so that user can add and delete members wherever he/she wants in the order without turning delete indicator true for any other members.
Thanks!
- Shubham