Fixed spaces for rows in view

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

bloominghearts_0-1738865613218.png

 

Solved Solved
0 6 127
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

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

View solution in original post

6 REPLIES 6

Steve
Platinum 5
Platinum 5

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

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'

bloominghearts_0-1738895338286.png

 

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

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_0-1738942731074.png

 

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

bloominghearts_1-1738943167386.png

 

Sounds good to me!

Top Labels in this Space