AnsweredAssumed Answered

How to get the min result of a filtered list of prices?

Question asked by celineladoire on Jul 26, 2018
Latest reply on Aug 16, 2018 by celineladoire

This is my setup:

 

I have a parent table (Cruises) containing a ref, which is the connecting field to connect it to a children table (Prices).

In this children table, I have the prices for all the individual cabins for each cruise. Each have an availability field (number field), and a type field (Inside, Outside, Balcony, Suite).

 

What I need to do is find the cheapest cabin with an availability above 0 for each of those 4 types for each cruise. And put those results in 4 individual fiels.

Outcomes