And/Or for If → Than → Else Column

Hey @Darren_Murphy, I’m working on a car rental app (you helped me a last week with it here).

When a user searches for available vehicles within a timeframe, I want to display the price it will cost them for each vehicle (prices are different for each vehicle class/type). When they select the vehicle and reserve, I want to create a record in the bookings table and set the price for that booking with ‘set column values’ from the price it was displaying for them while searching.

Each vehicle has an hourly rate and a daily rate. For example, a car can have an hourly rate of $20/hr and a daily rate of $90/day. I want to set one total booking price column with the following conditions:

If total booking days is equal to or greater than 1, then apply daily rate.

If total booking days is less than 1, AND total price (hourly rate) is greater then daily rate, then apply daily rate. Else, apply holy rate.

Essentially, if someone is booking for example for 5 hours, I don’t want to apply hourly rate (which will total $100, and exceeds daily rate), instead I want to apply the daily rate.

The only way I see it being done now is by setting visibility conditions on the component displaying the price on each vehicle while user is searching, and setting the same conditions again when setting column values in the action flow when finalizing booking.

It would be much easier if I hade one If Than Else column that I would be able to set above conditions, and use it for displaying the price while searching, and setting column values in final booking.

1 Like