I am creating a record center and am having issues trying to have one column (column1) get information from end user and that their answer (choice-dropdown) will determine next set of options that they will see in column 2 (choice-dropdown).
For example: Column1 - title: "department" Choice Column Has Options of: IT, Legal, Risk Management, etc.
Column2 - title: "record type" Choice Column Has Options of: contract, infrastructure, Audio Files, etc.
If user is entering in a file, they are asked questions for the metadata. Ideally, I would want them to select from a choice of departments first, and depending on their selection can break down the record type. Now, please note, the record types will be different options for each department.
I was thinking that if I was somehow able to list validate what their selection is and then feed from possibly a list that has each record types saved.
Any thoughts? Trying to wrap my head around this for last week!!
Thanks in advance! -Shasta