Error Code 701 and 400 when working in templates

[KellySmith2]

Hello - I'm trying to build a form and when going in to grab the Quick Reference to help build my template, I'm getting the error message "701: An error occurred when generating field mapping json. An error occurred when querying data from the feature layer. 400: Cannot perform query. Invalid query parameters. 'where' parameter is invalid"

I created a new form and started copying over the data thinking it may be a glitch or small error in my template, and at first it was working but then as I got further into copying it, it gave those errors again. The weird thing is that if I delete lines in the spreadsheet all the way back to where it was working and republish, it doesn't start working again. 

Anyone have any ideas of what could be causing these errors? 

[CodyPatterson]

Hey @KellySmith2 

Would it be possible to link the problematic xls file?

Cody

[DougBrowning]

Usually using bad field names.  You should see little green boxes in any fields it does not like.  Posting the form would help.

[KellySmith2]

Here's my form that has the issue... hopefully that helps! 

[DougBrowning]

Looks like you have been copying in from another excel sheet and breaking the validation formulas.  I see it asks me to update right away from another sheet and that is bad.
Mostly it ruins all the built in checking. When adding to a new sheet you can see the errors marks right away.

Arc cannot have a field names with a period in them.  See the green marks telling you the issues.

You Always, Always want to use Right-Click Paste Values when putting anything into a 123 Excel file.  It can be hard to remember when crtl-c, ctrl-v is hardcoded in your brain.

I also see your media images have spaces in the names.  That used to not work but not sure now.

I would rebuild your sheet at this point.  I had a write up on this somewhere.

Basically make a all new form and copy that excel to your current survey dir.  Rename the old one to OLDName.xlxs.  Rename the new copied in blank sheet to the original excel name.  Copy each row over make sure to use Paste Values each and every time!  Note if the columns match perfectly you can do all but the top row at one time.

Then rename those fields with the period.

Hope that does it