Skip to main content
Solved

Price tag for each on multiple selection

  • September 14, 2021
  • 3 replies
  • 25 views
S

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:

Best answer by Kamille_Parks11

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)

    3 replies

    Kamille_Parks11
    Forum|alt.badge.img+27

    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)
    S
    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • September 14, 2021

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

    S
    • Standa_Prosek
    • Author
    • New Participant
    • September 15, 2021

    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)

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

    Terms & ConditionsAccessibility statement