Latest Contributions by KristinThorpe1

I have a form to gather information about new projects. I want to use a search() function to generate two dynamic dropdown lists with possible companies and contacts from an existing Client table. The Client table is published to ArcGIS Online and shared publicly. Users will first select a Company from the drop down and the Contact drop down will filter based on the selected Company. Both of these selections appear to work properly in Survey123 Connect, but the Contact drop down does not populate with  values in the web app. I did get the Contact drop down to populate, but only when I defined a value as the search text and not with ${ExistingClients} like I need (attached). UPDATE: The Contact drop down only works if I specify a search text without a spaces. Ex: search(tableName, 'matches', 'Company', 'LIVIC') will work and populate with possible Contacts, but search(tableName, 'matches', 'Company', 'LIVIC Civil') or search(tableName, 'matches', 'Company', ${Company}) will not. I based the search() functions off a different form with the same parameters and workflow that does work in the web app, so I am not sure why this form is not working properly. The web app is behaving strangely and I'm not sure what else I can try to troubleshoot this issue. Any suggestions would be appreciated! The form was created in and published from Survey123 Connect version 3.18. ... View more

Hi! I want to add a new report template to create inspection reports; however, every time I upload a file and it checks the syntax I get this message, "Error: An error occurred when querying data from the feature layer. 400: UNKNOWN_ERROR Unable to perform query. Please check your parameters." The survey form was originally published by someone else in my organization, but I have since changed ownership of all layers and survey files to me. I republished the survey, changed the file name of the .docx template, verified the survey and form are pointing to the same data source, everything I could think of that basically "resets" the survey form. I also tried uploading the general sample template Survey123 automatically generates and I still receive this same error, which makes me think it isn't a syntax/parameter issue but a Survey123 issue.  This is not the first template I have uploaded for this form. The previous owner uploaded a template back in August, which works, but we need to update it with our new template (which I also tried - in the Manage Templates pane, I clicked Update Template for the template that works and replaced with the new .docx but still got the same error message). Has anyone seen this error or any issues like this recently?  ... View more

Why does report syntax have to be so difficult!? I just know this is going to be a silly solution! I am creating a report for inspections done in Survey123 and I keep receiving this error every time I try and upload my template: My template includes a summary section followed by individual records. To try and isolate the problem, I copied each section into a new word document and tried to upload just the summary section as a template, and just the individual section as a template. Guess what... they both worked on their own! So I'm not sure why they aren't working together in one document. I am attaching my report template. Any help is appreciated!    ... View more

Hello all! I have been struggling with this same problem for a few weeks and I need help finding a solution. I have built a survey and web app in Experience Builder for people to reserve pavilions in the town park. My survey has fields for the Pavilion (select_one), Reservation Date (date), Reservation Time (select_one: 10 am - 2 pm, 2 pm - 6 pm, 6 pm - 10 pm, or 10 am - 10 pm), and contact information. There is one major issue: There needs to be some sort of error or restriction so people do not double book the same pavilion for the same time frame (or if a pavilion is already booked 10 am - 10 pm). I originally used pulldata() and wrote a JavaScript to connect to my feature service and count the records with matching pavilion, date, and time from the user selection; if the count > 0 then it tells the user to select again. I finally got that working only to realize I can't use JavaScript in a public survey. Instead, I used the search() to generate a select_multiple list of Reserved Times from my feature service by filtering by the Pavilion and Date survey selections. My thought was, if I select all times that are already selected, to use a constraint on my survey Time selection where the Search Time != Survey Time. The issue with this is I can not default select only the filtered Time choices. The selection also needs to be dynamic and recalculate when the user selects another pavilion or date. Any suggestions on how to not double-book pavilions is appreciated! This survey will be public and should be as user friendly as possible. Thank you!! ... View more