META POST: URL Parameters for other Google Services!

[GreenFlux]

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 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... Ensure your start/end dates/times value is in this format like this example: 20190127T224000Z/20190320T221500Z …

Gmail

CC and BCC for Start Email action 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.e... [EDIT] This only works for Gmail, but I think there’s a similar URL paramete…

Google Maps

Map in email template not usable 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 Tips & Tricks 💡

Nice man!

Google Voice

Initiate calls from Google Voice 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 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 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 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: "https://www.google.com/searchbyimage?&image_url=" & ENCODEURL(CONCATENATE( "https://www.appsheet.co…

YouTube

SAMPLE APP: Countdown Timer Using Youtube Video & URL Parameters for Start Time 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

DETECTED – 22 Feb 13

Google Search URL Request Parameters

Latest update: 2016 May 3 You may already be using advanced Google Search operators like inurl: and ext: and site:, but here is a chance for you to sharpen up your search efficiency even further. D…

https://output.jsbin.com/xujuluw

http://kalinka.tardate.com/

Learning in Hand with Tony Vincent

Google Document URL Tricks — Learning in Hand with Tony Vincent

By replacing /edit in a Google document's URL, you can do some pretty nifty tricks! You can transform a shareable link into a Preview, Make a Copy, Template, or PDF link.

---

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.

[GreenFlux]

Here’s one for YouTube URL Parameters:

SAMPLE APP: Countdown Timer Using Youtube Video & URL Parameters for Start Time 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…

[Wesley]

I use this to generate a show type url link in a form for a dispatching app that already had 2 addresses input. The link opens google maps in browser or mobile and gives round trip directions from static location A (warehouse) to B (pickup) to C (delivery) back to A. I click the link, copy the estimated round trip driving time into the App, and use it for a price estimation along with other factors. It’s nice to have instant routing not requiring a sync back to Google sheets with a script for finding the routed distance.

Google Developers

Get Started  |  Maps URLs  |  Google Developers

Maps URLs provide a universal URL scheme to launch Google Maps from any platform.