Skip to Navigation


Syndicate content

You can use the following logic to create a "reverse look up" field. This will allow you to display a text value that lives in the most recent detail record on the master record.

April 29th, 2009 - 1:04 PM

You can limit the number of characters end users can enter or store in a field. Use this feature to help avoid data-entry mistakes in text fields. Carriage returns count as one character. To learn how, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 5:02 PM

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 5:02 PM

In order to show a portion of a particular field's data on a report and/or form, you need to take these two steps:

1) Create a new formula field that will hold the subset of the original field's data, and

2) Add the new formula field to the forms and reports where you want the condensed field showing.

February 5th, 2009 - 5:02 PM