Hi and thank you for all the previous answers I found here. I build a prototype for diagnosis and action plan building for Project managers.
I have a Diagnosis Table updated from a form, giving 4 risks scores thanks to 4 virtual columns. A Project Manager can have several projects, so several diagnosis are possible.
I have a 40 rows Action Table (a kind of solution bank). Each action is a row, columns are attributes of the action. I would like to have virtual columns that calculate for each action its potential, reflecting the risks of the project previously calculated (4 risk scores) and the power of the action itself. Then I would be able to sort actions by priority for this project. These actions are displayed in a Card view.
So the user fill the form, read the 4 risks score and go to the Action bank to select Actions I sorted for him (in my dreams at that point)
After lots of failed tests, i feel i need support to find a way to declare the Project name in the Action table, in a way that
1-enable calculations i mentionned above
2-can be easily updated if the user wants to switch from one to another project
3-keep the Card view
Would you have a solution I should explore ? Thank you
LinkedIn
Twitter
