Page History

...

For example, within the Grant Requests record type, the WPP has two Card Configurations set up: "Denied and Withdrawn" and "Grants." These cards represent subsets of the overall card, "Requests and Grants," which stores all grant applications (even those that are not accepted or withdrawn by the applicant) and awarded grants. The Card "Denied and Withdrawn," as the name implies, contains the subset of Grant Applications that were explicitly declined by the WPP and those applications that were intentionally withdrawn from consideration by their applicant. The Card "Grants" also stores a subset of Requests and Grants, but in this case stores all applications that ever became fully awarded Grants.

Export Format

The next tab over is the Export Format tab, which is used in determining what fields get exported (and in what order) when the Card Action "Excel Export" is used from the card "Actions" menu (see also the screenshot below).

Image Added

Screenshot showing how one uses the "Excel Export" option from a card. First, click the "Three Dots" menu found in the top right-hand corner of the card, then under Actions select "Excel Export."

The Export Format page can be used to configure the format that the data gets exported to Excel with. Please see the screenshot below to see important items highlighted on the Export Format page and beneath the screenshot for explanations of these highlighted items.

Image Added

1. Box # 1: Shows the "Export Format" tab when it is selected.
2. Box # 2: Shows the configurable label for each of the columns that will display in the Export. You can change any of these labels so that they are more understandable for staff. Please note, however, that changing a label here will change the label for that column on all future Excel exports from this Record Type unless this label is subsequently changed again.
3. Box # 3: Shows the Internal Field Name of the column in question. This can be useful (especially after a column label has been changed) for seeing what the field actually is. Can be matched with the Internal Field Name from the Fields tab to confirm the exactly field that you are looking at.
4. Box # 4: Shows an arrow that is both an up and down arrow (↑ and ↓). By clicking and dragging on this arrow, you can move columns up or down in the Export format to change/determine the order that the columns should be exported in.
   1. Note: The order in which the columns appear is as follows: The top column will be displayed farthest to the right in the Export table, and the bottom column will be farthest to the left in the Export table. You can, therefore, move columns up/down on this page to effectively move columns to the right/left (respectively) in the eventual exported table.
5. Box # 5: Shows the Save button. If you've changed a label or moved a column around in the export format, you must hit the save button in order for your changes to be effectuated. Otherwise, your changes will be discarded.

Field List

The next tab over is called "Field List."