Dropdown and math operations

[AlexBeschier]

Hi there, 
I'm newbie here and hope you help me.

1) I need to create a dropdown with a list of names of components (i.e. resistor), that will allow to select more than 1 item.
2) When one component is selected, person need to insert qty (and so on for each selected item)
3) Each component should have linked a price 
4) When all required components will be selected and all qty will be inserted, where should be a field i.e. Money Spent, where will be shown SUM based on price of each component * qty of each component inserted by user

[Suvrutt_Gurjar]

Welcome to the Appsheet community.

Please always post questions in the "Q&A" section.

[AlexBeschier]

hello, should I move it?

[Suvrutt_Gurjar]

Yes, please that will be good, if you can do so. Thank you.

[SkrOYC]

I suggest to report as inappropiate and tell @Michelle and others to move to QA

[Steve]

---

@AlexBeschier wrote:

I need to create a dropdown with a list of names of components (i.e. resistor), that will allow to select more than 1 item.

---

This would be a column of type EnumList.

---

@AlexBeschier wrote:

When one component is selected, person need to insert qty (and so on for each selected item)

---

There is no way to allow the user to enter a quantity directly into the dropdown in which they make their selections. To combine selecting and quantity-entry, you'd have to use as different approach.

---

@AlexBeschier wrote:

Each component should have linked a price

---

Readily doable.

---

@AlexBeschier wrote:

When all required components will be selected and all qty will be inserted, where should be a field i.e. Money Spent, where will be shown SUM based on price of each component * qty of each component inserted by user

---

There's no way to do this in a dropdown, but there are other ways to do it.

I think your best bet would be to spend some time familiarizing yourself with AppSheet and exploring the different options.