Can you specify different fields to display the user clicks grid edit?

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

I have a table report that includes some text formula fields.  These fields are used instead of the original text - multiple choice field so that I can add some conditional formatting based on their selection.  When the user views the table report, I want the user to see the color formatted field, but when the user goes into grid edit mode, then I want the user to be able see and edit the original text - multiple choice field.  Is there a way to do this? 

Photo of Tamara

Tamara

  • 428 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Indeed there is a way.

Make a form - yes a form, to list the fields in the sequence that you want to appear in Grid Edit.  I suggest naming the form "Grid Edit", but that is up to you.

As soon as you have more than 1 form, then you will have the option to let QuickBase know when to use which form. 

Specify that Grid Edit form to be used as a default for all Grid Edits, if that is what you want, or just for that one report
Photo of Tamara

Tamara

  • 428 Points 250 badge 2x thumb
Thanks!  I will definitely try this out.
Photo of Heather Bryant

Heather Bryant

  • 30 Points
Hey Mark. I was running into similar Grid Edit issues. I followed your instructions above and created additional forms, and set them on the Form Usage page. The new form is showing in Grid Edit, but there is still one lookup field that appears. The lookup field is not on the form, and it is not a required field. Any ideas on why one single field would pop up in Grid Edit, even if its not on the form?
I suspect that field is the field [Related parent] - ie the field which connects the children with the parent.  If you do not have that on your Grid Edit form, then QuickBase forces it on the form (and hence the Grid Edit embedded report).  

The lesser evil is to put it on your form as say the most rightmost grid edit column, so it does not distract your users, as if QuickBase adds it automatically, you may not like where QuickBase puts it.