Hyperlinks in Grids?

[Bette]

I have a grid, where among other things, I have the foldername of other requests. Is there a way to set this column in the grid to be a hyperlink, so they can just click on it and it will open up the folder they want to see? Right now they have to go the their to-do list to review it.

Thanks.

Bette

[TKLam]

I'm not sure if there is another easier way to do what you are asking for but what you can do is pre-build your URL in your SQL statement:

• Select '<a href="URL">' + 'Folder Name' + </a> as openURL FROM  ...........

Hope that helps.

[BMellert · Accepted solution]

You can also make your grid a "folder" grid (under Grid Type on the Do This tab).  This will open the associated folder when clicking on the row.  The first column (generally hidden) needs to be the folder ID, but the rest of the row can be anything else displayed.

[Bette]

Thanks for your suggestion but I decided to try BMellert's suggestion of making my grid a "folder" grid (under Grid Type on the Do This tab). 

[Bette]

This works so thanks for the suggestion of making the grid a "folder" grid (under Grid Type on the Do This tab).  The only issue I had is that now the grid is not editable. There was a column in the grid that we wanted the user to set the status of the record. So we ended up having two grid on the form. If there is another way to do the same thing and to make the grid editable, I'd be interested in learning about that.

Thanks so much!