Skip to main content
R23802814naru
Participating Frequently
Mar 30, 2022 3:56 PM UTC
Question

Another Acrobat to Google Sheets post

I've read multiple posts about this - which helped a lot but...

 

I'm having...odd issues...I have a Google Form and Sheet. I've copied the field IDs using Get Prefilled link. I'm trying to get this to work with a short form - 6 fields...text, integers, and a date. I'm up to about a dozen trials submitting it. When I submit I always get a timestamp but only the first field (L Name). In Acrobat, the fields are named "entry.xxxxxxxxx" - matching what I get from the prefilled link. In the prefilled link the reference is: "entry.498728576=Weasley&entry.238933929=Fred&entry.672957676=2011-11-11..." I tried entering the ampersand both before the second field and after the first field. I received a General Error. After removing the ampersand fields 1 and 2 were sent to the Sheet???? Did not make sense, but I tried that with field 3 with no positive result.

 

When all 6 fields in Acrobat are named "entry.xxxxxxxxx" I get a General Error message.

 

What am I missing?

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

Test Screen Name
Legend
Mar 30, 2022 10:36 PM UTC

Ampersand isn't part of a field name nor a field value. It's the separator between fields. 

Translate
R23802814naruAuthor
Participating Frequently
Mar 31, 2022 12:37 AM UTC

Yeah - I know that, but in trying to get more than the first field to populate I was sort of throwing spaghetti against the wall. It was coincidence that the second field populated after putting in and taking out the ampersand.

 

The real question is why the second field populated and why fields 3 through 6 do not populate. The fields are all named "entry.xxxxxxxxx"

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices