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) :
<iframe src="https://www.appsheet.com/preview/myAppId#view=Accuse_reception_Form" width="320" height="568"></iframe>
<iframe src="https://www.appsheet.com/start/myAppId#view=Accuse_reception_Form" width="320" height="568"></iframe>
<iframe width="560" height="315" src="https://www.youtube.com/embed/ICRS0rqO4xs?si=ReIVr3zQK_o2tHdH" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin"></iframe>
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.
User | Count |
---|---|
16 | |
11 | |
5 | |
5 | |
5 |