Skip to Navigation


Syndicate content

Have you ever tried to build a form rule that needed some internal value that your users don’t need to see? If you set up another form rule which lists which fields should always be hidden, you can then build other rules with those fields without having to display them on the form itself:

April 3rd, 2014 - 10:04 AM

The way to do this is to create a new Add Record form for your table that will act as a 'dashboard' for users to select different forms for adding a record. This dashboard form will be unlike other Add Record forms in your table since it will not actually have any of the usual fields from your table on it.

February 5th, 2009 - 5:02 PM

1. Create a new report that includes all of the fields that you want to include in your mailing labels, form letter or envelopes. Expand the "COLUMNS TO DISPLAY" section and turn on only the columns that you need for your mail merge. Turn off all unnecessary columns.

February 5th, 2009 - 5:02 PM

If you can no longer see detail records in a report that you've embedded on a master form, someone has changed the Filtering (matching criteria) for that report.

February 5th, 2009 - 5:02 PM

If you want to restrict the number of characters in a text field, please see our Set Maximum Length for Entries in a Text Field help topic.

February 5th, 2009 - 5:02 PM

Certain fields are never editable directly. These include the five built-in fields, all formula fields, and all lookup fields. In addition fields that were at one time reference fields can behave in such a way that they don't display either a read-only or an editable value. Here is the situation that creates these former uneditable reference fields.

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

If your Checkbox field's field identifier is nine then you can put this on your Exact Form:

~=if(f['9']== 1)"checkmark";~

Replace the nine above with the field identifier of your Checkbox field.

To learn how to determine the field identifier of your field please read the following:

February 5th, 2009 - 5:02 PM