Latest Contributions by AllenDailey1

‎08-29-2019

Hi James, I have the same problem as the original post. I also have the additional problem that when I try to enter something into the bind::esri:fieldType column OR the bind::type column, I get this error, and it happens every time I try. I've tried typing: esriFieldTypeInteger integer int Anything I type results in this same error message. Also, absolutely nothing happens or displays when I click the little dropdown arrow in the selected cell, which I believe is supposed to show the things you can put in cells in that column. Edit: I just discovered that I am able to enter a field type into the esriFieldType column if I create a brand-new row in the spreadsheet. So...are you not allowed to change the field type from string to integer for an already-existing row/question?

‎08-28-2019

Doug, thanks for your reply. However, the post you provided a link to does not actually relate to my question, as far as I can tell. I'm working on what to type in the "calculate" field for a select_multiple question, in order to automatically select choices based on the user's answer to a previous question. That other post is about using the "relevant" field to make a question hide or appear based on a user's answer to a previous question. What I wanted to figure out is, what should the syntax of the "if" statement be for this kind of scenario: If question 1 is "yes," then select choice A for question 5. If question 2 is "yes," then select choice B for question 5. If question 3 is "yes," then select choice C for question 5. Any combination of A, B, and/or C can be made (because it's a select_multiple question). Since "question 5" is obviously a single question with only one "calculate" field, I need to somehow put all 3 of those "if" statements into that one field. This is what I don't know how to do.

‎08-28-2019

Since I haven't solved my problem yet, I'm going to get around it by turning my select_multiple question into a series of select_one questions - user will answer yes/no for each of the choices. Then I can write a separate "if" statement for each of those questions. It's not ideal, but it'll work. If anyone is able to answer my original questions, I would still really like to hear from you!

‎08-27-2019

Hello, I am creating a survey using Survey123 Connect. My current problem is that I'm trying to do "if" statements in the "calculation" field for a select_multiple question, and it is not working (it seems to break the functionality of various repeats and relevances in the survey, even ones that do not seem connected in any way to the calculation I'm talking about). My main questions are: 1) Is it even possible/supported to do "if" statements within select_multiple questions, for the purpose of automatically selecting one or more of the choices based on user's answer to a previous question? 2) How do you write a calculation that includes 2 separate/independent "if"/conditional statements? Here is my draft of the "if" statement: if(${minor_count} > 0, ‘MinorsPresent’,‘’) and if(${youth_count} > 0, ‘Youth18to24’, ‘’) Context: Earlier in the survey, the user can enter various people's dates of birth, within a repeat; these are people who are present at a homeless camp. I have a calculation in the survey to convert the people's ages into decimal-date-time (by subtracting their DOB decimal date from the decimal date of now().), and then I calculate the number of minors (minor_count) and the number of youth ages 18-24 (youth_count). If there are any minors and/or youth--that is, if minor_count or youth_count is greater than zero--then I want to select choices within the select_multiple question. This select_multiple question includes choices for minors being present and youth being present. If there are any minors, I want to select 'MinorsPresent.' And if there are any youth, I want to select that youth are present. Thank you in advance for any help! Allen

‎08-26-2019

Hi Ellen, I'm glad to hear you created a workaround using my method plus your own tweaks. Sounds good! Thanks for sharing! Allen

‎08-21-2019

Thanks, Mike! I set the appearance to minimal and it solved the problem! Before, I'd had the appearance as "compact." It's interesting that these two appearances are very similar yet have very different effects.

‎08-21-2019

Brittney, Thank you so much!!! It works! In the esri::bind:parameters column, in the "begin repeat" row, I wrote: allowUpdates=false allowAdds=true query And that is allowing a user (me) to fill out a new repeat but makes the already-completed repeat non-editable. A side-effect of this is that the very first instance of the repeat is a throw-away; it can be filled out by the very first survey user only. If they do not fill it out (which they won't, because this repeat is only for follow-up visits), then it remains empty forever and the second visitor (who does the first follow-up visit) has to skip that first empty repeat and start a fresh repeat. I don't think this is a big problem for us, though; it's worth the benefit of preventing users from overwriting each other! Thanks again! Allen

‎08-21-2019

Hi there, I'm developing a survey, using Survey123 Connect, that includes a few repeats. The situation is that there will be one survey instance per location; the first person to visit that location would fill out part of the survey, and follow-up visitors would fill out other parts of the survey, mainly repeats; the portion of the survey entitled "Follow Up Visits" is a repeat. This way, there can be any number of follow-up visits to the location, and each follow-up visit goes into its own instance of the repeat. My question is: Is there any way of preventing or deterring users from accidentally overwriting an instance of a repeat that has been filled out by a previous user? The first person to do a follow-up visit will fill out the first instance of the repeat, which is already open in front of them when they open up the survey. That's fine. But the second person to do a follow-up visit will open up the survey and have that first repeat in front of them, and it will be very likely that they'd forget to scroll all the way down and hit the "+" icon to open up a new instance of the repeat. I think it would be likely that they would accidentally add to the previous user's repeat instead. (Even my coworkers and I, the survey creators, have fallen into that trap when testing out the survey ourselves!) I've done a lot of brainstorming and haven't come up with anything very good. Here are some of my unsatisfactory ideas: Put a question in the beginning of the repeat: "Is this a NEW follow-up visit?" If user's answer is yes, then: "Scroll down and click the '+' to begin a new follow-up." This wouldn't work because the user would see the same question at the top of the new repeat even after they click '+', over and over forever. Move the '+' icon to the top of the repeat rather than keeping it at the bottom (my organization doesn't have the Developer Edition license that you need to get into the source code). Format text with html to create some kind of large-font, red text blurb at beginning of repeat that says, "Are the questions below already filled out? If so, click the '+' to start a fresh follow-up!" This could work but would be rather tacky. Thanks for reading! Allen

‎08-21-2019

I was dealing with a similar problem, and the only thing that made it work was to put "allowUpdates=true query" in the bind::esri:parameters column. (in the "begin repeat" row.)

‎08-15-2019

Hi Ellen, I did come up with a workaround. I am quite happy with it, but it would not be ideal if you want users to select from a really long list of departments or whatever. Here's how it works: I changed the survey question where the user could select multiple departments: I changed it into a separate question for each department. That is, the questions are now like: "Notify Social Services? yes/no. Notify Public Works? yes/no." etc. (Each of those is a select_one yes_no question.) Then, in the dashboard, to allow the viewer to choose a department for filtering the dashboard content, I created a separate category selector widget in the header (or sidebar) for each department/question. I configured the category selectors thus: categories from defined values; I typed the department name instead of "yes" or "no"; I did not type anything for "label"; I chose "button bar" display; no "none" option; I used "select multiple" (so the button for the department name would not be automatically selected). After doing all that, I have a button for each department, and I configured actions so that the buttons affect the other dashboard widgets. I'd be interested to hear if you or anybody else finds this useful! Good luck! Allen

‎08-13-2019

Thanks, changing the file extension to lower case solved this problem for me!! btw, for future viewers of this thread, if you can't figure out how to change the file extension to lower case (I didn't at first), I recommend this website: 4 ways to change the file extension to uppercase/lowercase in Windows

‎08-13-2019

Sounds good, thank you.

‎08-13-2019

Thanks for your reply, Chelsea. That's good to hear that you had success with the custom JS functions. Perhaps I will check it out. I haven't been able to find any "documentation" on the Early Adopter website, but maybe I have to register as an official early adopter in order to view any of that? Thanks! Allen

‎08-12-2019

Hi there, My organization is creating a survey with Survey123 to allow staff to map and enter data about homeless encampments. Users create a geopoint for each new homeless camp they find. We would like to pull parcel owner data into the survey based on the geopoint location; parcel owner data is in an existing feature service we have. Is there some way to do a spatial query (?) between the survey and the existing feature service? By the way, we are using Excel and Survey123 Connect to create the survey. I've read about how it's possible to pull data from a CSV file into Survey123, for example on this webpage: Formulas—Survey123 for ArcGIS | ArcGIS If we made the parcel owner feature service into a CSV, with polygons as a list of vertex coordinates (I saw an example of this online), is there some way to do the following (or something else that would achieve a similar result): 1) user enters geopoint in Survey123 2) a survey question after the geopoint question, which would be read-only and would get and display the parcel owner, by looking up which polygon in the CSV the geopoint would be inside. By the way, I also read a little about Survey123's Custom JS Functions, which is supposedly available in the Early Adopter community. I don't have JS experience and don't know what Custom JS Functions involve, so it would be nice to avoid this, but if Custom JS Functions is the only way to achieve my goal, then I am open to hearing more about how it works. Thank you!!

‎08-08-2019

I have a very similar question as Massimiliano Menestrina‌ above. In my operations dashboard, I have a dropdown category selector to allow the user to choose a department and filter what shows up in the list (items in the list should include the chosen department). The problem is that the items in the list are surveys completed via Survey123 and the survey field connected to the dashboard category selector can contain multiple departments. So, for example, if the user selects the department "Sheriff" from the dashboard dropdown, the list filters to display only surveys that list Sheriff ONLY, and the list does not display surveys where a user may have included Sheriff as well as another department like Social Services. I need the list to display surveys/items where the relevant field CONTAINS the chosen department, not strictly EQUALS the chosen department. All I'd need is for the "=" operator to change to "is in" or something. Does anyone know how to accomplish this? This screenshot shows an example of that in the last item in the list - notice it contains two departments for "Referred to." Next, notice that when "Social Services" is selected in the "Department" category selector dropdown, the list item/survey that was the last one in the above screenshot is NOT included in the filtered list, but I need it to be included! Thank you! Allen

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by AllenDailey1

Re: sum() Aggregate function, appends values, doesnt add them

Re: "If" calculations for select_multiple questions

Re: "If" calculations for select_multiple questions

"If" calculations for select_multiple questions

Re: Category Selector Like

Re: Prevent overwriting existing repeats

Re: Prevent overwriting existing repeats

Prevent overwriting existing repeats

Re: Edit Repeats in [Inbox] Survey123

Re: Category Selector Like

Re: Thumbnail keeps disappearing

Re: Spatial query in Survey123?

Re: Spatial query in Survey123?

Spatial query in Survey123?

Re: Category Selector Like

Re: MrSID imagery used to work but suddenly has wr...

Re: MrSID imagery used to work but suddenly has wr...

Re: Append Tool and Field Mapping ... Help? Exampl...

MrSID imagery used to work but suddenly has wrong ...

Display pop-ups when clicking on map in Web Editor...