Hi Aaron - I think there are a couple things you could change:
1 - In my script, I have added an extra line as part of the function inWords – the if (!num) return “”****; – part, shown below, to account for any fields that might not include an actual...
Just figured it out!! For those who want to use this to update field SpelledNumber from field Number, this is the total of the code I used in the Scripting Block:
Note: 9,000,000 returns ninety hundred thousand and 90,000,000 returns nine crore, bot...
Thanks, Bill! I didn’t know scripting blocks existed, so thanks for the introduction! Also - I found a bug in the code you provided. The number 900000 was returning nine hundred, so I got a bit of help to fix that bug, and pasted the update below.
No...
Jeremy_Nash:
When I try to use this formula, I get an error. Has it worked for anyone else?
Yes I got it to work for me, but there are a couple things:
One problem is the quotation marks: Airtable needs quotation marks that are " rather than ”...