Hello all,
I have an Excel with many Scoring tables and I would like to have the same system on Salesforce too. Please see the attached screenshot for the reference.
How can I achieve this ?
Table A
Cat = 1
Dog = 2
Mouse =3
Total = Cat + Dog + Mouse
I know I can use fields (number) for the simplicity but I have 100 of tables so I dont want to end up creating 100s of fields.
How can I use flow variable to store these values and then use these values in a very complex formula fields for the reference too.
Note : I have hundred of such tables. How to achieve this optimally.
Any leads is appreciated.
Thanks a lot.
If its recommendations for end customers then I'd say stay away from complex flows or complex formula.
Id perhaps try and store the hundreds of tables as data, instead of metadata.
First, Create a Parent & Child objects to represent 'Questionaire' and child 'Questionaire Questions' that will allow users to come up with the tables and their questions in the first instance. The questionaire object would have a field for 'Role Name' I guess looking at the names of the tables in the screenshot, and the child 'Questionaire Question' object would have fields for 'Question Text' and 'Score'
Secondly, create another parent and child objects ( Master Detail ) who's records would represent an actual completion of a questionaire - call perhaps 'Survey' and 'Survey Answer'. Have a lookup to Questionaire from the Survey, have a lookup to Questionaire Question from Survey Answer. Have an Actual Score on Survey Answer and then could roll up the score of all answers to the Survey record.
Use flow from a button to generate new Survey Records, using Questionaire data as the source to create them from
This is 4 objects with a few fields instead of hundreds of fields or hundreds of objects
