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

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

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