nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey 123 failed to submit incorrect syntax near the keyword 'WHERE'.

TimFlynn

Survey 123 Submit Error

Survey writes to an existing feature service with a related table. Had an earlier version working and then made a cleaned up version of the feature service and now I get this error. Any ideas? I've attached the survey form.

Also, is it possible to pass in data to fields inside a repeat?

survey123error.xlsx

BrianBaldwin_1-1656354850509.png

Trouver plus de publications taguées avec

Accepted answers

All comments

JamesTedrick

Hi Tim,

I don't see anything that stands out as being off in your form and test submission when published to a new feature service works correctly. One thing that looks unusual in the form settings is the submission_url - it has a /2 at the end of it. When you go to the form's Item Details page, do you see the link to the layer (and does it work correctly)?

TimFlynn

Hey James,

Thanks for the response! The "/2" at the end of the submission URL was my attempt at getting it to write just to the table in feature layer. Adding it, removing it, changing it, doesn't seem to affect anything. The feature service that the survey is writing to is in the form's item detail page and it links correctly.

I should have mentioned, the link I'm using to open the survey is

https://survey123.arcgis.com/share/c90196b0f27e4d0dbff1395ce87185ac?mode=edit&objectId={objectID}&center={POINT_Y},{POIN…

That's where I get the submission error. I'm wondering if maybe using the "mode=edit" might be the issue?

JamesTedrick

Hi Tim,

The /2 is not the way to set the appropriate table - the form_id ('UndergroundStorageTanks') setting is. Just to check, if you are editing an existing record, does it load correctly in the form (the error appears to occur on submission, not load)? Is there a reason you are passing the point location (wouldn't that already be in the record)?

TimFlynn

So I'm trying to add records to a related table. The /2 was an attempt to call to that table's ID in the feature service. When I've changed the form_id to the table's name, I also get an error. The point location doesn't need to be passed in either. But I've just been throwing everything at it to see what happens. I've tried both having that in there and not having it in there and it doesn't seem to make a difference.

I just can't seem to figure out this submission error at all though.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.