Home / QIN / drop down

drop down

Syndicate content
No votes yet
More
Conditional Drop Down Box Example
Conditional Drop Down Box Example
October 25th, 2009 - 12:10 PM
0 comments
Tags:
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 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