Home / QIN / Text / Text

Text

Syndicate content
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:
More
How do I create a field that displays the hours and minutes portion of the built-in timestamp fields "Date Created" and "Date Modified"?

Create either a view with a "Custom Column" of type text that has the following formula:

Int(ToHours([Date Created]-ToTimestamp(ToDate([Date Created])))) & ":" & Int(Mod(ToMinutes([Date Created]-ToTimestamp(ToDate([Date Created]))), 60))

or a formula text field with the same formula.

The formula for "Date Modified" would be:

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
How do I convert the "Date Created" field to yyyymmdd format?

You can create a formula field of type text that has the following formula:

List("-",ToText(Year(ToDate([Date Created]))),Right("0" & ToText(Month(ToDate([Date Created]))),2),Right("0" & ToText(Day(ToDate([Date Created]))),2))

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

© 1997-2013 Intuit Inc. All Rights Reserved.

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