multiple choice

Is it possible to display the number of records in a particular multiple choice category as a percentage of all the records?

Yes.

Create a summary report using the "percentage of total" option. Please see: https://www.quickbase.com/help/creating_a_summary_view.html

February 5th, 2009 - 6:02 PM

0 comments

Tags:

Add new comment
32487 reads

How do I make a formula date field called "Completion Date" that captures the date when a multiple choice field called "Status" is set to a particular value like "Complete"?

The best way to do this is to flip the problem around on its head.

1) Instead of making the date field a formula field, make it a plain date field.

2) Then remove the choice of "Complete" from your multiple choice "Status" field.

3) Create a formula text field called "Computed Status".

4) Put the following formula into the formula property of the "Computed Status" field.

February 5th, 2009 - 6:02 PM

1 comment

Tags:

1 comment
Read more
36096 reads

How do I have one drop down list's choices determine the choices available in another drop down list?

You can indeed make one dropdown list dependent on the user’s choice in another dropdown list. The dependent list is called a conditional dropdown list.

This article provides a quick overview of the most common and recommended method for creating conditional dropdown lists. For detailed instructions and tutorials you can follow, see these QuickBase online help topics:

February 5th, 2009 - 6:02 PM

4 comments

Tags:

4 comments
Read more
42028 reads

Browse by Category

Knowledge Base Categories

Formula Category

The QuickBase Blog

Online Database Software:

Company Information:

Site Links:

From the Makers of: