Availability frame

[danielpbarros]

Good afternoon guys, how are you?

I wanted a help with regard to the development of a screen in which I can have a table of availability of units of a building.

Example: I have a 2-storey building with 4 unit (2 at first and 2 in the second). I have two status:

Select all

D = DISPONIVEL  
V= VENDIDO

this already in a table in my base.

What precise is that this appears in forms of tables ... Example:

Select all

APTO1 | APTO2 
______|______ 
APTO3 | APTO 4 
______________

as if it were a marking for hotel room .

ABS

[danielpbarros]

Anyone have any suggestions?

[stcoutinho]

Hello Danielpbaros,

makes a time shovel that I do not move with Apex, but could not you use a normal Apex report for this?

I say .. instead of you show text, you could upload images with the position of the free or sold apartment.

I do not know if this is suitable for what you intended to do.

Hugs,

Sergio

[danielpbarros]

The problem is that I need to show according to the property to be marketed.

For example ... if it is 2 apartments per floor, only two columns could appear ...

Was it via HTML not possible? The problem is how I will identify with HTML each frame with a record in the database.

ABS

[tiago.steil]

Good afternoon,

You could add a "PL / SQL Dynamic Content" region by creating a SQL function that sets the HTML as you need.
Ex: It makes 1 loop picking up the data and putting in columns.

I do not know if I was clear ..

AT,