DEMO of CB_LookUp
DEMO: Do a search for the serial 5CD60358BW or the user email email@example.com.
Scroll down to se the results.
This demo is running as me, so you don't need to authorise the script. In your own organisation, you should probably choose to let the script run as the user accessing, which is the best for logging purposes, but that also requires you assign your users proper admin rights.
Searching for a device by serial number or email address does a query in a previously created Google Sheets file.
The Sheets file is created with GAMADV-XTD3 and formated according to the new template for CB_Activity.
Normally you would have either a time triggered Apps Script or a scheduled GAM to keep the Sheets file updated. As this is a demo, the file is static.
You can always find my tools over on Github, linked top-right, but on these pages I also demo some of them.
My tools are usually completely free, but if you feel they have helped or improved your workflow in any way, you are welcome to PayPal me any amount you deem appropriate.