Select List based on multi column multi-select criteria

1

I have two tables: Garden and Plant Profiles.

In Garden, there are three columns: Light (options: full sun, light shade, part sun/shade, shade, low light), Soil Type (options: sandy, clay, loam), Soil pH (options: netural, acidic, strongly acidic). They are connected to the same option tables as the corresponding columns in the Plant Profiles. In the Garden table, I want to be able to select the plants that meet the criteria of the zones in the garden.

My options formula so far for the plants select list in the Garden table:

[Plant Profiles].Filter(
Light.Contains(thisRow.Light)
AND [Soil Type].Contains(thisRow.[Soil Type])
AND [Soil pH].Contains(thisRow.[Soil pH])
).[Name]

Screenshot

image
image1523×792 79.5 KB

Here is a link to the coda doc:

2

In case anybody has a similar issue, I finally found the solution…I probably was pointing to the columns with the wrong table.

[Plants Profiles].Filter(Light.Contains(thisRow.Light) AND [Soil Type].Contains(thisRow.[Soil Type]) AND [Soil pH].Contains(thisRow.[Soil pH])).name

3

Hi,

The doc you shared can’t be edited or copied so it’s a bit hard to assist. Are you able to reshare it?

However, my first suggestion is to remove the .Name from your formula. That is causing coda to return a list of text values, whereas you will be wanting the list of rows, so -

[Plant Profiles].Filter(
Light.Contains(thisRow.Light)
AND [Soil Type].Contains(thisRow.[Soil Type])
AND [Soil pH].Contains(thisRow.[Soil pH])
)

should do that.

Cheers,
Robin

4

Hi Robin, I managed to figure it out in the end, and thanks for your suggestion to remove “name”. That was useful.