Re: Iframe not displayed in bot automation email

Arnocode · 06-11-2024 05:37 AM

Hi,

I am trying to figure out a viable workaround to the 'read receipt' functionnality as it does not exist in Appsheet. Apps script is apparently not giving us this option either. That's why i thought of using the "Embedded app view" option in a bot to ask the recipient to just save a form already filled with his email adress. However, I did not successfully set this bot as the trigger is a condition based on another table. In concrete terms :

Table A is the main table of the app. When a user fill a new form on this table, it should trigger the bot. The bot should then send an email to a list of people (using Google groups) to notify them of the new record. Now, I want to know if they read this email. That's why I need table B.

Table B is needed to store a ref to table A, a timestamp and the email of the person who read the email. The goal is to add a line everytime someone clicks on a button embedded in the email. The first issue I faced was that it seems like I can not embed the form of table B on an email triggered by table A. That's why I thought of using an Iframe of the table B form in table A email. It does not cause any error, but nothing appears in the received email.

I tried these iframes (including one random youtube video to see if the issue was with the link I provided) :

Anyone know how to make it work ? Anything that could achieve the purpose of knowing who read the email and when is more than enough.

Aurelien

Hi @Arnocode

@Arnocode wrote:

The goal is to add a line everytime someone clicks on a button embedded in the email. The first issue I faced was that it seems like I can not embed the form of table B on an email triggered by table A. That's why I thought of using an Iframe of the table B form in table A email. It does not cause any error, but nothing appears in the received email.

Did you try using the embedded app email? This works with a detail view type, and quick edit columns.

That would avoid having to try building an iFrame.

For reference:

Send embedded app view email from an automation - AppSheet Help

Arnocode

Thanks for the suggestion. The issue with the embedded app email is that I wish to integrate table_B_Form in an email trigerred by table A and it seems to be impossible. Am i wrong about it ?

I could send a link in a custom email but it requires the recipient to actually read the content of the email, click on the link, wait, save the form once it's done loading... it takes too long.

Aurelien

Table_B_Form is probably for creating a new record?

If so, I would suggest to create a new record on your own, then send a detail view for this record with all fields on quick edit option to your user.

VarunChandran

Even if you are triggering the email with table A still you will be able to choose the Table B form for embeded View