Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Price tag for each on multiple selection

Solved
Jump to Solution
279 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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:

1 Solution

Accepted Solutions

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)

See Solution in Thread

3 Replies 3

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)

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

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