Launch a custom action with a if condition on the ...

Denis_Dal_Soler · 11-13-2021 08:03 AM

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

Steve

AppSheet cannot invoke or use App Script.

Denis_Dal_Soler

What a pity!
Thank you Steve.
Do you think I can do it inside App sheet?
Best regards
Denis

bonameblisto

You can do that with

But!
Only if changes on data are done by your application (to hit automation bots)

SkrOYC

Or by API

bonameblisto

Ok
“Any way except direct data change”

SkrOYC

Let sumarize this

1.

That’s one of the many things that can be done using bots. Now, by “form” do you mean the record/row?

2.

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.

3.

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

Denis_Dal_Soler

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.

SkrOYC

Gotcha, but we need to have a better insight of your table’s schema in order to help

Denis_Dal_Soler

Thank you. I found the answer in your link to integrate app sheets and app scripts.

Launch a custom action with a if condition on the other sheet

1.

2.

3.

1.

2.

3.