Analytical App About Crime Across The Pond.

What a Fun Time

Getting the API to work was actually the easiest part. Very simple and easy to understand

a simple connect

Now to make the date Dynamic

add a replace formula to the URL's date section and it will put in the user's date

now to allow them to change the category

I Removed the "-" from the category section so the user can type in the crime normally.

Now to add in Postal Code Funcanatility

A file with all the postal codes in the UK with the Longitude and Latitude.

Created a Google Sheet Output so the data will change as the user puts in the Information

Created a Google Sheet on Drive Then Made Sure it will override it when outputting

Final Flow

Dashboard

Author:
Yadwinder Pannu
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab