Is their any way a list automatically change its hierarchy or parent (Active to Inactive) if it meets a certain criteria?
I agree with @einas.ibrahim , the design should be like what he mentioned above.
Workaround for your problem;
1. Create few line items in your module:
2. Create an import action to update the parent of inactive employee:
Hope this helps!
I don't think so list automatically changed its hierarchy or parent based on a certain condition. You can use conditional formatting to highlight that item once your condition meet.
As of now, you will have to run an action to achieve this functionality based on your logic. Change of List parent or hierarchy is a structural change.
Hi @sharmagh ,There is a case where you can change the content of a list (List 2) based on the selection in another list (List 1).Say I have List 1 containing Countries and List 2 containing Cities. If the user selects U.S. in List 1, then only U.S. cities will appear in List 2, similarly, if the user selects Canada, only Canadian cities will be available in List 2.Does this sound like what you are trying to accomplish?If not, please provide more information and perhaps a simplified example.-Einas
May I ask why do you have 2 separate lists for employees (Active and Inactive)?If I understand your case correctly then you may
Let me know if that works, or if you have any questions.-Einas
Based on boolean, you can set a line item to change the parent of the item, and then run an action to import updated parents
Yes, you have to create one view based on inactive? filter.
Yes, based on the termination date entered , can be checked whether employee has to be active/inactive and view for import can be set
I have attached the blueprint for your reference:
hope this helps!
Hi,The active status of an employee is not a structure feature and therefore should not dictate the structure of the hierarchy.Instead, the active status is a property or attribute of the list item.Therefore, create a mapping in a properties module dimensioned by the employee list. Create a line item dimensioned as the active/inactive list. Alternatively, use a boolean format. And a date or time period formatted line item if you need to differentiate across time.You can use filtering and aggregation functions in downstream formulas to differentiate data across these attributes.This is a simpler approach, does not require an action and will keep sparsity to a minimum.Good luck,Chris
Using the list on a dashboard would not necessitate using two lists!!!
You can filter the view using dynamic filtering fed by the boolean in the property module.
The model is at risk of not be sustainable or auditable as the approach you are seeking to implement requires too many intermediate steps.
But I see you have selected a solution so good luck.