Fixed spaces for rows in view

[bloominghearts]

Hi,

I am a newbie. I would like to create a Bed position in ICU, where a patient can be admitted and discharged from that bed. If the bed is empty, it should show a blank space.  How do I do it? ICU is a slice of a larger table. 

@Steve @vchitra 

thanks

[Steve · Accepted solution]

Add a row for each bed position, occupied or not.

[bloominghearts]

thanks @Steve , created a table called ICU beds, 

How do I transfer  columns from the 'tracker' table that I have to the specific row in 'ICU beds'

[Steve]

Please explain what the tracker table is for. Specifically, why would you not keep all the patient data directly in the ICU_beds table?

[bloominghearts]

Hi Thanks @Steve , the tracker table is a one table that holds all the patient information.  each patient is a row. the patient info is discussed in one view, then the patient is transferred to the next view for the planning, then the patient is admitted , then operated and transferred to ICU and then to pre discharge.

each of this is a slice of the tracker table. 

now I had this idea to form a bed position in ICU. 

Thank you for your time

[bloominghearts]

Found a workaround though.

created a grouped action that assigns a bed first and then transfers to that row in ICU_beds. Then kept the bed number in ascending order.

I am not sure if that is the smart/right way to do it

[Steve]

Sounds good to me!