Difference between revisions of "Subforms"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 8: Line 8:
:*List of available inventory items
:*List of available inventory items


'''To Add or Edit a Grid Section:'''
====To Add or Edit a Grid Section====
#Click '''Designer > Data > Objects > {object} > Forms > {form}'''
#Click '''Designer > Data > Objects > {object} > Forms > {form}'''
#Choose one of the following options:
#Choose one of the following options:
Line 35: Line 35:
#Click '''[Save]'''
#Click '''[Save]'''


;Column-Total Adjustments:
====Column-Total Adjustments====
If you total one more currency fields, you can elect to apply adjustments to one of them:
If you total one more currency fields, you can elect to apply adjustments to one of them:
:* '''Surcharge -''' Adds a surcharge percentage field to the form.
:* '''Surcharge -''' Adds a surcharge percentage field to the form.
Line 52: Line 52:
::* Only currency fields can be selected for additional computation.
::* Only currency fields can be selected for additional computation.


{{DeveloperNote|<br>Vertical Totals and additional-computation fields are added to the original object (the object the grid section is defined on). The field names have the form <tt>grid_{name}_123456...</tt>, where the name might be "discount", "net_total", or "comptn" (for a vertical total), and where the number at the end is a unique identifier in the platform for this object, this form, and this grid section.}}
{{DeveloperNote|<br>Fields for Column Totals, Column-Total Adjustments, and the Net Total are added to the original object (the object the grid section is defined on). The field names have the form <tt>grid_{name}_123456...</tt>, where the name might be "discount", "net_total", or "comptn" (for a column total), and where the number at the end is the ID of the object [[Field]].}}

Revision as of 23:01, 25 August 2011

Designer > Data > Objects > {object} > Forms > {form} > {grid section}

Grid sections display related records (records that have a Lookup to the current record).

For example, Grid Sections might present this kind of information in a record:

  • Expense line items in an Expense Report object
  • Line items in a proposal or invoice
  • List of available inventory items

To Add or Edit a Grid Section

  1. Click Designer > Data > Objects > {object} > Forms > {form}
  2. Choose one of the following options:
    • To add a new grid section, click the New Grid Section link (located in the Elements Sidebar)
    • To edit an existing Grid section, click the Edit link in the section heading.
  3. Fill in the information that defines the Grid Section:
    Name
    The label that will be displayed in the GUI.
    Section Type
    Pre-populated (do not change)
    Object Name
    The Object records to display in the grid section
    Linking Field
    Select the field that does a Lookup to the current object. (A list is presented, in case there is more than one.)
    Number of Rows
    Specify the number of rows to display in the Grid section
    • This is the minimum number of number of rows to display.
    • It defaults to 5 rows. You can specify any value up to 100 rows.
    • If data exists, then all available data is shown, plus an additional 3 empty rows.
    Header Image
    Optionally, select an image to display at the top of the section
    Footer Image
    Optionally, select an image to display at the bottom of the section
    Left Side Image
    Optionally, select an image to display to the left of the section
    Right Side Image
    Optionally, select an image to display to the right of the section
  4. Use the Arrow Buttons to move fields from the list of Available Fields to the Selected Fields list, and to specify their order.
    The selected fields are displayed in the Grid Section when the form is displayed.
  5. Click [Next]
  6. Fill in the information on the second page:
    Sort Settings
    Choose the column to sort on, and specify ascending or descending sort.
    Column Totals
    Select the numeric and currency fields that will be automatically totaled.
    Column-Total Adjustments
    This section appears when you are totaling currency fields. Select the currency field that will have additional adjustments applied to it. (See below)
  7. Click [Save]

Column-Total Adjustments

If you total one more currency fields, you can elect to apply adjustments to one of them:

  • Surcharge - Adds a surcharge percentage field to the form.
  • Discount - Adds a discount percentage field to the form, as well as a discount amount. (The user can enter either one. If an amount is entered, it is saved as a percentage.)
  • Tax - Adds a tax percentage field to the form.
  • Shipping - Adds a field for a shipping charge.

Each selection adds the appropriate fields to the form, and does the appropriate calculations to produce a net total:

File:GridInForm.png
Considerations
  • All numeric and currency fields are listed (and only those fields).
  • Vertical Totals can be specified for one or more of those fields
  • The Enable Additional Computation option can be applied to exactly one of them.
  • That option only appears when a Vertical Total column has been selected for a currency field.
  • Only currency fields can be selected for additional computation.

Notepad.png

Note for Developers:
Fields for Column Totals, Column-Total Adjustments, and the Net Total are added to the original object (the object the grid section is defined on). The field names have the form grid_{name}_123456..., where the name might be "discount", "net_total", or "comptn" (for a column total), and where the number at the end is the ID of the object Field.