Auto select a conditional(filtered) dropdown based on selection of another dropdown

Question

A user has to select the company to do business with from a dropdown (related Hauler table).
The Contact table is related to the Hauler table. The Contact table has multiple contact information i.e. such as Billing, Dispatch, Admin & so on.
In this application, how can the Contact be auto-selected for the Dispatch contact information whenever the Hauler is changed.
The Hauler can change depending on the agreement.
First attempt was to use JQuery to locate the Dispatch RID (using the already user selected Hauler information) then API_EditRecord to update Related_Contact field but an errcode = 2 (invalid input) & errdetail of "Sorry you can't provide both the rid & key...".

donlarson · Answer

Gabe,It is a two part solution.&nbsp; &nbsp;Build a conditional against the Related Contact so that only Contacts for the Company can be selected.The second part is to build a Record Picker report where you filter Contacts to show Related Contract Type =&nbsp; XX where XX is the value for the Dispatch.&nbsp; Then specify on the form that "Record Picker Dispatch"&nbsp; or whatever you call it is to be used.Here is a screen shot of setting the report in a form.zYou might think about expanding the logic in Record Picker for example&nbsp; Contact Status = Active.&nbsp; This way as Contacts come and go from the Company, your report is dynamically correct.------------------------------Don LarsonPaasporterWestlake OH------------------------------

gabrielfigueroa · Answer

Thanks for responding Don!I believe I've already done all that you mentioned, beforehand. The only contacts showing are only relevant to the company that was previously selected. Currently, the user would still have to manually select (sometimes (1) &amp; other times (1) of several).What I want to do is pre-select (or automate) the selection for them, always choose the 1st one.I would like, once the company is selected, to have QuickBase thru either JQuery or Automations or other auto-select the value to save the User time. If there are more than (1) then they would have to choose another one other than the 1st Dispatch contact record.------------------------------Gabe Figueroa------------------------------

markshnier__you · Answer

Gabe,&nbsp;I believe that you were saying that if the particular company only has one contact that you want that to be preselected.&nbsp;&nbsp;On the relationship where one company has many contacts, do a summary field of the number of contacts. &nbsp;Also do a summary of the minimum record ID of all of the contacts.&nbsp;Make a formula on companies called [record ID of contact if only one contact].&nbsp;Now the company record knows the record ID of the singleton contact if there is one.&nbsp;Look up that value down to your jobs record. &nbsp;Set up a Forum rule on the form where you are choosing a contact to say&nbsp;&nbsp;If the &nbsp;Record ID of contact if only one contact is greater than zeroaction&nbsp;Change related contact to the value in the field record ID of contact if only one contact.&nbsp;Make sure the field record ID of contact if only one contact is on the form even if it is hidden by a foreign rule. Form rules tend not to work if the values on which they depend or not on the form.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Auto select a conditional(filtered) dropdown based on selection of another dropdown