Dropdown list with Ratings?
I have a user request to track software skills for team members. They want a list of items, for example software packages, in a drop-down list. But - they also want a rating for each skill, from 1-...
Forum Discussion
OK, so in that case is this right -
the M:M could look like:
Employee ID Software Rating Formula
-----------------------------------------------------------------------
25 Xero 5 Xero-5
25 QB 3 QB-3
32 QB 4 QB-4
And I could then pull Formula up into the employee table for reporting, using a text summary field.
To do the data entry, I could have an editable report on a tab in Team Member, which would allow me to create the necessary number of records for each person, picking from single-choice dropdown lists for Software and Rating.
- MarkShnier__You
Qrew Legend
Yes you were on the right track. A couple of tips.
Once you roll up the combine text summary field you can make it much more attractive for reporting on a report by doing this in a formula text field.
SearchandReplace([My Combined text summary field]), " ; ", "\n")
That will make a nice clean vertical field.
Also Grid Edit on New Form to add records does not work (ie to add children to the Team member record) . LMK if you need a work around to that.
