For an prompt, can I have a default answer in case the user doesn't make a selection?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a report that has 7 <ask the user> filter prompts (Fiscal Year, Quarter, County, City, Reporting Station, Reporting Center, Report Category). In some cases the user will only need to filter by one prompt such as fiscal year.

Is there a way to make the <ask the user> filter prompts default to <anything> if no selection is made?
Photo of Maria


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of James


  • 0 Points
Hi Maria,

Thank you for reaching out to the QuickBase community. There is no native function in QuickBase that will default the ask the user report to <anything>. In this case if your user does not want to filter their report based off of one of those fields they will need to select <anything> from the drop down.

James Travaglini
QuickBase Support
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
James, I have the same issue where I am providing a sales chart to the user to select a store to see the sales but when I click on the chart it asks for the input  again.  Is there a way to at least take the user to a summary report for the selected store so that user is able to see the associated  dollar values?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
This is easy to do with script. If you look at this application you will see there is a button labeled "With Dialog" which when clicked solicits some input from the user and when the OK button is clicked proceeds to create some records base on the information entered. 

Hylo[morphism] Technique

In broad terms you have a similar need - solicit some user input with a dialog box and then go do something using that input. The particulars are that your user input are selections from seven selects controls and your action is to display a report consistent with the parameters entered.

I quickly modified some code from the above example to create a form for your seven select controls and manually applied the script. See the resulting screenshot and code. All that has to be done is synthesize the URL of the report from the values in the seven select controls and redirect to that URL.

If you need individual help implement this solution feel free to contact me off-world using the information in my profile.