Sorry I'm a complete beginner to using JSON.
I have two drop down boxes within a SharePoint list and I wish to amend the choices on the second drop down box based on the selection made from the first.
The first box will be "Region" and the choices will be either "North" or "South". The second box is a list of sites across the UK. I would like to do this so that if the user selects North then only Northern sites of my choosing would be a choice on the drop down menu and vice versa.
Is this possible and how do you go about doing this? Thank you.