onFormSubmit

Deleted form entries in Google Forms still shows in my app 

I already deleted individual answers from Google Forms' Response tab. But I'm still seeing the deleted entries in AwesomeTable. What did I miss?

This is a Google Forms expected behavior. The Google Forms to Google Sheets - Form Response synchronization only works when new entries are added. However, if you delete individual or all responses in Google Forms, the changes won't be reflected in the linked Google Sheets datasource. Click here to learn more.

To bypass this Google Forms limitation, you could either:

• Manually delete the pertinent entries in Google Sheets or
• Unlink > re-link to an existing Form Response sheet destination. Then reload your map app.

onFormSubmit stopped working after adding items in Google Forms 

Why did the onFormSubmit stop working? All I did was just add new questions in Google Forms.

Adding form field(s) or question(s) in Google Forms will automatically insert new column(s) in the Form Response sheet. The newly-inserted column(s) will disrupt the onFormSubmit script by auto-populating the geocodes (latitudes and longitudes) in the wrong columns or fields.

To remedy this, either:

• Revert to a previous version of your datasource or
• Unlink then re-link your form, followed by redoing steps 2 - 4 of the Automatically Geocode Form Entries tutorial and selecting a new datasource containing the sheet with the re-linked and re-geocoded data.

Using multiple form fields to collect addresses 

Can I use 2 or more form fields (street, city, state, & country) to capture addresses in Google Forms?

The current version of the GeoCode add-on with onFormSubmit can only obtain addresses (partial or complete) coming from 1 form field (either from Short answer, Multiple choice, or Dropdown). This means that address from multiple form fields (with values stored in separate columns in Google Sheets) is not supported at this moment.

While we can't achieve exactly what you're after, we have a suggestion that might get you most of what you need. Rry using just a single form field (ideally a text box [Short answer]) to collect address and use the ArrayFormula() + Split() functions to automatically split the form entries into pertinent columns (street, city, state). This way, you can apply separate filters for the broken-down address fields.

GeoCode

Enter two or more addresses per record 

Will the GeoCode add-on work if I have two or more addresses per row or record?

It won't. Only 1 (partial or complete) address is allowed per row.

Pin or marker customization 

How can I customize my map markers (pins) like changing the color or using another image instead of the default red pin?

Geocode quota or limit 

Is there a limit on how many geocodes I can do per day? I ran the add-on and got this error message - Exception: Service invoked too many times for one day: geocode

There's a daily quota limit of 1,000 on the number of calls (for Gmail accounts) to the Google Geocoding service from each user. When you hit the limit, there's not much you can do but wait until the next day. The Geocoding quota clears / resets after 24 hours.

As an alternative, you can opt to share your Google Sheets file and use another Gmail account(s) to continue the geocoding process.

Increasing GeoCode limits

Can I avail of Google MAP API's pay-as-you-go billing to unlock higher quotas?

User subscriptions to Google MAP API's pay-as-you-go cannot be linked to the Geocode add-on. This means that the quota will still be 1,000 per day. As a workaround, you can either:

• Share your Google Sheets file and use another Gmail account(s) to continue the geocoding process.
• Or simply wait until the next day since the Geocoding quota clears / resets after 24 hours.

Service invoked too many times for one day: properties get?

Why am I getting the error message: Service invoked too many times for one day: properties get?

This is a known issue with the GeoCode add-on. We advise closing the add-on sidebar once the geocoding process & app generation is complete. When you hit the limit due to this error, we recommend waiting until the next day since the Geocoding quota clears / resets after 24 hours.:

One or more participants failed to draw()

Why am I getting this error message - One or more participants failed to draw(). Invalid column index 1. Should be an integer in the range [0-0]?

At least 2 or all of the Maps keywords are missing (MapsTooltip, MapsLat, MapsLong). This could be due to accidental deletion or another add-on was initialized that erased or replaced the Maps keywords.

To remedy this, either:

• Revert to a previous version of your datasource or
• Manually enter the pertinent Maps keywords.

Odd-looking map app 

My map looks odd and the markers don't work. What's causing this?

This is caused by typographical errors on your geocodes (latitudes and longitudes) either because you copy and pasted or manually entered the values.

To identify which row(s) are causing this problem, review your geocodes one by one to find out which ones are erratic or just do a quick scan on the format of your geocodes. Erring items are easy to spot since they usually have a different formatting used (background color, font size, color, and type).

Wrong format on the coordinates (latitude and longitude) 

The latitude and longitude given by the GeoCode add-on don’t have the right format (it’s showing “340736204” instead of the correct “34.0736204”) and the coordinates are not showing in my Map app either. How can I fix this?

We need to change the Locale to a country that uses decimal point because the GeoCode script generates the latitude & longitude (coordinates) using a decimal point ".".

Solution:
Follow the recommended steps below to remedy the Regional settings issue:

1.) Create a new blank sheet

2.) Select File > Spreadsheet settings > Locale > United States > Save settings

3.) Copy and paste your original data (without the Latitude, Longitude, & Parameters row: filters and map keywords)

4.) Run the GeoCode add-on > click the Geocode! Button.

5.) Click the CREATE MAP button - the coordinates and tooltips should display properly now.