LinkedIn
Twitter
Hi,
I've searched the forum and I'm still stuck.
I have an XY Map view called layouts which works as desired and is shown below. This view generates when a button-based action fires in the app. Here's the expression in that action: LINKTOFILTEREDVIEW("Layouts", [id] = [_THISROW].[id])
Here's my issue.
When I run a bot to generate an email, with an HTML template, the bot works, sends the template, the data in the template table is correct, except for one thing... The SNAPSHOT() function shows a blank app screen as shown below.
This is the line of code I'm using in the HTML file to call the XY MAP view. I don't get any errors. It's just a blank, as if there's no data...?
I have set the bot to bypass security filters.
<<SNAPSHOT(LINKTOFILTEREDVIEW("Layouts", [id] = [_THISROW].[id]))>>
I've been banging my head on this thing for some time now and, I'd be very grateful for some help here.
@Fabian_Weller, your name keeps popping up in the forum for map stuff so I've cheekily tagged you. Hope that's OK.
Many thanks in advance... ๐
Solved
1 ACCEPTED SOLUTION
Generally , your expression seems to be good.
I tested with the following HTML code in the email body and it works.
<html>
<head>
</head>
<body>
<<SNAPSHOT(LINKTOFILTEREDVIEW("Orders_Detail", [Order id] = [_THISROW].[Order id]))>>
</body>
</html>
Of course view name and column name were different in my testing. You could suitably replace as below
<html>
<head>
</head>
<body>
<<SNAPSHOT(LINKTOFILTEREDVIEW("Layouts", [id] = [_THISROW].[id]))>>
</body>
</html>
The email sent properly captured the snapshot image in my testing as shown below.
Hi @Suvrutt_Gurjar ... I'm still bumping my head against this thing. I can get the view to show in my HTML template, but it just doesn't seem to hold any row data...? Here's a detailed look at my setup... ๐ค
I have a QA APPROVED VIEW
Which looks at the QA APPROVED DATA SLICE of the surveys table.
Here's what it looks like in the app:
When I click on the inline bulb icon, it fires an action to update to the [trigger] column in the surveys table.
Here's the associated trigger action.
I have a test_approved_BOT that is listening for the following condition:
AND(
[QA_status] = "QA Approved",
[_THISROW_BEFORE].[trigger] <> [_THISROW_AFTER].[trigger]
)
When the condition is met, the bot sends an email:
The bot uses an EMAIL BODY TEMPLATE that points to an HTML file:
.../AppSheet/data/Pre-Installation-CRMS/Templates/test.html
Here's the HTML file:
<html>
<head>
</head>
<body>
<<SNAPSHOT(LINKTOFILTEREDVIEW("Layouts", [id] = [_THISROW].[id]))>>
</body>
</html>
The bot runs without errors, sends the email, processes the html template, shows the Layouts view in the body of the email, but produces an empty-looking result shown here:
The action/bot combination gives me the wrong result but I get the correct result when I fire the action manually in the app using an MAP VIEW action icon from the detail view.
The MAP VIEW action icon goes to another view within the app:
LINKTOFILTEREDVIEW("Layouts", [id] = [_THISROW].[id])
And produces the correct result... i.e. a pin on a map
This is the view I'd like to see in my HTML email body template.
The head scratch is that it works when done manually but not via the action/bot combination.
I've very stuck right now.
Hope this makes sense.
I don't know what it could be since it worked for another user.
Check to see if the problem is the included characters. The user for whom it worked changed the << >> and others for characters &:
I think the problem is the limitation that a bot has in handling calls to view presentations.
Perhaps a solution would be to generate a preview image of what you want to present in a column and put said column in the HTML instead of calling LINKTOFILTEREDVIEW()
Hi @jakenaude ,
Thank you for all details and sorry for a bit late revert as I wanted to test with exactly similar condition as yours , meaning with an XY column based image. My yesterday's testing was with all similar conditions as yours but LINKTOFILTEREDVIEW() applied on a general detail view and not a map view.
My current testing with both Google map view and an XY image based column still give correct results in the email body. Please see the SNAPSHOT() produced on a XY image testing.
The image of the email body received through bot is shown below. The test background image of the XY column of a soccer field is with dark green background so it is a bit difficult to see the map pin. So I have highlighted it with a red circle.
All in all, my testing with XY column is successful.
At this point, would you please mention how the table/slice used for the "Layout" view is related to the "Surveys" table?
Hi @Suvrutt_Gurjar... Your extensive testing and perseverance is much appreciated... ๐
I will go ahead and also test this approach: LINKTOFILTEREDVIEW() applied on a general detail view and not a map view
The Layouts view uses Layouts slice on the surveys table, and has an updates and adds relationship.
@jakenaude wrote:
l but I'm failing to show the XY image and the pin in there.
Hi @jakenaude ,
I am afraid, as per my understanding, you will be unable to show the XY image and pin in the detail view. I had mentioned detail view just to test the SNAPSHOT() function works in the HTML template when I started responding to your post, As a side note AppSheet help documents mentioned that displaying XY column image in a template is not possible.
Display Address, LatLong, and XY values in templates - AppSheet Help
So your workaround of using SNAPSHOT() seems to be good approach to overcome above limitation.
To clarify , I think we tested the issue in two steps
1) To ensure SNAPSHOT() works in HTML template: this was established by testing a detail view with SNAPSHOT() in HTML template
2) SNAPSHOT() with map view works in an HTML template. My testing showed that it works with map view as well. However we are unable to get it working in your setup even though our settings and approach seems to be similar.
Hope I could explain.
"...one request to you will be to base the "Layouts" view also on the slice "QA Approved..."
@Suvrutt_Gurjar, you are a rock star dude...!!! Thanks for not giving up!
Pointing the Layouts view to a new slice did the trick...!!! Here's the result... ๐ ๐ ๐
