First of all I would like to say thank you for everyone contributing to the Airtable Community, I have been saved hundreds of time by the ideas and solutions posted here. Now, I would like to pose a problem I’ve been dealing with:
I’m creating a data base to keep record of project ideas pitched by a team.
I want to be able to prioritize ideas from people who have already suggested something before AND had their idea chosen for further development.
I managed to indicate all people that already submitted an idea thanks to this: Can I find unique values and put them in a column?
Now I would like to have a field indicating if that person has had an idea picked for developement before, but I’m stuck and can’t find a solution.
I have an array with all the people who have submitted an idea before, now I need to know the status of these ideas.
I believe the way to do this is create an array for each recurrent user with all values from the idea status column so I could verify if any status is ‘in development’.