matrices and workflow creation

Topic: matrices and workflow creation (Read 1650 times) previous topic - next topic

matrices and workflow creation

April 09, 2020, 08:33:32 AM

hi, how do i create
(i) matrix calculations
eg
rare (1) * negligible (1) = low (with color coding - green)
likely (4) * very severe (5) = high (with color coding - red)

(ii) approval workflows
- Contributor -> Reviewer -> Approved -> Published

Thanks,

Re: matrices and workflow creation

Reply #1 – April 09, 2020, 09:26:16 PM

@ajxster‍ your question is not clear enough.

Re: matrices and workflow creation

Reply #2 – April 10, 2020, 06:13:34 AM

Thanks Willvin.
Please allow me to elaborate.

(i) i have two fields which the user is able to select from 5 options eg.
field1 = likelihood = rare, unlikely, .... etc
field2 = impact = negligible, minor, ... etc
attached a diagrammtic view of the matrix => https://gofile.io/?c=OtymfQ
depending on the selection of the variables by the user,
the field3 (result) should output the result based on the matrix attached
eg. low, med or high
it will also be fabulous if the 3rd field can be color coded according to the result green,amber or red.

(ii) for this workflow item, i'm looking at the form submitted by a user ('contributor'). it should be routed to another user 'approver' to verify the details submitted in the form.
if all ok, he will 'approve' and will be listed and subsequently update the dashboard. if not 'approved' he is able to remark and send it back to the contributor for updates and to resubmit again.

hope this clarifies. please let me know if you require more information
thanks for your advise!

Re: matrices and workflow creation

Reply #3 – April 11, 2020, 12:12:56 PM

@ajxster‍ follow this thread https://phprad.com/forum/index.php?topic=433.msg1276#msg1276 for changing your list page record background base on values from your database.
(ii) you can use the where in List Page Properties to filter records based on some criteria and you will need to configure Roles and Permission to archive what you mentioned above successfully.

Re: matrices and workflow creation

Reply #4 – April 12, 2020, 05:27:48 AM

@willvin much thanks for the feedback.

how am i able to achieve the 'automated' result of field3 from the matrix with the user selection of field 1 and field 2?

thanks for the advise!
#staysafe

Re: matrices and workflow creation

Reply #5 – April 13, 2020, 01:53:37 PM

@ajxster‍ you will need to set the field3 DisplayStyle to Custom and write a PHP code to check your criteria.

Re: matrices and workflow creation

Reply #6 – April 15, 2020, 10:45:21 AM

@willvin Thanks for the advise. I'll have a go at it. Will seek help if I hit a wall.