2. The URLs in my spreadsheet responses are missing

*** A new version of this article is available on this page ***

Why doesn't Form Publisher write the URLs in my spreadsheet responses?

If you received an email informing that Form Publisher failed to write in your spreadsheet, it might be because of the following reasons:

• You have added another row before the first one that contains headers that are automatically created by Form Publisher

• You have changed the names of your headers (questions, timestamp)

• You have several tabs in your responses spreadsheet, and your responses are not in the first tab

This can cause troubles to Form Publisher, which will stop functioning because the add-on is waiting for the proper information. Specifically, the named ranges from your spreadsheet are not well-defined anymore.

What shoud I do?

To solve this issue, please follow this tutorial:

Step 1: Open your spreadsheet, then go to Date > the 'Named ranges...'

Step 2: Clic on the appropriate cell (the header) and add a new 'Named Ranges' for the columns with these specific names:

You can find the FORM ID in the URL of the Google Form:

https://docs.google.com/forms/d/FORM_ID/edit?usp=drive_web#responses

In this example, the Named ranges for the timestamp is :

FormPublisherTimestamp1yeieX42b3Kb9OGPodGCevRIaRGvUmErh_w7JoyZX5I