Is there a way to validate entered data against a google spreadsheet to create an action? For example - Looking at a spreadsheet of Suite Numbers (1XX - 3XX). If user enters a 3 digit number (i.e. - 110), check the spread sheet to find that number and return data based on that entry. Looking at creating a wayfinding Kiosk to allow user to enter suite number and will return department location.
Any help or direction would be greatly appreciated!