Tables

This Form Field will show a table editor at the Buyer Side where the Buyer can enter data and add or delete rows.

or each column you can define:

• Name - must be a unique name without spaces.
• Data type - can be a string, number or boolean (which will show a check box).
• A list - of possible values to present in a drop-down to the buyer (except for boolean which will always show a check box).
• Width - for the column in pixels (this will be ignored for boolean columns as they only span the width of the check box).
• Row - can be set to display multiple input fields in the same row on the Buyer Side.
• Hide - allows you to hide rows on the Buyer Side table display. The row details will be visible when selected by a user for editing.
• inline the column will be shown editable at the Buyer Side without the need to select the row. Be careful: If all columns are marked inline, it gets hard for the buyer to select the entire row. Its recommended for a specific column like “price”. Also when you have only 2 columns it can be handy to select all of them, so the user does not need to select the row before editing its values.

The row column is used to numerically define rows such as type and price as in the example above. This will display both rows as a single row that lists, for example, a pizza and its price. Multiple rows can be assigned in this way.

Rows are also sortable on the Buyer Side. Buyers can add, delete, and rearrange their data table entries. Buyers rearrange rows in the Form Field by simply selecting the table header badge or manually drag-dropping the rows to their desired position:

Once the columns of the table are defined one can add default values by closing the properties dialog and pressing the + on the top-left of the table then entering values into the newly created row(s). Once finished entering the default values, press the Apply button below the table.

Add and remove Rows

You can use the Plus Icon on the left to add a row at the end of the table.

Or the Plus Icon on the right of a row to add it a row underneath.
Here you can also remove any row by clicking on the bin.

Sorting the Table

If you click on the small arrow on top of the table a drop down menu will open. Here you can now sort the Table form A-Z or from Z-A.

In the Context Menu of the Table you can sort it from A-Z only.

Copy and paste JSON

Internally the values of a table are represented as an array of row objects and their named properties. You can also export and import the values in a table as a JSON string via the context menu of the Form Field.

Select Copy JSON and the content of the table will be copied to the clipboard in JSON format. The above table will look like this:

[{"event":"Holiday","text":"New Year's Day","day":3,"month":1},{"event":"Holiday","text":"Good Friday","day":15,"month":3},{"event":"Holiday","text":"Easter Monday","day":18,"month":4},{"event":"Holiday","text":"Early May Bank Holiday","day":2,"month":5},{"event":"Holiday","text":"Spring Bank Holiday","day":2,"month":6},{"event":"Holiday","text":"Boxing Day","day":26,"month":12},{"event":"Holiday","text":"Christmas Day","day":27,"month":12},{"event":"Birthday","text":"Peter Müller Birthday","day":26,"month":12},{"event":"Birthday","text":"Gabi's Birthday","day":1,"month":1},{"event":"Birthday","text":"Hans' Birthday","day":4,"month":1}]

Now the table contents can be edited and (by selecting Paste JSON) copied back into the table. Note that if one adds a property in the table which currently has no column, the table control will not display it until you add the respective column.

If you are using the copy and paste option in the Table Properties Dialog Box you will get a different result. In this case the function refers to the structure of the table - not the content.

In this case the result will be:

[{"values":["name","","string","type-a,type-b","75px","1",false,0,false]},{"values":["price","","string","","50px","1",false,0,false]}]

Please read more about tables and the use of scripting in the scripting section.

Table Filtering

You can filter your Table by another Select-List. First set up a Select List with the values of one of the columns of your Table. The values in the Secelt List are now used to filter down your Table.

You enable the filtering in the Properties of your Table. Click on the small plus icon on the bottom of your Table.

An input line will open where you can choose the Table Column which should be filtert:

And the Select List you would like to sue for filtering.

For the Select List you get shown it Label Choose, its Name option and the Value of the first row item.

Multi Select Mode

This feature reads data from a corresponding Table Form Field and allows the Buyer to select multiple values from it. Like in our example “Italian Menu” the Buyer can not just add new dishes but in addition also add the additives for each single dish. The List of the additives is a corresponding Table of the List of the dishes.

The first Table Column represents the value, the second Table Column contains the label shown to the Buyer. Like shown in the screenshots, value is the number “1,2,3, …” and the additives name is in the second Column of the table.

At the Buyer Side the values of the List could be selected by activating the checkboxes.

The Multi Select Mode can simply be activated by writing “multi:” and the name of another Table Form Field in the list column multi:[table-form-field-name].

The Multi Select Mode is dynamic. The buyer can change the selection but also edit the list of values itself.

Click here to open the example document

Connecting Data

Within the Printess Editor you can load data from a Google Sheet (Any csv or Excel can be loaded into a Google Sheet.) This is a live connection through the link of the Google Sheet. So if you are changing the content of your Google Sheet these changes are available in the Editor as soon as you refresh the view there.

Before you set up such a connection please change the “Share Settings” of your Google Sheet to “Anyone with the link” first.

Click on the gear icon on the upper right to select the Option Show Database.

You will now find a dialog on the bottom of the editor. Copy the link of your Google Sheet and paste it in the input field to click on Load Data.

Now the loaded list is shown in the Editor and you can close it (1), refresh it (2) or delete it (3).

If you now place e.g. a Single Text Frame you can use the loaded data. Go to the Text Input Field of the select frame and remove the default text (1) to do a right mouse click in that field. Then you can choose a column from the list (2) to personalize the frame.

You can now skip through the records to test it.
Such a Google Sheet link could also be used through the API to feed data to the Production File.

Internal Data

You can set up an internal data table which enables the Buyer to add records which could be used e.g. for Birthday Invitations.

Therefore set up a Table first. Click on the plus icon on the upper right of the Form Field Tab of the Resources Panel.

Open the Form Field Properties to:

1. Define the values of the column name (must be lower case)_ and the values of the column label. This column will be shown at the Buyer Side.
2. Remove the default values of the column “List”.
3. set both lines to inline so that they Buyer got the option to modify this Table inside the input field.
4. Save these changes.

Click on the gear icon on the upper right to select the Option Show Database.

You will now find a dialog on the bottom of the editor where you can choose the Table you would like to use.

If you now place e.g. a Single Text Frame you can use the data from this Table. Go to the Text Input Field of the select frame and remove the default text (1) to do a right mouse click in that field. Then you can choose a column from the list (2) to personalize the frame.