POST
|
Let me know if you get stuck! I may be able to help!
... View more
11-22-2022
03:19 PM
|
1
|
0
|
543
|
POST
|
Hi, @lmelendez_ADMIN! Not exactly. We’re not using a spreadsheet but I don’t see why this wouldn’t work with a spreadsheet. I’m taking the results and using a switching flow to send various emails based on the responses to the Survey123 form. In this case, one of the emails specifies a “reason for cancellation”. So, in the body of the email, I’ve set that line to either echo out one of the responses or, if “Other” was selected, to echo the response typed into the “Other” box. Getting the standard responses was easy because they show up in the list of dynamic content from previous steps. The “Other” responses were not available but I was able to get them to echo by inserting an expression and setting the expression manually to the string I listed in my previous reply.
... View more
11-16-2022
03:47 PM
|
0
|
2
|
560
|
POST
|
Looks like I answered my own question through some testing: You can use the "Other" response by manually typing in an expression using triggerOutputs()?['body/feature/attributes/reason_for_denial_other']
... View more
11-10-2022
04:35 PM
|
1
|
4
|
599
|
POST
|
We've got a Survey123 form with a Dropdown question where we've selected the option to allow for "Other" responses. My understanding is that anything submitted under "Other" gets saved to the feature layer in a new column/attribute called question_name_other or something similar. We're taking the submission information and processing it with Power Automate and, for some reason, it doesn't show the "Other" response field. I can select the Dropdown question but that results in any "Other" responses returning "other" as the response rather than whatever the user typed into the "Other" box. How do we expose the actual response from the "Other" box?
... View more
11-10-2022
04:09 PM
|
0
|
6
|
626
|
POST
|
I sent Ismael a message a few weeks ago and never got a response so hopefully your superpowers extend farther than mine. 😛 His article is the one that got me to this point to begin with so he's definitely the one with the answers.
... View more
09-12-2022
03:34 PM
|
0
|
0
|
527
|
POST
|
Thanks, @MichelleWilliamsERM. Luckily, this particular survey *was* published with the Survey123 website because the team may need to edit the survey questions in the future. We also have a Microsoft Power Automate flow that's triggered by submissions. Here are some answers to your questions. Hopefully this will help clarify things. Have you tried making one hosted service and then creating a new survey just for the public linking to the original hosted service and one for your QC team? I have not. The public doesn't need to see the survey results at all. We only need to be able to accept submissions anonymously/publicly. The issue seems to be that our teams need to be able to edit the responses (and potentially fill in any missing information on follow-up) and then re-submit that particular response. In the past, we've done that right from within the Survey123 tool (Data tab) or by dynamically generating URLs with the "mode=edit&globalId=xxxx" parameters but the surveys themselves have never been public/anonymous (or they were fully public with no sensitive info so no worry about sharing that data). As far as the distinction between fieldworker and stakeholder, I think this is the crux of my problem that I can't seem to solve. We did publish through Survey123 web so I do have the _fieldworker layer but, based on my readings from those docs, allowing editing on that layer would also allow *anyone* to view/edit/update the entries if they were able to figure out the globalId parameter for an entry. This is the part that I can't have. Right now, our data doesn't include any of that sensitive info but we're looking to add some fields/questions that may contain information we don't want publicly available. Changing the sharing settings to only share with our group, though, seems to disable the ability for anonymous users to submit to the Survey. It's almost like a catch-22 and that's what I thought the _stakeholder view was for but, as you stated, I'm pretty sure that layer is read-only. That's helpful for reviewing the submissions but does nothing for when we have to update/add information to them. As for your last question, we'll only ever be editing/updating these via Survey123's web app (under the Data tab) or via the URLs with parameters, as mentioned above. Hopefully that helps rather than harms our situation. Any help you can provide would be great. I've reached out directly thanks to your link. 🙂
... View more
09-12-2022
03:21 PM
|
0
|
0
|
532
|
POST
|
I've read all the docs about securing Survey123 forms that collect public information ("Limiting Access to Public Survey123 Results" and https://community.esri.com/t5/arcgis-survey123-blog/securing-data-in-public-surveys-survey123-web/ba-p/898102). What those documents don't address is a situation like ours where we need to collect info from the public but also need our group to be able to update and edit those forms (either by the mode=edit URL parameter or through the Survey123 Data tab). Based on what I'd read in the documents, I thought that we could take the _stakeholder view and enable editing on that and only share it with the group needing to edit it. That didn't work and we still get notified that we can't edit submissions from other users. I'm hesitant to edit the Settings on the main Survey layer or the _fieldworker layer, though, because those docs seem to suggest that enabling editing on either layer will expose that data publicly, which we definitely don't want. What are the proper settings for the various layers (Survey layer, _fieldworker, and _stakeholder) to allow only a specific group to edit the information submitted by anonymous/public users without exposing the entries to the public?
... View more
09-12-2022
01:37 PM
|
0
|
4
|
573
|
BLOG
|
@IsmaelChivite- Is there a solution here for a Survey123 form that can still be edited by a group within our organization that can take submissions anonymously?
... View more
08-18-2022
09:45 AM
|
0
|
0
|
3669
|
POST
|
That doesn't sound like a bug to me. That sounds like the person changed the label for the answers *after* the survey was published instead of removing the original options and adding new ones. It's my understanding that, once the survey is published and the feature layer is created, you can still change the labels that are displayed publicly for the survey but not the value. That's intentional. In order to have a different label from what it was originally, you need to remove the response options and add news ones and ensure that the values are correct when you republish.
... View more
08-09-2022
02:22 PM
|
0
|
0
|
376
|
BLOG
|
I'm not sure if this post answers my question so I'm hoping I can give some extra info on our end to confirm. We're setting up a form that we need the public to be able to submit. Once a submission is recorded, we need staff members to be able to verify and update information on the forms but we don't want to expose the form's submissions to anyone outside of our organization (even better, outside of a specific group within our organization). The issue that I'm running into is that we're using Survey123 to trigger a flow in Microsoft Power Automate when submissions are added or edited so, as far as I know, I can't use another Feature Layer as the Survey123 trigger that was created by ESRI only looks at the survey feature itself. So, how do I get it so that the public can submit but not view or edit their submissions but people in our organization/group can view *but also edit* these submissions and still maintain the ability for the Survey123 trigger to work?
... View more
08-09-2022
02:18 PM
|
0
|
0
|
3745
|
POST
|
I'm having this same issue. For me, it's a feature service that was created from a Geodatabase that was working fine without any issues. I created some Serial Charts using the data set and saved and it worked. As far as I know, nothing has changed but I'm now getting a "Layer Not Accessible" error whenever I try to add a new serial chart and, after I refreshed the dashboard, existing Serial Charts are now saying "Data Source Error" even though I can see the service, data, and layers in the ArcGIS Online Content view. Could this be a temporary service issue or did something just randomly happen to my data?
... View more
09-14-2021
11:09 AM
|
0
|
0
|
1531
|
BLOG
|
Sorry for resurrecting this but I couldn't find any info on the Analyze tab outside of this post. Is it possible to customize the colors used for the charts on this screen? We sent out some surveys where the answers are "Yes", "No", and "Pending" and the "Yes" is red, the "No" is green, and "Pending" is purple. It seems like it makes better sense for people looking at these to see green, red, and yellow, respectively, so it would be nice if that's possible.
... View more
02-11-2021
08:34 AM
|
0
|
0
|
1056
|
POST
|
Just realized that I'd have to change the feature service and lose all the currently entered data in order to implement this "convoluted" method. Back to the drawing board for me. 😞
... View more
11-19-2020
04:12 PM
|
0
|
0
|
4245
|
POST
|
Thanks for the reply. Yes, I was hoping for a "non-convoluted" way to address these issues but it seems like there really isn't one from what I can tell. 😞
... View more
11-17-2020
05:20 PM
|
0
|
0
|
4253
|
POST
|
I'm at my wit's end and need some help coming up with a definitive solution to this problem that I've seen pop up on these discussion forums multiple times. I have a Survey123 Connect form where one of the entries is a number that needs to be inputted as a decimal value with a precision of 2 decimal places. After searching on these discussion forums, I have found multiple potential responses and none of them seem to work. Here's a breakdown of what I've tried. If someone can poke some holes and/or confirm these, I would be grateful. 1. Format for decimal numbers Using this method, recommended by James Tedrick, to input the constraint as . * 100 = int(. * 100) seems like it should work. It's a simple check to see if the current value, multiplied by 100 matches the integer value of the same thing. If it's not 2 digits, the first part will still have a decimal point and, therefore, won't match. Unfortunately, there's either a bug in this or I'm not reading through this correctly because *most* numbers to 2 decimal places work except for 1.09, 1.10, and on up to 1.16 don't work. Typing in 1.08 or 1.17 is accepted fine but not anything in between. Even 2.09, 10.09, and 101.09 work, just not 1.09. I have no other constraints set (the quote is copy/pasted from James' post into my sheet and then into this comment) and no other fields on the XLSForm filled other than type (decimal), name, and label with a constraint and constraint message. There may be more very specific numbers that don't work but I haven't been able to find any others in my random testing. 2. survey 123 decimal places This post advises the use of an input mask which is mildly helpful with the big caveat that numbers have to match the mask exactly so a mask of '9999.99' will only allow 4 digits before and 2 digits after the decimal. That means that numbers need to be padded if they're not large enough (e.g., 0001.15 using the example number from above) and they cannot be larger than the number of digits in the mask (e.g., 10,015.15 is not possible as an entry for the mask '9999.99'). Another user recommends a regex expression but I'll cover that below. Based on the link provided by Ismael Chivite, there is only the option to use the input mask for *required* digits, not optional. Our specific use case could be as little as 0.05 and as much as 10,000.00 (possibly more but it's never happened). 3. Creating a constraint for 3 digits after the decimal in Survey123 This post suggests a regex expression (which was also suggested in the previous thread, although with a different expression) so I attempted again with this expression: regex(., '^[0-9]+\.[0-9]{2}$') Based on that expression, it should be looking for one or more numbers at the start of the input followed by a decimal and then exactly 2 digits. It works for the example case of 1.15, 1.09, and also 101.15 but it fails with 1.10 and 1.20 or any other input that ends in 0, despite the fact that this should be allowed by the regex expression. Modifying the end of the expression from {2} to {1,2} allows for 1.10 and 1.20 but then it won't allow 1.00 or 2.00. It seems like the regex filter can't deal with 0's at the ends of strings properly. The post linked above also mentions this non-zero issue but there's not really a solution for it in any comments that I could find. There is a suggestion mentioned at the bottom, by James again, that gives some arithmetic checks that should give the format desired: Another way to multiply the number by the number of digits you are looking for and - check to see if there is any decimal component left (${q}*1000 - int(${q})*1000) > 0 - check that the last digit is non-zero (${q}*1000) mod 10 > 0 but I wasn't able to convert or translate those into any reasonable constraints that worked for the conditions I tried. I tried using an 'and' operator to combine those 2 statements (.*100-int(.)*100)>0 and ((.*100) mod 10>0) but to no success. It still accepted 1.1 and 1.152 and anything else I threw at it. ------ All of this to ask: "What's the 'proper' way to enforce precision for decimal numbers?" I've seen so many different responses on this and it seems like it should be something that's somewhat easy to implement and, most importantly, consistent. Unfortunately, I can't seem to find what's the "right" way to enforce this that lets me specify any number so long as it's precise to 2 decimal places. HALP!
... View more
11-10-2020
05:28 PM
|
2
|
6
|
4326
|
Title | Kudos | Posted |
---|---|---|
1 | 11-10-2022 04:35 PM | |
1 | 12-06-2023 10:25 AM | |
1 | 12-06-2023 10:21 AM | |
1 | 12-06-2023 10:18 AM | |
1 | 12-06-2023 10:16 AM |
Online Status |
Offline
|
Date Last Visited |
Monday
|