How do you set conditional pricing? I am try...

(ZOCO Unlimited) #1

How do you set conditional pricing?

I am trying to figure out how to set pricing for services… What makes this difficult is that there are 2 or more conditions that determine the price. We have a trucking company and depending on the truck used and the service provided depends on the price.

If Truck A hauls water = this price/hr If Truck A hauls equipment = this price/hr

Is there an IF statement out there that can help me? or anyone have any ideas?

(Aleksi Alkio) #2

Maybe the SWITCH expression… like SWITCH([Hauls], “Water”,40, “Equipment”,45, 35)

(ZOCO Unlimited) #3

Hey Aleksi, I am going to try this but have run into a problem first… maybe you can help me?? Before i had made all of the references and changes, I had a workflow that had an email sent to [Ordered By].[Email] … it was working and now it isn’t…

i put in a request to appsheet but am not getting very quick help… would you be willing to look at it?

(Aleksi Alkio) #4

Hi… I believe Gil just answered to your question.

(ZOCO Unlimited) #5


Gil did help :slight_smile: Thank you for everything!

(Aleksi Alkio) #6

You’re welcome