Template
VIN Lookup
Use an API to decode a vehicle identification number
Industry:
Automotive
Function:
Inspections & Surveys
This app shows how to use a US government API to decode VINs to get information like the make, model, and year of a car.
This app uses sheet formulas to call the API, so you'll need to make a copy of it in order to see its functionality. Once you have a copy of it, try adding a new row through the form.
More information about the API is available here: https://vpic.nhtsa.dot.gov/api/
Generate some random VINs here: http://randomvin.com/
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
We've got two tables here: a form table and a lookup table. The form table is used to record VINs from the user. Then, the lookup table uses sheet formulas to call the API when the app is synced. Once it's synced, the form table can then use a LOOKUP formula to read in attributes like Make, Model, and Year (among others).
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...