Adding fields to form header

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I would like to show store name in the header to prevent it from being scrolled as part of the form navigation.  How do I do that? 

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Settings, for the Table
Then Advanced Properties
Then near the bottom there is a place to specify which field is used for Record Identification .
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks Mark. I am already using that to show the project n number.  I was more interested in putting a field next to this with the Store Name.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
You can make your own field called [Form Record Header]

List(" ", "#" & ToText([Store number]), [Store Name])
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks.  This would be a formula text field. How do I place it to appear in the header?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
You would use the Advaced settings for the table to use your new combination field as the record identifier at the top of the form, instead of the Store number field you are now using.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
I got it.  So I am replacing whatever I had previously. Thanks a lot. This works great.  Can I still use formatting to go with this field as I currently I have?

"<div style=\"font-weight: bold; background-color:yellow; color:red; font-size: 200%; text-align: center; \">" & [Store Name] &" - "& [Banner]& "</div>"
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
I tried it like this but does not work.

List(" ", "#" "<div style=\"font-weight: bold; background-color:yellow; color:red; font-size: 200%; text-align: center; \">" & ToText([Project No]), [Store Name] & "</div>")
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
I don't think you can use formatting.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks.  Looks like QB needs a lot of enhancements as I am constantly reminded. Native capabilities are sometimes limited.