Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 06, 2023 12:39 PM
Hi all! I am reaching out in hope of finding a solution. So I work for a music instrument manufacturer where we track each job (all instrument specifics) in our airtable database. I am trying to find a way to have a price column that calculates as you toggle the different specs of each instrument. Any ideas or solutions here?
Thanks ahead of time!
Nov 06, 2023 12:47 PM
Hey @horrorbizz0 ! Can you share some screenshots of your current setup and explain more of the mechanics behind 'toggling different specs' ? Curious what you mean by this and how you're building it. Will better help me to provide a better solution. Thanks!
Nov 06, 2023 12:55 PM
Nov 06, 2023 02:03 PM
I'd probably make a formula field for each of your select fields.
use the SWITCH() function to apply a number value to each option.
SWITCH(
{Neck Wood},
"Cherry Clear", "50",
"Maple Clear", "40"
etc
You could then use another formula at the end to add it all together. Or use some as percentages? Depends on your pricing strategies.
Let me know if this works 🙂
Nov 11, 2023 11:27 AM
@horrorbizz0 I agree with @Sistema_Aotearo that a switch statement is probably your best way of solving this. I recorded a short Loom Video to show you step by step how I'd go about getting this setup and displaying custom pricing.
Table Setup and expected output: