Hello, to all wizards and rookies!
I'm perhaps searching with the wrong terminology, but I've struggled for three days now and my project is due at end of day, today. (Because, of course it is)
I have a custom SharePoint list form. All fields are text fields (except 2, but they're not relevant to this question)
This form saves to a list we'll call "Nominees".
One of the data cards/columns in the 'Nominees' list called "Award Category" is a radio button input (I've removed the original text box - the underlying data type is single-line text) that merely shows the items from the 'Title' column of another list we'll call "AwardCategories". In the "AwardCategories" list is a second column , also just text, called "CategoryDescription".
Currently, any radio button choice successfully updates the single-line text in the 'Nominees' home list with the Title information from the 'AwardCategories' list.
What I'm trying to do:
When the user chooses an Award Category, I've put a custom datacard on the form with a multi-line text box where I'd like to display the associated Category Description. So for example, the user chooses "Category Awesome", the text box will display the CategoryDescription from the same row (all from the outside list, 'AwardCategories').
Example Columns from AwardCategories:
TITLE:
Category Awesome
Category Amazing
CATEGORYDESCRIPTION:
Category Awesome is for the people who are just awesome
Category Amazing are for the people who redefine 'amazing'.
What in the world do I put for the default on the text box label?? I was using Distinct and Filter, as I've used that before, but that seems to only work with drop-down selections - these are both text, simply reading from an outside list to the one the form resides on. The description box does NOT need to update anything in the form; it's a convenience for the end user to see the category description, as they are rather long and tough to memorize and I don't want to make them have to exit the form to check if they're choosing the right category.
Does this make sense?
I've attached the 'Items' property of my Radio Buttons, and also the existing unfinished (and incorrect) text label formula I was starting on. If there's anything else I need to attach, please let me know.
Thanking you all in advance, and will buy coffee!
~ Tracy
