Creating html page in appsheet automation

[vidhitashah]

I'm trying to create an HTML table in HTML page with all rows in table data. How do I achieve it? I tried to create an automation bot which would go and run periodically to create an HTML file. Now in doing so I realized

1. I cannot directly iterate over all the rows to create a string. So create a new sheet in the Spreadsheet to concatenate all the rows in one row.
2. Then I tried to run the bot using the process for Running a task to creating a file. 
3. In there I choose HTML file.

To test the bot, I'm trying to run bot and I get the error

Error 1 : Task 'Create File' Body template. Template could not be loaded due to exception: An error occurred while parsing EntityName. Line 76, position 36.

Can someone please help me here?

[Steve]

What does line 76 of your template file look like?

[vidhitashah]

it's a javascript 

var anchor = $(this).parent().siblings('td').children('[name="link"]');

Not sure why this is an issue.

[Steve]

Looks like you're going to have to figure it out.

[vidhitashah]

@Steve thank you, is there a way to have an escape character? because this here

'[name="link"]'

This is where the engine is thinking it need to replace with an Entity but technically it doesn't have it.

[Steve]

Maybe replace the single quotes with ' and/or the double quotes with "?

'[name="link"]'

[vidhitashah]

@Steve I was able to fix the issue by adding the tag name to avoid the error. I was able to generate the html but I'm running into a different issue now. When I'm creating the HTML, how do I loop through all the records in the data table? is it possible to do so?

[Steve]

Use Start expressions in templates