What a Fun Time
Getting the API to work was actually the easiest part. Very simple and easy to understand
a simple connectNow to make the date Dynamic
add a replace formula to the URL's date section and it will put in the user's datenow 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 outputtingFinal Flow
![](https://www.thedataschool.co.uk/content/images/2022/09/image-468.png)
Dashboard
![](https://www.thedataschool.co.uk/content/images/2022/09/Crime-Dashboard.png)