Can I change the Relationship selections in a dropdown?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered

I have created a relationship between 2 tables. The relationship is linked to a Provider's Name. However, when in the form, I click the dropdown and it shows "Provider #1 - Address of Provider." I'm wanting it to show the actual Provider's Name (i.e., Dr. John Doe). Is there a way to change what information is displayed in the dropdown?

Photo of David

David

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,612 Points 50k badge 2x thumb
The default fields offered on these type of drop downs are form the record picker fields which are set in the table properties for the table you are choosing records from. So one option is just to change those defau8lr record picker fields.

Another option is to make any report that you like with any filters and sorts that you like and edit the FORM (not field) properties for that drop down field to use the report for its display fields to aid you in choosing a record from the list.
Photo of Carlos

Carlos

  • 836 Points 500 badge 2x thumb
Is there a way to use this beautified report in a grid edit scenario? Works a charm in a form.. but I need it in a grid edit when adding detail records to my Parent record.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,612 Points 50k badge 2x thumb
Carlos, I was away and just catching up with the forum. 

Are you saying that using the record picker fields is not good enough for your purposes in the grid edit format?

If that is your issue, while its a bit of a pain, you can set up a dummy form called something like Grid Edit form and then in forms usage specify that form to be used for Grid Edit. The form will be used to indicate which fields are to be used for Grid Edit and which reports are to be used for the drop downs.