In this document, we will be going over how to use an address field to display a static street view thumbnail.

 

First, let's go over the fields that are required for this to work

 

  1. Address
  2. Text Formula A
  3. Text Formula B
  4. Street View Source (Equation Field)

 

sQ4PEJ2OkrJXsEykWRqunMnNTjwa3wZEwQ.png

 

1. The Address Field

For the address field just make sure to include the Address, City, State, and Zip

lns7kWMFO9nnuk6QcJ40JeJD2jFw4LDcPQ.png

2. Text Formula A

For this field, we'll need to paste the following text:

https://maps.googleapis.com/maps/api/streetview?size=2400x2400&location=

_sF2Ut2VpwQuSymXatY9x8h3RSklumBTiQ.png

3. Text Formula B

For this field, we'll need to paste the following text:

&source=outdoor&key=AIzaSyByjIXK2_OHN-r7sxlFcrUUMfxNIv7rSl0

zJuQHZh0nD_ltp_2BbqOvVGXHW2BJDldRA.png

4. Street View Source (Equation)

For this field, we'll need to use the Text Function Concat()

SQL
CONCAT({Text Formula A},{Address - Address},{Text Formula B})

KSTVc0x6W3QoZxKZrP1TJTOqnhQwspHYzQ.png

Now that we have all the necessary fields we can add our table component with our addresses and include a details page where we will display our static street view picture. 

(Learn more about adding tables to your page here: https://support.tadabase.io/support/solutions/articles/44000823162-adding-tables-to-your-page)

 

On our address Detail page, we will add an HTML componentBdHidXB-ibnsuqOTOAdrn4PeLpsnoeI8yQ.png

Next, let's add the following to the Source code of the HTML component

HTML
<p><img src="{!!Street View Source!!}" alt="" /></p>

p5DH8ZYNL4GS1aKjRIAACe7CY3zMSXJHJw.png

And now as you can see in the GIF below, we can enter an address and then view the street view on the details page!

 

5jduzy7t8utI3qRtWTmlAGlNismm85hALA.gif