Help

Re: Editable Lookups

Solved
Jump to Solution
1242 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mshah72
6 - Interface Innovator
6 - Interface Innovator

I have a base with 2 tables - Teams and Projects (as shown below).

mshah72_1-1681747772075.png

 

mshah72_0-1681747745434.png

Every 3 months the leader changes. Now if I update the leader name in Teams table, it updates the leader names in the previous records too in the Project table (because of Lookup). How can I prevent updating the lookup values in the previous records?

Please try to provide a detail solution.

1 Solution

Accepted Solutions
RdMedia_srl
7 - App Architect
7 - App Architect

you could have this structure

 

this is the PROJECTS table (here are shown all the field but you can hide the lookup field "Name (from Teams) and "Current Team Leader (from Teams)". 

Schermata 2023-04-17 alle 23.50.48.png

this is the TEAM table where you have the "Current Team Leader" field for your Team that you can change (linked record to last table "Team Leader Proj")

Schermata 2023-04-17 alle 23.55.03.png

and this is the last table "Team Leader Proj"

Schermata 2023-04-17 alle 23.56.00.png

then the you have this automation that as soon as you assign a TEAM to your PROJECTS table update the record of the project with the "current leader" of the that TEAM

Schermata 2023-04-18 alle 00.00.38.png

these are the conditions:

Schermata 2023-04-18 alle 00.00.44.png

and here you update the "Team Leader Projects" linked field record of the PROJECTS table with the value of the "Current Team Leader (from Teams)"

Schermata 2023-04-18 alle 00.00.51.png

hope this helps....

 


Rodolfo - RdMedia

See Solution in Thread

5 Replies 5
FlywheelConsult
6 - Interface Innovator
6 - Interface Innovator

What do you mean by previous records? Are you trying to keep a running log of who has been in charge of a project? As it stands, your project table is always showing the current team leader which makes sense to me. 

If you mean that some of those projects are old projects and you want to know who the team lead was at the time, then make a separate team lead table and link it to project, don't do a lookup off of the team table. You can also link the team lead table to the teams table so you always have a record of the current team lead. This way you can update the team and the project lead separately and it won't affect the other. 

@FlywheelConsult Yes, you have understood it right - some are old projects. But for the task assigner, it is difficult to remember the Team Leader's name, but it is easy to remember the team name. So is there any alternate solution?

FlywheelConsult
6 - Interface Innovator
6 - Interface Innovator

The key is to make the team leaders table. If you're creating a new project, when you assign a team to the project, you can have an automation automatically link the current team leader to the project. In your projects table have a lookup field that shows the current team leader of the linked team then the automation can take that value and apply it to another field that links to the team leader table. This way a person assigning the team doesn't have to remember the current team leader.

mshah72
6 - Interface Innovator
6 - Interface Innovator

@FlywheelConsult, can you help with what logic I can set for the automation to do this? So what my thought is, I have a table with all the team members in it. I will mark the leaders with some tag and then link a particular view to my Teams page. How and what can I automate to auto-populate in the project table?

RdMedia_srl
7 - App Architect
7 - App Architect

you could have this structure

 

this is the PROJECTS table (here are shown all the field but you can hide the lookup field "Name (from Teams) and "Current Team Leader (from Teams)". 

Schermata 2023-04-17 alle 23.50.48.png

this is the TEAM table where you have the "Current Team Leader" field for your Team that you can change (linked record to last table "Team Leader Proj")

Schermata 2023-04-17 alle 23.55.03.png

and this is the last table "Team Leader Proj"

Schermata 2023-04-17 alle 23.56.00.png

then the you have this automation that as soon as you assign a TEAM to your PROJECTS table update the record of the project with the "current leader" of the that TEAM

Schermata 2023-04-18 alle 00.00.38.png

these are the conditions:

Schermata 2023-04-18 alle 00.00.44.png

and here you update the "Team Leader Projects" linked field record of the PROJECTS table with the value of the "Current Team Leader (from Teams)"

Schermata 2023-04-18 alle 00.00.51.png

hope this helps....

 


Rodolfo - RdMedia