How to add a unique URL in each line of the Table reporting tool

markthor123

I am using the reporting tool to generate user-specific reports which are emailed to each person.  I want to include a URL in each line of the table.  How can I do this?  I know it is possible using the Report Text tool but cannot see a way to do it with the Table tool.

NicoleJohnson

Try the Text tool in the Reporting suite!

1. Create a field that contains your URL for each record that will appear in the table (by concatenating the base link address with whatever the unique identifier is that will point the URL to the specific file for that user)

2. Insert the Text tool before your table, and choose the first option to create a new field for the text

3. In the body section choose the hyperlink icon. Select the field containing what you want the link to appear as in your table (Site Name, for example) for the "Text to Display" option, and then choose the URL field for the "Address" option.

4. In your Table tool, deselect the field that shows just the Site Name and use your new Text field instead. Each record will then contain a hyperlink to the unique address tied to that record.

Hope that helps! Let us know if you need a little more tweaking!

NJ