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

  • You should start looking into CSR (Client Side Rendering) of the New and Edit forms of the List. Jul 22, 2016 at 20:46
  • CSR or SPServices
    – Erin L
    Jul 22, 2016 at 20:53

1 Answer 1


Option 1: I am not sure I fully understand the scenario. It almost sounds like you need to build a content type for each department. The content type for each could have a unique choice field with appropriate choices.

Option 2: $().SPServices.SPCascadeDropdowns

Option 3: https://sputility.codeplex.com/

Hide/Show field on list form based on value from another field

If this helps, please accept as answer or vote up.

  • Thank you! Option 1 seems to be the only thing I can think of for doing. Could you explain how I would implement this?
    – Shasta
    Jul 25, 2016 at 17:13
  • You will create a content type for each department and a corresponding column (maybe a site column) for each content type. Associate that column to the appropriate content type. When the user selects that a file is that content type they will be presented to fill out the record type field with the appropriate choices. You will likely need to name each record type field with an added reference to the department, for example RecordTypeIT. Resource support.office.com/en-us/article/… Jul 25, 2016 at 20:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.