How to implement functions written in Google App Script within AppSheer

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

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:

2 Likes

Thanks!
I will study carefully your answer!.

2 Likes