I'm writing a script to autocomplete some fields in a Google Form based on a field that has started to be filled out. For argument's sake, let's say it's address. So when a user fills the form out like so:
And if in a spreadsheet called defaults there is a row with this address:
Not only that field is updated, but any other fields that match are, too (like name and email).
Does anyone have any suggestions for me? My research has turned up nothing too useful for this case.
