This is my first post and has most likely been covered, So forgive me if this has already been answered. I couldn't find anything specific to my issue.
I have a SharePoint 2013 Server
On-premise site with details for over 150 customers each within their own respective sites within the site collection. I would like the users to have the ability to select from a drop-down menu a set of choices and then have a view that auto populates the results based on their selection. For example, the drop-down menu would consist of Account Type:
Account Type/ Login Name/ URL
Domain wsmith domain.org
Adobe cdavis adobe.com
When they select "Domain" from account type, only the Login Name and URL for Domain will show in the results. Alternatively, when they select "Adobe" from a list of choices, they will see the Login Name and URL for Adobe; in my example cdavis and adobe.com etc.
Additionally, the information that will auto populate is different for all 150 customers. I have exported an
Excel spreadsheet to a SharePoint
list that consists of all the data I am needing for all 150+ customers (If it helps). But I am not sure of how to best approach this problem without having to do this for every individual site within SharePoint. Therefore, my problem is twofold:
How do I create the dropdown menu of choices to auto populate on the site page?
Secondly, how can I achieve the give results without having to edit each individual customer site?
How can I achieve this?