This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi! Thanks for giving us such an in-depth explanation of why and how you would want to use filtering on linked record fieldsโitโs really helpful for us, and what youโre saying makes a lot of sense.
In addition to filtering the foreign keys in a linked record field, weโve also had requests to auto-sort the foreign keys in a linked record field. As you hinted, one way to deal with both filtering and sorting on linked record fields might be for there to be โviewsโ that apply within the contents of a single field. In any case, if this is the approach we decide to take to solve the problem, we need to make sure that we design the new feature in such a way that it doesnโt needlessly complicate the user experience. Apologies for the long response time!
What I have found myself doing (although this is still very cumbersome) is creating a new table that just has Lookup fields of the table I need to see records of sorted in the way that I need them to look and have those Lookup fields point to the table I need to see data from. Keep in mind that this only works as a form of a Report rather than modifiable data fields.
You can setup multiple Views of the Related Table formatted the way that you need and then change the View of the Related Table, go back to the Source Table and it will inherit the last used View of the Related Table. Again very cumbersome however it works in a pinch.
hi everyone.
is there a way to link to a filtered list of records?
Here is a scenario :I am shooting a commercial.
I have thousands of candidates that I have auditioned. Only a few have been selected in the candidates table (check box)
now in my scene table, i would like to link a field to the candidates table. but I only want to be prompted with selected candidates and not the thousands i have auditionedโฆ
is there a way to do that ?
i hope itโs clear. ๐
thks in advance
T
Right now you canโt link to views or subtypes (selected candidates).
You could create a second table for your selected candidates, filter + copy & paste those people (thatโs only 1 action) and create a link to the new table.
Not ideal, but maybe not problematic too in this caseโฆ :slightly_smiling_face:
You want someone to select the state, and then the city, in separate fields. Right now, selecting the state first means you would still see every city, not just the cities in the state, in the dropdown menu.
