Latest Contributions by ZacharySutherby

Hello @KellyTaylor,  Would you be able to pass along the XLSForm for troubleshooting? You can also enable diagnostic logging prior to opening the survey, would it also be possible to obtain a log when the behavior occurs?  ... View more

Hello @RHammers,  It wouldn't be in a single line the calculation would need to go in it's own question so that value can be referenced in the event select_one question. The separate question can be a calculate question type that is not visible on the form and is only used to store calculations on the back end.  Another good resource to see how to summarize data using pulldata("@layer") in XLSForm is the Query a feature layer sample available in Survey123 Connect.    ... View more

Hello @RHammers,  You can use pulldata("@layer") to query the feature service your survey points to and return the count of the number of records that match the specific event. For example, if someone selects Event C the pulldata("@layer") function would query the data and return the number of records that have the value Event C. You can then configure logic in your survey so that if that number is 25 or more then there's a constraint on the event select_one question preventing the user from submitting.  Please see the Request parameters section of the Query a feature layer documentation for more information on how to return the count.  ... View more

Hello @GaryBowles1,  The quotation marks in your outStatistics string is throwing off the URL string.  pulldata("@layer", "getValue", "attributes.field1", "https://gis.srcx.com/server/rest/services/APPS/APPS_RUN_LOG_BINGHAM_MR/FeatureServer?outStatistics=[{"statisticType": "avg","onStatisticField": "field1","outStatisticFieldName": "field1_avg"}]) You'll need to use something like:  pulldata("@layer", "getValue", "attributes.field1", 'https://gis.srcx.com/server/rest/services/APPS/APPS_RUN_LOG_BINGHAM_MR/FeatureServer?outStatistics=[{"statisticType": "avg","onStatisticField": "field1","outStatisticFieldName": "field1_avg"}]')   ... View more

Hello @AllisonWebb,  The username variable is the only dynamic variable that can be used in an inbox query. ... View more

Hello @HanggarPrasetio1,  Survey123 will only return the value from the barcode and won't do any decoding itself. You can use a custom JavaScript function to decode the barcode value and parse it as you need.  ... View more

Hello @Vaneiri_Patt,  It is technically possible using a mixture of a select_one question and a pulldata("@layer") calculation, but we are currently working on a new question type in the web designer called the geolist question that will do exactly what you're asking. Please keep an eye out on our Early Adopter Community for when the new question type is available in the beta website to test it out.  ... View more