Quick Base Discussions

Expand all | Collapse all

Two Rows each record?

  • 1.  Two Rows each record?

    Posted 08-26-2017 18:54
    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!


  • 2.  RE: Two Rows each record?

    Posted 08-26-2017 18:58
    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.


  • 3.  RE: Two Rows each record?

    Posted 08-26-2017 19:03
    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.


  • 4.  RE: Two Rows each record?

    Posted 08-26-2017 19:12
    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.


  • 5.  RE: Two Rows each record?

    Posted 08-26-2017 19:36
    So the formula type for the new field would be what?  Formula - ????


  • 6.  RE: Two Rows each record?

    Bronze
    Contributor
    Posted 08-31-2018 13:11
    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.


  • 7.  RE: Two Rows each record?

    Posted 08-26-2017 19:37
    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.


  • 8.  RE: Two Rows each record?

    Posted 08-26-2017 19:41


  • 9.  RE: Two Rows each record?

    Posted 08-26-2017 19:44
    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]))


  • 10.  RE: Two Rows each record?

    Posted 08-26-2017 19:47
    Getting closer and thanks for the help!


  • 11.  RE: Two Rows each record?

    Posted 08-26-2017 19:52
    I fixed it.  So can I add another carriage return in my formula so there will be a space between the two fields list?


  • 12.  RE: Two Rows each record?

    Posted 08-26-2017 20:31
    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",


  • 13.  RE: Two Rows each record?

    Posted 08-26-2017 20:43
    Super
    Thanks!