LinkedIn
Twitter
I made a little template app to show how I am parsing data to give users feedback regarding data they have typed in. Here's a screenshot of the sample app:
https://www.appsheet.com/templates?appGuidString=0a3bd605-1297-48f4-90eb-5d4b95a99611
This sample app is just a tiny part of a larger app I am working on. In my main app, the numbers the user types in are incorporated into a URL that automatically searches an online database of movie screenplays for examples of how the words and expressions that she/he is studying have been used in the selected movies. The display of the movie titles in text is intended to confirm for the user that the correct numbers have been typed in and that the format is OK. The "database" of 176 movie titles is contained in a single cell of the spreadsheet and a rather complicated expression parses the selected titles and arranges them in alphabetical order.
I won't bother to try to explain the parsing expression here. I hope that presenting it in a functioning sample app will be enough.
I'd also like to point out that I discovered a rather strange bug in the AppSheet platform. This is what my spreadsheet looks like:
Actually, only the line with the key "Line1" should be necessary to the functioning of the app. However, while working on my main app I found that my parsing strategy only works if there is a line after the line that is actually doing the work. If you copy my sample app and then erase the "Dummy" key, I think you'll find that the movie titles disappear. Then, if you add a key for that line again, the titles should reappear. Very strange.
Finally, I'd like to add a little note about sharing sample apps as I have done here. A while back, I posted some instructions on how to do this:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-share-your-app-as-a-template-sample-app-v...
However, since then, the editing interface has changed slightly so I need to update my post. Now, in order to find the appGuidString you need to make your URL, you need to do the following:
The code after "start/" is what you need to construct the sample/template URL to share your handiwork.
