Creating a Bot

[Mayur_K]

i have 2 tables.

1. task- i have added it as form format 

2. task manager- i have added only to show pending or done tasks

now i want to create a new bot which will call a script to run automatically whenever any new task is created how to do it. the problem is i have script in TM table which is not added to appsheet.

[WillowMobileSys · Accepted solution]

---

@Mayur_K wrote:

the problem is i have script in TM table which is not added to appsheet.

---

You are referring to Google Apps Script?  And by "TM table" I assume you mean you have an Apps Script included in the Google workbook used by your app?  Yes?

If yes, then below is an example of how to setup a script call that returns a value (note there are a few return value settings not shown but should be self-explanatory)

I hope this helps!