Skip to main content

Im not sure how to ask this in order to look up suggestions. 

I have an order form that I created on a workstation. Based on the photographer, the client is given the options offered by that photographer. Once they select the options/services they would like I am hoping to have a field that auto adds the selections they made. 

Is there a formula or script I can create where each selection they choose can be given a designated price that can be added up for a grand total much like an invoice?

I am attaching an example of one of the photography options 

I think I figured this out! with 

IF(FIND("25 HDR Photos $105 (Recommended only for homes under 2000 sq ft)", {Amoura Services}), 105) +
IF(FIND("35 HDR Photos $130", {Amoura Services}), 130) +
IF(FIND("50 HDR Photos $160 (minimum package for Airbnb/VRBO listing)", {Amoura Services}), 160) +
IF(FIND("75 HDR Photos $185", {Amoura Services}), 185)
 
 

Yes it can be done. Please refer to this answer - 
https://community.airtable.com/t5/other-questions/assigning-value-to-an-option-in-a-multiple-select-menu/td-p/63295

Yes it can be done. Please refer to this answer - 
https://community.airtable.com/t5/other-questions/assigning-value-to-an-option-in-a-multiple-select-menu/td-p/63295


Thank you, I saw this thread and was able to make it work 🙂

Reply


Terms & Conditions