How to input data from another table to calculate virtual columns and display on a card view

[david0808]

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

[Aurelien]

Hi @david0808 

Your project seems interesting 😁

Did you think about using Deref expressions, so that for each action picked you can see attributes ? Something like:

[action].[Attribute1]

[action].[Attribute2]

and so on

You may also want to use ORDERBY and FILTER expression together for your point 2.

For reference:

Dereference expressions 

FILTER() 

ORDERBY() 

[david0808]

Thank you Aurelien,

I finally found half a solution thanks to INPUT() and then dereferences you suggested.

INPUT() makes the choice of the name project possible within Card view so that's ok, I created a behavior that applies to one row, allowing user to input his project and launch priority calculation.

The remaining pb is that the project choice applies only on one card, but there are 40 cards (!), so the user should click on each card action to calculate the priority. Moreover i'm still not able to sort the actions according to the priority calculation.

I'm trying to add an action "execute an action on a set of rows", but unsuccessfully yet. That action type remains obscure to me.

Thanks for any advise you would add to this conversation 😉