Respective quantity

AppSheet AppSheet Q&A
1

Hi

I’m having a problem choosing multiple drugs and the corresponding amount for each.
Regarding drugs, if I choose a lot, I can use EnumList, but in terms of quantity, how do I make the quantity corresponding to each drug if there are 50 types?

khangLixil_0-1669774560283.png
khangLixil_0-1669774560283.png597×461 21.4 KB

I can’t add 50 lines on google sheet because it’s too long and I don’t like it.
Is there any way?

khangLixil_1-1669774642725.png
khangLixil_1-1669774642725.png1245×500 18.5 KB

Thanks

2

In a typical tables design, when you need multiple values of the same attribute, you are advised to use a child table.

So in your case

  • Drugs: Parent table
  • Drug Size: id, drug id, size, (type name if you need)

To display valid sizes/types relevant to a chosen drug, an expression like below can be used

  • SELECT( Drug Size[size], [drug id] = [_thisrow].[drug id])
2 Likes