Creating html page in appsheet automation

AppSheet AppSheet Q&A
, ,
1

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?

2

Steve_0-1727099308148.png

What does line 76 of your template file look like?

1 Like
3

it’s a javascript

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

Not sure why this is an issue.

4

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

5

@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.

1 Like
6

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

'[name="link"]'
7

@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?

1 Like
8

Use Start expressions in templates