Good question,

I am not sure I can use a RG for this project because the seats are not following the same pattern. For example notice how the seats are placed from row 10 to 17:

In a RG the seats would be placed from 1 to 23 with no spaces between them…where needed.

My second problem is that I have 4 conditionals for each seat depending on different actions of the user: spectacle chosen, if the seat is only reserved but not paid yet, if the seat is paid, if the seat is booked by current user or another user.

For example one conditional is Do a search for Carts with 2 constraints:

Seat = current seat
Spectacle = Dropdown Spectacle name

well…I do not have the droppdown in the RE to apply this conditional.

Moreover, each seat can be booked multiple times by same or different user…based on the spectacle.
For example if this weekend, we have 2 different spectacles running: Seat 5 on Row 5 can be booked once for 5$ for spectacle 1 and again for 10$ for spectacle 2.

Maybe I am missing something in doing it as a RE but believe me I tried and it does not work.