Details Page Settings

Show Details Page

When checked, a details page will be shown when a user clicks on a row. Otherwise, no details page will be shown.

Column Index of ID

This number defines which column in the Google Spreadsheet contains the unique identifier for the details page. The index starts at 0, so column A in the Google Spreasheet is index 0, Column B is index 1, etc.

The ID ensures that the correct values are pulled from the correct row as the FSDL dynamic builds the details page.

The value used as the ID also forms part of the URL of the details page. It is recommended that the values in this column are URL friendly text. That means they observe the following rules:

• All lowercase.
• No spaces, use hyphens instead.
• Meaningful text, not just achronyms and not numbers.

Page Title

This option defines how to handle the page title on the details page.

• No Page Title: Will remove the page title from the details page.
• Yes, Set to column value: This will set the title to the value that is present in the column specified in the Column Index of Page Title field below.
• Yes, Use same title for all detail pages: This will set the title of the details pages to the same text specified in the Static Page Title field below.

Column Index of Page Title

This number defines which column in the Google Sheet contains the page title for the details page. The index starts at 0, so column A in the Google Spreasheet is index 0, Column B is index 1, etc.

Static Page Title

This text defines what will show as the page title for all detail pages.

HTML

Edit the HTML template within this field to construct the details page. Use variables defined by the variable map within the HTML markup to dynamically display values found in the data source. These variable are contained within curly braces, for example {NAME} or {EMAIL}.

HTML Variable Map

This field allows you to create custom variables to use in the HTML template. These variables can be linked to columns within the Google Sheet so that they are replaced by data from the sheet when the details page loads. 

Each variable needs a unique name or key, and the index of the column containing the data to return. Use a colon to link the key with the index. Use a comma to separate multiple variables.

Example: FIRST_NAME:0, LAST_NAME:1, EMAIL:2, etc,

Add as many comma-separated variables as required within the text field. Curly braces are not used when creating the variable map but remember to wrap the variables in curly braces in the HTML template, for example {FIRST_NAME}.