How to implement functions written in Google App Script within AppSheer

[Jorge_Molina]

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 https://yamadapc.github.io/js-written-number/

Any help would be appreciated

[Bellave_Jayaram · Accepted solution]

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 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…

[Jorge_Molina]

Thanks!
I will study carefully your answer!.