Auto compute column based on enumlist column selection in form

AppSheet AppSheet Q&A
1

In my form, I would like to auto compute the ‘food’ column values based on the ‘nutrition’ selection (enumlist). So if, ‘fruit’ is selected, then ‘food’ should have value ‘apple’. If both ‘fruit’ and ‘dairy’ are selected then ‘food’ value should be ‘apple, milk’

3X_0_b_0bb78c15f7b00586da573116c6f2b4c1cbb1ab37.png
3X_0_b_0bb78c15f7b00586da573116c6f2b4c1cbb1ab37.png348×419 5.57 KB

I have the idea that there should be an ‘If’ statement in the auto compute column for ‘food’, but my syntax is horrible:

3X_4_9_495161c4b24256a86561d145a2da37a998b55c8f.png
3X_4_9_495161c4b24256a86561d145a2da37a998b55c8f.png774×115 2.4 KB

Something like:
AND(IF([Nutrition]=CONTAINS("fruit")) then "apple",IF([Nutrition]=CONTAINS("dairy")) then "milk")

2

The expression shall be like this:

IFS(
    AND(
        CONTAINS([Nutrition],"fruit"),
        NOT(CONTAINS([Nutrition],"dairy")
    ),{"apple"},
    AND(
        CONTAINS([Nutrition],"fruit"),
        CONTAINS([Nutrition],"dairy")
    ),{"apple", "milk"}
)

But what value you will expect if only “dairy” is chosen from the ENUMLIST?

1 Like
3

IN(), not CONTAINS().

2 Likes
4

I’ve got this that works but seems klunky.
IFS( AND( NOT(CONTAINS([Nutrition],"fruit")), (CONTAINS([Nutrition],"dairy")) ), "milk", AND( NOT(CONTAINS([Nutrition],"dairy")), (CONTAINS([Nutrition],"fruit")) ), "apple", AND( (CONTAINS([Nutrition],"fruit")), (CONTAINS([Nutrition],"dairy")) ), "apple, milk" )

I tried with IN() but it doesn’t pull up the correct values when both ‘fruit’ and ‘dairy’ are selected.
IFS( IN("apple, milk",[Nutrition]), "fruit, dairy", IN("apple",[Nutrition]), "fruit", IN("milk",[Nutrition]), "dairy", )

5

Try:

(
  LIST()
  + IFS(IN("dairy", [nutrition]), {"milk"})
  + IFS(IN("fruit", [nutrition]), {"apple"})
)
1 Like
6

Steve:

+ IFS

That works! Thanks First time I’ve seen code with a plus sign. Don’t think I’ve ever seen documentation on it.

1 Like
7

@Tom_automated
Might worth reading

1 Like