Script - multiple select update error

[Artur_Elizarov]

Hello,

I need to figure out how to display multiple select options in a cell that is contingent upon another cell. I’m making a list of corporate goals, then under corporate goals I have department goals. I want my cell to display only goals that I choose from within the department goal category.

I have one column for Strategic Goals, another column for Department, and another column that I want to use to display Departmental Goals. I want to be able to search within the Department to select the goals I want displayed within the cell without it showing me every department goal. Is this doable? Please help asap! Thank you.

[Justin_Barrett]

Welcome to the community, @Artur_Elizarov! :grinning_face_with_big_eyes: This can’t be done with multiple select fields, but could be done with a clever setup that uses linked records. Here’s the thread from @W_Vann_Hall that outlines the setup:

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…

[Artur_Elizarov]

Is it able to display multiple choices? For example I may have 3 goals within the Sales department I want to display from within the cell. Would I be able to choose all 3 or just 1?

[Justin_Barrett]

I haven’t built that setup myself, but my hunch is that it would allow you to make multiple selections because you are just adding links to another table.

[teagads]

Link no longer works