Filters for Relationship Field Items
Created 1 year ago by jcastillotx

I have a sponsorship field that is a relationship (sponsors). If I put in the sponsorship_sponsors into the filter I get a dropdown of emails for that filter. I would like to be able to search by last name instead of a dropdown of the emails. How can I do that?

lachie_h  —  1 year ago

Seems like a good improvement to the relationship field would be to add the ability to select the column that displays in the UI. I've used it before and the dropdown displayed the ID which wasn't really helpful.

ryanthompson  —  1 year ago

I had this in mind too - definitely doable just and pretty easy too!

In the meanwhile you can easily do this with a generic text filter too. The filters query handler will just join / search with LIKE or something.

ryanthompson  —  1 year ago

@jcastillotx please try and use more descriptive titles from now on too 😊

jcastillotx  —  1 year ago

Sorry suffering from China CRUD as I sit consuming air pollution in Beijing.

ryanthompson  —  1 year ago

@jcastillotx yikes! I feel for ya man - no worries 😊