Hi guys,
Iโd like to make this features in App Sheet but I donโt know if it is possible.
In my DB (sheet 1) created with my app I need that every time that someone inserts or changes a form a new event accours.
This events send a mail only to the account insert in sheet 2 with a field equal to a field of the form .
If Itโs impossible can I call in appsheet an action made in app script that make it?
Thankyou very much.
Denis
AppSheet cannot invoke or use App Script.
What a pity!
Thank you Steve.
Do you think I can do it inside App sheet?
Best regards
Denis
You can do that with
But!
Only if changes on data are done by your application (to hit automation bots)
Or by API
Ok
โAny way except direct data changeโ
Let sumarize this
Thatโs one of the many things that can be done using bots. Now, by โformโ do you mean the record/row?
Can you post a screenshoot? This seems easy but Iโm not sure if I understand what you mean.
If your โsheet 2โ is like a user table and some users have certain roles (for example, โadminโ) and an email column, you can send the email to the row/user/email that matches the โadminโ role.
As @Steve said, AppSheet and App Script are different things and there is no direct integration. Now, if you are familiar with App Script (Iโm not) you can check this post
Dear Oscar,
thankyou for your time.
In red my answers.
| SkrOYC OscarYC Regular
November 13 |
- | - |
Let sumarize this
1.
Denis_Dal_Soler:
In my DB (sheet 1) created with my app I need that every time that someone inserts or changes a form a new event accours.
Thatโs one of the many things that can be done using bots. Now, by โformโ do you mean the record/row?
Yes I mean a new record (row in sheet 1 )
2.
Denis_Dal_Soler:
This events send a mail only to the account insert in sheet 2 with a field equal to a field of the form
Can you post a screenshoot? This seems easy but Iโm not sure if I understand what you mean.
If your โsheet 2โ is like a user table and some users have certain roles (for example, โadminโ) and an email column, you can send the email to the row/user/email that matches the โadminโ role.
I try to explain the features. When a user insert or change a record in sheet 1 by the app he inserts a field too selecting from a data list (Es. hobby โ sport, music, etc)
The event, generated inside a bot, should send an email to all the other users present in the sheet 2 that have the same hobby and the email inserted in their own row.
3.
Denis_Dal_Soler:
If Itโs impossible can I call in appsheet an action made in app script that make it?
As @Steve said, AppSheet and App Script are different things and there is no direct integration. Now, if you are familiar with App Script (Iโm not) you can check this post
Ok Iโll read it.
I thought that i could generate an event in apps script when the sheet 2 raw were modified. In this event i can check the sheet 2 with a if then condition on the filed โhobbyโ and send a mail when itโs true.
Gotcha, but we need to have a better insight of your tableโs schema in order to help
Thank you. I found the answer in your link to integrate app sheets and app scripts.
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |