Linking records in one database, retain multiple choice field

[David_Grover]

Hi Community,

New user here, so apologies if I am not using the right terminology.

I have a table with multiple records.

In one record, one of the fields is a multiple choice list of camera brands. i.e Nikon, Canon, Fuji etc.

In another record, can I somehow ask to show JUST those that have the multiple chose answer - Canon, for example.

I have been playing with record linking, but it seems I then can’t retain the multiple choice option?

Many thanks!

David

[Mehul_Bhandari]

You can choose either one, not both.

Workaround would be to use third party apps like zapier or integromat, having extra column and then using it for multiple option field.

[JonathanBowen]

Hi @David_Grover - I think this is what you are after:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…

i.e. your choice in the first field limits your selection of options in the second field. So, as per @W_Vann_Hall, it is possible with a good bit of table wrangling. This doesn’t come out of the box, unfortunately.

This might not work for you and isn’t a “conditional logic” approach, but an alternative is this:

Create a new table to hold your make/model combinations:

Back in your primary table have a single link field to this table:

When users want to make a selection of make/model, they get the link record pop-up, which also allows them to search:

so, if you do a quick search on “Canon” for example, you pretty quickly get to a smaller set of models to choose from.

This approach also has the side benefit of easily showing you the number of make/model combos that have been chosen, if that stat is important to you.

JB

[David_Grover]

Thanks for the suggestions Guys!

I will try these out. :slightly_smiling_face:

[Allen_Moldovan]

Morning David,

What you are referring to is dynamic variable conditions for linked record fields.

Airtable rolled out “Dynamic Variables” to their automation “Find Records”. It enables you to set a condition as dynamic.

IF this were to be rolled out to the the linked record field type, you could accomplish this.
This functionality would look through values in the destination table and filter the linked record options for only those records which match the conditions.

please be sure to email this to support@airtable.com to push them on this linked record feature