FieldStack has a built-in exportation feature so that grids and search results may be saved in several formats for later usage or further analysis. To export and save a grid or table, click on the Export/Save As icon in the top-right corner of the screen and drag it onto the data.
You will then be prompted to save the file as one of several formats. These are:
Rich Text: document.rtf
Web Page: document.html
Enter a file name then choose the file type and where you would like to save the file.
The selected file type will then be created containing all the information from the original grid or table.
Excel is one of the most useful file formats for exporting data in grids and tables created in FieldStack. To quickly export data to Excel, click on the small Excel icon in the top-right corner of the screen and drag it onto the grid to be exported.
You may then take advantage of Excel’s formatting and viewing functions and save the document as well. This process is shorter than using the Export/Save As feature as it does not ask you to save the file first; a temporary copy is automatically generated and may be saved at any point.
Tabs (Tear out)
As different tabs (windows) are opened in FieldStack, they build up next to each other in the order that they are opened, from left to right. The active tab appears with a border around it.
To close a tab, either click the X located to the far right of the window or hit [CTRL] [W]. Both of these ways will close the active tab.
If your computer is hooked up to multiple monitors, you may wish to view some of these tabs side-by-side rather than click from one to another. To tear out a tab from the window, click on the tab heading and drag it away from the window.
A new window is then created for the torn-out tab. A tab can be re-attached by dragging it back into FieldStack. The screen turns blue when it is available to re-attach.
When you have a table of information, such as when you are viewing items in the Item Listing screen, you can filer and sort the listings.
You can sort listings by any of the columns. To do so, simply click on the column heading by which you wish to sort. The sorting will either by alphabetically or numerically (according to the column) and can be in either ascending or descending order depending on how many times you click the heading.
You can also change the order of the columns by clicking on a column heading and dragging it over to the desired place. Be careful to drag it only to the left or right as dragging it up or down may eliminate the column (if an X appears through the heading name as you drag it and you un-click, the column will be removed from view).
Additional sorting/filtering options can be found by right-clicking on the headings.
Sort Ascending: Sorts smallest to largest, oldest to newest, A to Z, etc.
Sort Descending: Sorts largest to smallest, newest to oldest, Z to A, etc.
Group by This Column: Group listings according to the information in that column
Show Group By Box: Insert the feature to allow grouping by column headers
Hide This Column: Removes the column of information from the viewing screen
Column Chooser: Additional column options (columns removed appear here) – double-click to add
Best Fit: Re-sizes that column so that all the information in it is visible
Best Fit (all columns): Resizes all the columns so all information is visible
Filter Editor: Allows you to create specific filter parameters
Show Find Panel: Adds search bar to the top of the screen
Show Auto Filter Row: Adds filter row where you can type into any column to filter on that text
Any headings on which the cursor hovers will have a small funnel icon appear in the top-right corner. You can click this to selectively display only listings including one or more of the selections.
For example, clicking the funnel in the Type column will give you the option to only display listings of a selected type. All the other entries will be hidden but not deleted.
The Filter Editor (accessed by right-clicking on a column heading and selecting Filter Editor) may be used when you have several conditions by which to filter listings. By default, the heading on which you click choose the Filter Editor will appear as the first condition, but it can be changed. The green words relate to different sets of options.
- Condition group
- Column heading
- Inclusion/exclusion specification
- Value input
If you wish to view only dog and cat food in the top sellers chart where there are fewer than 10 in stock, right-click on the QOH column and select Filter Editor.
- Click on the green Equals and select Is less than or equal to to indicate the quantity parameter, and then in the <enter a value> space type in 10. Clicking Apply now will filter the results so that only items with 10 or fewer in stock will appear.
- To view just Dog Food and Cat Food with this stock parameter, you need to add another grouping with two conditions. Click on the green And and select Add Group. Click the newly added And and select Or. Hit the plus sign (+) next to the Or to add another condition. It is necessary to specify Or as the condition will be processed as “show listings where the type equals Cat Food Or Dog Food.” Leaving it as AND will result in no listings being shown since a single configuration can’t start with two different terms.
- For these two conditions under Or, click on the [QOH] and select [Type]. Leave the Equals as is. In the <enter a value> fields, type Cat Food in one, and Dog Food in the other.
When you are done, the Editor will be read as:
“Show all listings where the Type Equals Cat Food Or Dog Food And the Quantity On Hand Is less than or equal to 10.”
Be very careful when filtering listings to include the correct conditions or else you may end up with the wrong view.
To temporarily remove the filter, click the check box next to the condition equation below the listings. This will remove the filtering, but leave the conditions there as an option to re-apply. To completely remove the filter, click the X next to the check box.
If you want to change or add some conditions to the filter, click the Edit Filter option located to the right of the condition equation. This will bring up the Filter Editor screen. Alternatively, you can click the funnel in the column headings and select further filters that way (either clicking on an option in the drop-down menu or selecting (Custom) for more specifications. Any edits done this way will automatically be added to the Filter Editor screen.
To group listings by like information, right-click on a column heading and select Group By Box (many of the reports already have a space to drag headings, so this step in not necessary). Click on the heading by which you would like to group and drag it into the black space above it. Have several sub-groupings by dragging multiple headings up. Click the plus (+) and minus (-) signs to display or hide the listings in the categories.
Copy cells/Right-clicking (reports)
When viewing a grid report, you can copy information in a single cell by right-clicking on it and seleting Copy.
To copy several cells at once, click one and either hit [CTRL] and click the other cells individually, or hit [SHIFT] and click the last cell you want to copy (if you are copying within a column) so that they are all highlighted. Then right-click on one of the cells and select Copy.
In many different tables and grids, right-clicking on a cell or heading will bring up a menu of additional options besides Copy. It is recommended that when viewing different screens for the first time you try right-clicking to view any options that may be useful.
Options Toolbar (reports)
The report screens often include a toolbar at the top of the window with several options.
Find: Search within the report for a specific word; there are Search Options where you can choose to find results that must match the case of what you typed, match the whole word, or search up (from where you currently are in the document).
Print?: Pulls up a list of available printers from which you may choose to print the document
Print: Prints to you default printer
First Page: Go to the first page of the document
Previous Page: Go back one page in the document
Next Page: Go to the next page in the document
Last Page: Go to the last page of the document
Export: Export and save the document as one of several file format options
Reports vs. Grids
Many of the reports in FieldStack may be viewed in a report or grid format. When available, the option will appear near the top of the window. The default view is as a report (which is how it would appear as a PDF) but checking the Grid option and clicking the Run button will put the data into an interactive grid format.
Reports group items first by condition (new or used), then format, and then the items are listed alphabetically. This is the best format to use for printing.
The grid format is useful when you want to view the data an alternate way. You can use the same Sorting, Grouping, and Filtering methods as explained earlier in this section.
Most aspects of FieldStack can be accessed by using shortcut keys on the keyboard. To indicate that you are going to use a shortcut key, you must first hit the [ALT] button. When you do this, prompt keys will then appear under the main headings.
When you type the corresponding key, the sub-categories will then appear with similar key prompts.
Type the keys, one at a time, until you reach the final prompt for your desired function. The [ALT] button needs only be hit the once at the beginning of the process.
Quick Access Toolbar
The Quick Access Toolbar is the upper-most bar on the FieldStack screen starting in the top-left corner.
Features may be added and removed from this bar for your convenience. If there is a feature you use frequently, you can add it to this toolbar by right-clicking on it and choosing Add to Quick Access Toolbar. This will add a shortcut icon, but will not move or change the original feature.
Once added, the shortcuts will appear in the toolbar in the order that they were added (this cannot be changed save for removing then re-adding them in the desired order). The shortcuts will appear in the toolbar each time you log into FieldStack.
Features that have an icon associated with them will appear as a shortcut button with that icon. For those that don’t, they will appear as a black circle. You may want to avoid adding many shortcuts to features without icons as they will not be visually distinctive.
When shortcuts are added to the Quick Access Toolbar, their associated shortcut keys are added with them. However, if the original feature is found within another category (e.g. Quick Find is under Office > Inventory > Quick Find), only the final shortcut key must be typed after hitting [ALT]. So if you added the Quick Find feature, you can access it by typing [ALT]  instead of [ALT] [O] [IV] .
To remove shortcuts from the Quick Access Toolbar, right-click on the shortcut icon and select Remove from Quick Access Toolbar. This will remove the shortcut but will not move or change the original feature.
The Ribbon may be minimized so it does not permanently appear on the screen, but only when one of the tabs is selected. To do this, right-click in the ribbon and select Minimize the Ribbon.
You may alsoc click the small carrot on the far-right on the ribbon to minimize it.
To restore the ribbon to a permanent view, right-click again on an icon in the Quick Access Toolbar and re-select the Minimize the Ribbon option (this will un-check it).