Hi everyone, Im using an EnumList type column with a SELECT() formula to pull the results from another table, it worked fine so far with this formula:
select(Reservas [Booking number], ([Cliente]=[_THISROW].[Nombre]))
What I need now is that the formula using the same search term: ([Cliente]=[_THISROW].[Nombre]). to bring back the data of two columns of the row that match the search or select term.
i.e. in the EnumList Type column the results that show are the “Booking number” so far, I want it to have next to it the name of the cabin they are staying in. The result should be something like “Booking number, Cabin”
This way they wont have to go through their email to see which reservation is for each “Casa” before continuing to the next section of the form.
I tried the following formulas, the syntax seems correct but it still only returns one column.
(select((Reservas [Booking number]) and (Reservas [Casas]), ([Cliente]=[_THISROW].[Nombre])))
I also tried wrapping two select formulas with AND() but that didńt work either, any ideas?