I just saw a great tip about creating Google Voice Links by @Peter and it got me thinking;
It’s time for another META POST!
Previous Meta Post:> META POST: Deep Links & URL Parameters
Google URL Parameters
This meta post will be a collection of Tips & Tricks for passing URL parameters to other Google services!
Google Calendar
[Enabling app users to add Google Calendar events from your app](https://community.appsheet.com/t/enabling-app-users-to-add-google-calendar-events-from-your-app/8858) Tips & Tricks ?
[image] With a few steps, you can create custom actions to add events to a Google Calendar: Create a URL type virtual column using the following URL format, utilizing ‘Event Name’, ‘Dates/Times’, ‘Details’, and ‘Address’ columns : https://www.google.com/calendar/render?action=TEMPLATE&text=[Event Name]&dates=[Dates/Times]&details=[Details]&location=[Address]&sf=true&output=xml Ensure your start/end dates/times value is in this format like this example: 20190127T224000Z/20190320T221500Z …
Gmail
[CC and BCC for Start Email action](https://community.appsheet.com/t/cc-and-bcc-for-start-email-action/31090/3) Feature Requests
This would be a nice addition to the Email action. As a workaround, you can do this with the ‘External: open a website’ action, using URL parameters to specify the To, CC, BCC and Subject: https://mail.google.com/mail/?view=cm&fs=1&to=someone@example.com&su=SUBJECT&body=BODY&bcc=someone.else@example.com https://mail.google.com/mail/?view=cm&fs=1&to=someone@example.com&su=SUBJECT&body=BODY&bcc=someone.else@example.com [EDIT] This only works for Gmail, but I think there’s a similar URL paramete…
Google Maps
[Map in email template not usable](https://community.appsheet.com/t/map-in-email-template-not-usable/35333/6) Questions
“https://www.google.com/maps/search/?api=1&query=”&encodeurl([Latlong]) “https://www.google.com/maps/search/?api=1&query=”&[Latlong] I tested with two different expressions to construct URL. With or without ENCODEURL() expression did not bring any different, both expression returned the expression which is clickable and jump to the Google Map with the latlong position as being passed as params. Working no problem on my environment.
[Sample App for route optimisation](https://community.appsheet.com/t/sample-app-for-route-optimisation/19968/2) Tips & Tricks ?
Nice man!
Google Voice
[Initiate calls from Google Voice](https://community.appsheet.com/t/initiate-calls-from-google-voice/38328) Tips & Tricks ?
This is a simple one - initiate phone calls in Google Voice on your desktop or mobile device using the following URL expression in an Action: =“https://voice.google.com/u/0/calls?a=nc,%2B”&[Phone Number] Works best if ‘Launch external’ is enabled. [image] Be sure the phone number includes country code - including a ‘valid if’ condition like the one below in your phone number column definition may be helpful to ensure users include a country code when they submit a new phone number in a form…
Google Meet
[How to click one button to call several persons by phone](https://community.appsheet.com/t/how-to-click-one-button-to-call-several-persons-by-phone/28670/13) Questions
AppSheet supports direct connections to Google Calendar as a datasource. And each event will auto-generate a meeting link if the feature is enabled: [Screen Shot 2020-07-31 at 5.25.04 PM] This link shows up in AppSheet when you connect the calendar as a datasource: [Screen Shot 2020-07-31 at 5.11.13 PM] [Screen Shot 2020-07-31 at 5.17.26 PM] Once you click the meeting link, you can add users by calling them. [Screen Shot 2020-07-31 at 5.21.32 PM] I think that’s as close as you can get…
Google Image Search
[Dynamically Create URL to Google Image Search Results Based on Column Values](https://community.appsheet.com/t/dynamically-create-url-to-google-image-search-results-based-on-column-values/20564) Tips & Tricks ?
I was looking for an easy way to help users find images to upload for one of my apps and found THIS BLOG that documents the URL search parameters for Google. I was able to make a button that pulls search terms from the record in AppSheet, and open a custom image search, with options set for image type, color, size, etc: [Screen Shot 2020-03-04 at 9.30.36 AM] [Screen Shot 2020-03-04 at 9.31.19 AM] This works for creating custom Google searches for News, Books, Videos, Flights, etc. In my cas…
[Google's Reverse Image Search from an Action Button](https://community.appsheet.com/t/googles-reverse-image-search-from-an-action-button/30618) Tips & Tricks ?
Google’s Reverse Image Search has an option to search from an image URL, instead of uploading an image. And images stored in AppSheet can be shared with a public URL– IF– Secure image access is turned OFF. SECURITY>OPTIONS [Screen Shot 2020-09-08 at 9.36.10 PM] By adding the public image URL to the end of the Google Reverse Image Search URL, a reverse image search can be opened from an action: “Google Images” & ENCODEURL(CONCATENATE( "https://www.appsheet.co…
YouTube
[SAMPLE APP: Countdown Timer Using Youtube Video & URL Parameters for Start Time](https://community.appsheet.com/t/sample-app-countdown-timer-using-youtube-video-url-parameters-for-start-time/39081) Tips & Tricks ?
There have been a lot of requests for a built-in timer/ stopwatch feature: Timers cant wait I have a task management app. I would like to Stopwatch Feature Others have created samples that add/edit rows to measure a duration: Simulate a Timer in your app But there’s no live countdown (or count up) on the screen. This sample app uses a different approach, to create a live countdown: The timer sheet just stores the duration, and a name for the timer. [Screen Shot 2021…
Other Resources
https://output.jsbin.com/xujuluw
I know there are plenty more, especially on Google Maps and Search!
Feel free to post other tips below, and I’ll periodically update the main list.