Apex Code Development You need to sign in to do that
Don't have an account?
N. Weidman Best way to show county coverage (Details within)
I have an ask from the department I support, and I was hoping to get some help brainstorming the solution. I work in healthcare, and one of the things our Network team deals with is called "adequacy." For this, they need to have a certain number of each specialist covering an area to count as "adequet." To report on this, it is generally easy enough to run a report on zip/county for accounts, but that doesn't always capture everything. There are cases where there might be a facility right on the border of two counties, so while it is in County A, it might actually also be the closest facility for patients in County B as well.
What I'm trying to figure out is the best way to be able to track multiple counties for accounts. Some of the possible ideas that I've discounted are:
What I'm trying to figure out is the best way to be able to track multiple counties for accounts. Some of the possible ideas that I've discounted are:
- Free text field. In general, I avoid these, because they're not easy to report on and invites a lot of input error. It is obviously the easiest solution, however.
- Multi-select picklist. This would also be pretty easy and make reporting easy...but for just the state I am located in, there are 84 counties, which means we'd hit the 100 entry maximum very quickly
- Junction object? I haven't used these much at all, but someone else has suggested it...I already have an object that stores all the states/counties in the country, so it's certainly possible, but I'm not sure of the way to integrate.
Greetings!
I don't think we can acheive this by using the standard way and we might need the custom code to implement the same to capture the countries.
So,please feel free to reach out to the accelerator team who can give you the idea on how you can implement according to your business requirement,if you have premier success plan.
Please find the details on how to request for an accelerator:https://help.salesforce.com/articleView?id=000337601&type=1&mode=1
Otherwise,I would request you to reach out to your account Executive If you wish to upgrade to Premier Support please contact your Account Executive.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Warm Regards,
Shirisha Pathuri