Price tag for each on multiple selection

[Standa_Prosek]

Hello community!
I have streetdance school and this year im doing database with airtable (amazing next to the numbers :slightly_smiling_face: ). Id like to put price for each member of my school.

I have collumn with multiple selection (for ex.: streetdance, breakdance, contemporary) and for each course is different payment. Is possilbe to put pricetag for every selection and if i choose any of styles there would be amount of payment.

if streetdance would be $40, breaking $50, contemporary $60
member 1 choose streetdance > automaticaly 50
member 2 choose streetdance + breaking > automaticaly 90
member 3 choose streetdance + contemporary > automaticaly 100

is that possible?
Thank you!! :slightly_smiling_face:

[Kamille_Parks · Accepted solution]

Its possible, but you may consider giving the dance styles its own table. That table would have one field for the name (Streedance, Breaking, and Contemporary) and another field for price ($40, $50, $60)

If you convert your existing multiple select field into a link to another record field a new table will be made for you. Then you could use a rollup field to SUM(values) of all the prices for each record’s selected dance style(s).

---

If you would still prefer to use a multiple select field, you would need to write a formula like this:

IF(FIND("streetdance", {Multiple Select Field}), 40, 0) + 
IF(FIND("breaking", {Multiple Select Field}), 50, 0) + 
IF(FIND("contemporary", {Multiple Select Field}), 60, 0)

[kuovonne]

If you want a discount for multiple selections, it is still possible, but would require a more complex formula.

[Standa_Prosek]

Thank you so much, this formula works well :star_struck: