Home / QIN / multi

multi

Syndicate content
More
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:
More
How do I get a blank choice in my list of choices for a multiple choice field?

For a multiple-choice field, you cannot enter a blank line as a choice in the list of options. If you do, the blank line gets removed when you apply your changes. However, you can leave the "Default Value" option blank. If you leave the default value blank, then the Add Record and Edit Record forms will have blank selected in the drop-down list.

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
How do I let users of my application add additional choices to a multiple-choice field without giving them administrative privileges?

1In the table bar on any application page, click the table containing the field. Within the menu that appears, select Customize --tablename-- table > Fields.

2. Click the field's name that you want to modify.

3. Select the "Allow users to create new choices" check box, and click "Apply Changes".

February 5th, 2009 - 6:02 PM
2 comments
Tags:

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit