A web form is populating the fields for the 'Type' of the inquiry and also the 'Geography' of the inquiry in QB.
Can a drop down menu (multiple choice text list) for 'Assigned_To' default to the a specific selection based on the combination of the 'Type' and 'Geography'? For example Type = Manufacturer and Geography = USA so the Assigned_To should default to bob since he owns Manufacturers in the USA.
The 'Assigned_To' should be able to be changed to another selection if needed even if the 'Type' and 'Geography' do not change. For a number of reasons Bob may need to assign this record to a different person in the drop down even though the Geography and Type remain the same.
History - I was able to default the Assigned_To with a formula to a text field based on Type and Geography, but this is basically hardcoded and the text can only change if either the Geography or Type changes which does not provide the needed flexibility.
I'm searching for a solution that will allow an initial default value from the list in the Assigned_To field which can be changed manually if it is incorrect, regardless if the Geography or Type changes.
Thanks for your help.