I've got three custom dropdown fields - town, county, and region in a SafeCracker form. The client is asking if it's possible for them to just select one value (in the town dropdown field), and for the other two to pre-populate with the correct county and region. I do have a spreadsheet of town names that has the region and county for each town.
I've searched for add-ons that might do this but haven't managed to find any, so just wondering if there are any recommendations on how to go about doing this in a SafeCracker form? I'm not even sure what fields I'm best using, or whether this needs to be done outside of EE completely? Thanks in advance for any advice on this.