Skip to main content
R
R23802814naru
Participating Frequently
March 30, 2022
Question

Another Acrobat to Google Sheets post

  • March 30, 2022
  • 1 reply
  • 388 views

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 has been closed for replies.

1 reply

T
Test Screen Name
Legend
March 30, 2022

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

R
R23802814naruAuthor
Participating Frequently
March 31, 2022

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"

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