How do I show a form as the default view (landing page) when selecting a table? Not a report.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a table with several forms. I want to use one, which basically is just guidelines, as the default view when the table is selected. See attached. That is a form I want to appear on default.



Thanks

Photo of Ian

Ian

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
There is not a native way to do this.
Photo of Ian

Ian

  • 0 Points
What do you recommend as a workaround? Maybe a dummy report?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
This can be done with script but there is a point I need to make first.

QuickBase distinguishes between an "Application Dashboard" and a "Table Homepage" although the URL action for a "Table Hompepage" is ?a=td - which suggests there may have been an oversight when QuickBase named this action as td probably stood for table dashboard. Or maybe td stood for table display. Who knows?


But the bottom line is that you can only put a report on the "Table Homepage". However that report could be configured to have an image onload field [-] as the sole column which through script could force a redirect to another page - such as the view of a form for a particular record with the instructions. This assumes you are willing to create one dummy record which does not carry any meaningful field information but merely serves as a way to display a view of the record with instructions. This is getting to be a bit of a hack but it is neverless possible. Visit this application and observe how the alert delays the redirection to viewing record 1 with form dfid=10:


Default Form on Table Homepage ~ Redirect to Display [Record ID#] =1
https://haversineconsulting.quickbase.com/db/bmaa988nc?a=td


The essential code is in this pastie:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=526

This isn't the greatest solution but it works because JavaScript can solve all your problems. What really should happen is that QuickBase should allow Table Homepages to be used in the same fashion as Application Dashboards.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
You could show an empty report with a description that returned no records ([Record ID#] = 0 - this never happens). Place all your instructions in the description.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
Or building on Dan's suggestion, you can have the Table Home page report be a singe record with a singe field.  The field can just be a text field or it can also be a formula text field with HTML enabled.  Then you could have bold and bullets and underlining and control color and font size.
Photo of Ian

Ian

  • 0 Points
What about a Formula URL button that takes the user to the form, or a file attachment that opens the language in a PDF?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
This is probably the simplest and should have been the most obvious solution (to me even). However, it is using one record and a field to carry the instructions you want to display but that one record and one field serve no other information bearing purpose.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
The is a syntax which you would allow you to have a table of documents - in fact you may already have such a table in your app, and then the url would open a particular document on a particular record.  So the user would land on a report with a field called show instructions.