Crow Canyon Software Forum
Create a view from two lists
Quote from Michelle on March 16, 2022, 10:18 amHi,
We have a employee form list and an all employee/supervisor list. Is there a way to create a combined view from these two lists? Especially, we are looking to get all the "Not Started" forms, which mean there is no entry in the employee form list, but there is an entry in the all employee/supervisor list.
Thanks,
Michelle
Hi,
We have a employee form list and an all employee/supervisor list. Is there a way to create a combined view from these two lists? Especially, we are looking to get all the "Not Started" forms, which mean there is no entry in the employee form list, but there is an entry in the all employee/supervisor list.
Thanks,
Michelle
Quote from Scott Restivo on March 16, 2022, 2:02 pmHi Michelle, have you tried using our List Rollup tool? It is part of NITRO Studio.
Hi Michelle, have you tried using our List Rollup tool? It is part of NITRO Studio.
Quote from nmortello@njha.com on March 16, 2022, 3:19 pmHi Scott -
I looked at the roll up.
In SQL terms the roll up appears to do a Union. We are looking to do a join so that we can then apply a condition to say if status equals nothing display in list.
Is there any nitro studio that does that?
Hi Scott -
I looked at the roll up.
In SQL terms the roll up appears to do a Union. We are looking to do a join so that we can then apply a condition to say if status equals nothing display in list.
Is there any nitro studio that does that?
Quote from Scott Restivo on March 16, 2022, 3:55 pmYou are right, the List Rollup does a union, not a join. I am talking with our dev team about possible solutions for your situation.
You are right, the List Rollup does a union, not a join. I am talking with our dev team about possible solutions for your situation.
Quote from supportTeam on March 17, 2022, 4:03 pmHi Michelle,
We are assuming that ‘employee form’ list (child list) has a lookup to ‘all employee/supervisor’ list (parent list).
In that case, we can create a ‘Yes/No’ column with default value set to ‘No’, in parent list, to indicate whether there is or not an entry in ‘employee form’ list.
Configure a workflow on ‘employee form’ list, on item creation event. Add an update item action to run for ‘Lookup’ and update the ‘Yes/No’ column to ‘Yes’. That is, set value to ‘Yes’ for ‘all employee/supervisor’ list item, when an item is created in ‘employee form’ list for selected employee/supervisor.
Create a SharePoint list view in ‘all employee/supervisor’ list based on the ‘Yes/No’ column.
Hi Michelle,
We are assuming that ‘employee form’ list (child list) has a lookup to ‘all employee/supervisor’ list (parent list).
In that case, we can create a ‘Yes/No’ column with default value set to ‘No’, in parent list, to indicate whether there is or not an entry in ‘employee form’ list.
Configure a workflow on ‘employee form’ list, on item creation event. Add an update item action to run for ‘Lookup’ and update the ‘Yes/No’ column to ‘Yes’. That is, set value to ‘Yes’ for ‘all employee/supervisor’ list item, when an item is created in ‘employee form’ list for selected employee/supervisor.
Create a SharePoint list view in ‘all employee/supervisor’ list based on the ‘Yes/No’ column.
Quote from ACR-SCOUT on July 15, 2022, 4:09 pmIf you did an associated item column in the supervisor list, would it be "null" if there were no employees assigned to it? The idea is to us the associated item column as the discriminator.
If you did an associated item column in the supervisor list, would it be "null" if there were no employees assigned to it? The idea is to us the associated item column as the discriminator.