|
11.1.1b – Tables – Edit –
Configure Table Display – Select Page Display
The select page display tab is the default page
that will come up when you access the Configure Table Display area.
Most of the things you will need to edit to make your view look the
way you want it, will be on this page.
-
Rows on select page – Number of rows to
display per page.
-
Sort by on select page – Choose a field to
sort the rows that will be displayed.
-
Sort modifier for select page – Four sort
modifiers for the previously selected field. You can choose from
:
-
None - Standard alphabetic sort, ascending.
“A, B,C…a,b,c”.
-
Numeric – Standard numeric sort, ascending
“1,2,3,4…9,10”.
-
Reverse – Standard alphabetic sort,
descending. “z,x,y…Z,X,Y”.
-
Case insensitive – Alphabetic sort,
ascending, case insensitive “apple, Auto, Blue,
boy…”
-
Complex sort for select page – If the
previous sort options are not enough for you, you can specify more
sort options. These sort options DO NOT work in conjunction with
the previous simple options, rather they will override them. So if
you use this field, remember that it will be the ONLY sort options
in effect. To use this option, simply put a comma separated list of
fields that you want sorted into this text field. If you want
modifiers on the field, add a colon to the field, followed by the
modifier. For example, if you wanted to sort first on the price
field (descending), and then the description field, you might
put
price:r,description
The abbreviated letters for sort modifiers
are:
-
Numeric – n
-
Reverse – r
-
Case insensitive – f
%% a percent
sign
%c a character with the
given number
%s a
string
%d a signed integer, in
decimal
%u an unsigned integer, in
decimal
%o an unsigned integer, in
octal
%x an unsigned integer, in
hexadecimal
%e a floating-point number,
in scientific notation
%f a floating-point number,
in fixed decimal notation
%g a floating-point number,
in %e or %f notation
Perl permits the following universally-known flags between the
%
and the conversion letter:
space prefix positive
number with a space
+ prefix positive number
with a plus sign
- left-justify within the
field
0 use zeros, not spaces, to
right-justify
# prefix octal with "0",
hex with "0x"
number minimum field
width
.number "precision": digits
after decimal point for floating-point,
max length for string,
minimum length for integer
l interpret integer as C
type "long" or "unsigned long"
h interpret integer as C
type "short" or "unsigned short"
If you look at the example
above you can see that the price field is formatted with the (%.2f
align=right)which is precision, 2 digits after the decimal point
with floating fixed decimal location, and of course align
right.
-
Special Additions – Allows additional
related fields to be displayed. In the example, Qty Price, Options,
Up sell, Cross-sell, and promotion are among the selections. Can
only relate to tables which have records that are keyed with the
same SKU field as your current table. For example, the Promotion
selection ties to the promotion field in the merchandising table.
The merchandising table is keyed by product SKU’s. The
product table is also keyed by product
SKU’s.
-
More with alpha links – Displays Alpha links
instead of numbers on the More listings. Did
not work on Demo site.
-
More decade – This is the maximum number of
pages that will be listed before the word Next shows up in the
links. For example, if you set the rows on select page to 10, and
set More decade to 5, then the more links at the bottom of the page
would look like this:
More rows:
1
2
3
4
Next
Last
If you set More decade to 10 it would look like
this:
More rows:
1
2
3
4
5
6
7
8
9
10
Next
Last
And of course after any changes, simply click on
OK to put them into effect.
11.1.1c – Tables – Edit –
Configure Table Display – Edit Page
The Edit page tab controls how the edit page for
each record will look and act. For example, when you click on a SKU
from the main Table Edit default page, it will take you to an Edit
screen where you can work on the individual item you just selected.
The Edit Page tab allows you to control how this Edit screen will
work.
-
Fields to edit – Here is where you set up
the categories and fields that will be accessible for someone to
edit, when they click on the SKU field. A list of available fields
is displayed in the left window. You can create a title or category
to group fields in, by using the format shown in the example above.
Simply start the entry with an equal sign, and make sure that there
is a blank line before and after the entry. If you have chosen to
use tabbed
display then these titles or categories will each
become a tab page, and the fields will be displayed on this page.
If you have chosen not to use tabbed display, then the
titles will simply appear as a paragraph header, separating this
group of items from the next all on one page.
-
Buttons only on bottom – Did not work
that I could tell.
-
Buttons only on top – Did not work
that I could tell.
-
Custom View from field -
?
-
Form Profile -
|
|
11.1.1d – Tables – Edit –
Configure Table Display – Form Linking
The Form linking page allows you to add additional
table information, so that you can view and/or update information
from a relative table while you are editing the current one. For
example, in our products table example, you may want to know how
many of a particular item you have in stock. The products table
does not have inventory information, but the inventory table does.
So in order to see inventory information for the item you are
editing, you need to relate the tables so that information from the
inventory table can be viewed while you are working on the products
table. The Form linking page allows you to do this. Lets go through
each item and explain how it is used to link the tables, and then
we will display the results of our example below.
-
Table to link in cell – Choose the table
that you want to view related information from. In the example we
are using the Inventory table.
-
Column to appear before – This is where on
the page your linked table information will be displayed. In the
example we are putting the Inventory information before the
location where the Inactive field is displayed. See below
for results of our example.
-
Foreign Key – This is the key from the table
we are linking to that relates to the Primary key from the current
(products) table, or SKU in our example.
-
Label for linked table – This will be the
title that is displayed for the form you are creating. If you look
in the example below, you will see that the text “Inventory
Table” that we entered above, is displayed to the left of the
fields below.
-
Sort linked records by – If you had a number
of records that were related to each record in the current table,
for example if you had multiple product options for each product
such as size or color, then you could sort the records that were
returned. In our example, each product only has ONE corresponding
Inventory record, so we only get ONE record
returned.
-
Fields in table to link – Here you can list
the fields that you want to see returned. If you leave this blank,
it will return ALL fields from the table. If you want just a few,
as we have done in the example, you enter in the fields separated
by a space.
-
Allow auto_number in link - Need to understand better to
explain.
-
Field indicating valid row -
?
-
Number of blank rows – If you want to enter
additional records into the foreign table, say additional options
if this was an option table, you can specify how many blank rows
will be available. In the example we have left the field blank,
therefore defaulting to 1 blank row.
-
View to derive link display - ????
-
HTML style info for linked cells – This is
an area that you can use to enter in any special style you may want
for the cells you are creating. In the example, we just put a
background color in to emphasize what is being formatted. The style
info should be appropriate for a HTML <TD your_style_here>
</TD> type tag.
|
- Bring new information into the internal Interchange database
from an outside source, such as a text file.
– Export the data from
an internal Interchange database, to a file on the server. Which is
then available for download using File Transfer.
– Click on this link to upload a file of the
same name from your computer to the Interchange server. Warning – This will replace the
file located on the server … use with
care.
- Click on this arrow to download the
file from the server to your local computer.
