Two Rows each record?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I'm a newbie to Quickbase and have a quick question.  I am building an app to track inpatients in the hospital for our service.  I have a lot of field required per record so this requires the user to scroll to the right to view all the fields and also presents a problem when printing a "patient" list of active patients in the hospital.  I'd like to have two rows per record so the width of the report would be more narrow.  Can I do this?  If so, please help.
Thanks in advance!
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
There is no native way to have two lines per record.  

The normal use of QuickBase is to have a report which identifies the record, in your case, basic PT information and a few key fields.  The the user would get more information about the PT by viewing the record where all the fields would be nicely laid out on a form in sections and perhaps using the new colored tabs.

You may be coming from an Excel mindset where the only option was a very wide sheet and the was not concept of viewing a record.
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
Thanks.  They like to print out the record and have all the information on paper for our morning reviews.  We were using filmaker pro and had a layout that had multiple rows per record so it would all fit on paper in landscape orientation.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
The only thing that I can suggest is to build a duplicate set of fields to put two fields to together.

So, for example a field called [Doctor / Nurse] with a formula of 

List("\n",[Doctor],[Nurse])

That will list those two fields separated by a vertical carriage return.
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
So the formula type for the new field would be what?  Formula - ????
If you want the layout to include hyperlinks to the respective targets for some of the column or any other formatting, I would create a formula rich-text field. Here you can create a table with tr, td and/or a tags too.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
This would be a formula text field.  It's a formula field because it has a formula and the result type is text, so formula text is the type.
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
This is a text field, so the arguments for the list function must be type text.  If the fields being used are not type text, then they need to be converted to text.

Try this

List("\n",ToText([Admit Date]),ToText(Consult Date]))
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
Getting closer and thanks for the help!
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
I fixed it.  So can I add another carriage return in my formula so there will be a space between the two fields list?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
What you put in that first set of quote will be the separator. So, if you have a dash they. Separated by a dash. If you have two dashes then two dashes, so sure, you can choose to separate by two carriage returns.

List("\n\n",
Photo of Jeffrey Brooks

Jeffrey Brooks

  • 120 Points 100 badge 2x thumb
Super
Thanks!