Add Field (Forms Design)

How Do I...

The Add Field dialog is used to add a field to a form in the forms design window.

  1. On the Add Field dialog, select the tab for the category of field you want to add to the form (Individual Fields or Columns).
  2. Select a field type from the drop list if necessary to find the field that you want to add.
  3. Select the field that you want to add to the form from the Field Name list.
  4. Click the OK button.
  5. The field should appear on the form.
  6. Position the field where you want it to appear on the form. To position a field on the form, click on the field to select it and then drag it to the desired location. You can also use the arrow keys to move the selected field to the precise location that you want it.
You can now use the date format set up for Microsoft Windows automatically. This is very useful for Canadian users, for instance, who need a specific date format in their checks.

Closed What are Individual Fields and Columns?

Individual Fields and Columns are data fields. These fields populate the form with data from the Sage 50 database. They are different than text fields which populate the form with the text that was entered in the forms design window.

Individual Fields are data fields that only have one possible value on each form. Examples of individual fields on an invoice are the invoice number, invoice date, and customer name. An invoice can only have one invoice number, one invoice date, and one customer name.

Columns are data fields that appear in a column (or list) on a form. Examples of column fields on an invoice are quantity, item description, and unit price. You can sell multiple items on one invoice so these fields can appear multiple times on the invoice.

Warning: It is important to place these fields in the correct location on the form. If you place an individual field within a column or a column field outside of a column, you may get unpredictable results.
What do you want to do next?

Published: March 21, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks