Form Designer - Data Grid - help adding URL link

Help Studio
,
1

Hi,

I’m new to the Form Designer and I’m having trouble trying to display a URL link in the grid.

Background:
I’m stripping a data grid from a web site and storing it in a DataTable. I’m trying to display some of the columns from the data table in the Data Grid and allow the user to click on a link in a row to visit the web site. The user can then decide if they want to delete the row. When they’re done, they click Submit and I’ll write the results to an Excel file.

I’ve configured the Create Form activity to pass in the DataTable in the FormFieldsCollection and unchecked the GenerateInputFields. My understanding is that this binds the DataTable to the grid.
image

I’ve added columns to the Data Grid:

image
image810×237 16 KB

Issues:
The first issue I have is that some of the DataTable column names have spaces, etc. (eg. “Date / Time”). When I try to add the value to the Field Key, I get the “only alphanumerics” error so, for the time being, I’m only displaying columns from the data table that work. Is there a work-around or do I have to rename all my dataTable columns?

The second issue I have is trying to populate a column with an HTML link. One dataTable column is a string containing the URL (eg: http://www.google.com). I’m using an HTML Element Component and trying to configure it to display the link. I’ve set the Field Key to be the dataTable column name (“Title2”) and configured the Content to use “{{row.Title2}}” in the HRFEF. That works but opens in the form instead of in a browser. That wouldn’t be too bad, but I don’t seem to be able to get back to the grid. In that case, I think I may need to go with using a button and opening the link in the “Do” part.

If I have to use a button, how do I pass the URL through to the Do block. I think all that comes through is the text for the button that was clicked.

I hope this makes sense to someone.

Thanks,

Carlo.

2

Hello @carlor!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff