Populating the Sheet

Refer to the sections below on methods to populate the sheet.

Data Entry Forms

Every section of each integrator worksheet has a data entry form associated with it. These forms can be optionally used to help users select valid data.

Position the cursor in the relevant section below row 10 in the worksheet and click the Data Forms icon image121 on the More4apps ribbon.

Example Items Header form:

image113

More information on the use of data entry forms is explained here.

Downloading

Information can be downloaded via sheet fields or alternatively through using the Download form. We recommend downloading data into the worksheet before attempting to update any records to ensure accurate information exists prior to validation and upload.

More information on downloading can be found here.

Manual Data Entry

As More4apps modules work within Excel, all standard Microsoft Excel functions are available for use to assist with populating the worksheet manually.

For example:

  • Standard text entry

  • Formulas

  • Filters

  • Copy and Paste

  • Macros