List out more than 1 column value into Enum

[Samng]

Dear Sir,

Good day.

I would like to seek the  help for the solution. Appreciate and many thanks.

I tried to create a app to calcuate the  Cost of material.

flow as below :
1) choose a  [size]
2) based on the choosen [size],  a list  of value shown in [addon] in enum-button
3) the [amount] depend on the choose [addon]

ex 1 :
1) choose "8"
2) addon enum -button show  :  SE2   SE3    ( show only if greate than  0 )
3) select SE2 , amount = 8000

ex2:
1) choose "12"
2) addon enum-btton show : SE1  SE2   SE3   SE4 
3) select, SE1 , amount = 120

input-table

Size (enum-dropdown)	Addon (enum-button)	Amount
6	SE3	6000
8	SE2	800
8	SE3	8000
10	SE1	100

addon-table

SIZE	SE1	SE2	SE3
6	0	0	6000
8	0	800	8000
10	100	100	1000
12	120	1200	12000

input-form

SIZE (enum-dropdown)

addon (emum-button)

amount

thanks ~

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/961554-dependent-dropdown

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/961554-dependent-dropdown

[Samng]

Hi Marc,

thanks for the hint, will give a try. 

[Samng]

Hi Matt,

Its works !! i modified the table structure, and follow the tutorials.

[Samng]

i create a virtual column to calculate the "total“ after user select the "addon" type.
but i can only get the "total" after clicking the "amount".  

any idea if i can get the "total" once i select SE2 ? 
note:   each "addon" have only 1 price for each size. 

thanks again. 

[Samng · Accepted solution]

Hi , I found the guidance in forum

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-do-i-auto-populate-a-field-value-based-on-t...

set the column [amount] initial  value to = LOOKUP([_THISROW].[ADDON],"ADDON","ADDON","AMOUNT")

and remove the  addon.[amount] in valid if ( previously use for dropdown)

It's work ..thanks again 

[Samng]

correction :

previous code  : lookup doesn't work well. 

i  update the code as below ,   thanks  @Steve 

ANY(
SELECT(
ADDON[AMOUNT],
AND(
([_THISROW].[SIZE] = [SIZE]),
([_THISROW].[ADDON] = [ADDON])

),
TRUE
)
)

 valid if = Addon[amount]