How to implement functions written in Google App Script within AppSheer

AppSheet AppSheet Q&A
1

Hi there!
I have the need to do a number to text conversion within the app in order to convert currencies into spelled text i.e. 123 => “One Hundred and Twenty Three”

I have written (adapted) a Javascript function into Apps Script in my Google Spreadsheet and it works well, but I dont know how to get access to that function or how to write an equivalent function that would work with AppSheet

fyi my apps script function is based on js-written-number by yamadapc

Any help would be appreciated

2

You can trigger app scripts that are published as a web app from AppSheet (using workflow and webhook.) However, it is not possible to do so from inside a form - the script can run only after the form is saved.

For details, please read other posts in this forum starting with this:

[How to Integrate Google Apps Script & Trigger with an AppSheet App](https://community.appsheet.com/t/how-to-integrate-google-apps-script-trigger-with-an-appsheet-app/11805) Tips & Tricks ?

1 - INTRODUCTION Dear valuable members of the community, This post is my personal long-time promise to @praveen that I’ll write about nearly a year ago but couldn’t be able to keep my promise and spare some time because of our work load as an AppSheet Partner and Developer. Now I have found some time, I decided to write it down. Hope you can find a benefit of this post for your apps and/or projects. Before starting and diving any deeper, I should admit that this requires at least a beginner…

2 Likes
3

Thanks!
I will study carefully your answer!.

2 Likes