Latest Contributions by ColinDaniel

Hi Chris, Tried the first option and it worked! Not essential for me to keep use the preexisting hosted feature layer. Thank you so much! ... View more

Hi Chris, Thanks for your response! Yes, the form_id column in my survey does match the polygon layer in my ArcGIS Online hosted feature layer. However, my hosted feature layer only has the polygon layer, not a related table to go with. I was under the impression that this would be created for me in ArcGIS Online upon publishing of my survey (since I see no way to add a table to a hosted feature layer in ArcGIS Online), but is appears that this is not the case. I also tried creating a separate hosted table in ArcGIS Online (with same name as my repeat) and putting its form_title, form_id, and submission_url information in the settings tab in my XLS form. Still no luck. Any other tips would be greatly appreciated! Thanks. Colin ... View more

Hi Phil, Thanks for the help! Sure enough, I tried republishing it and got the results I wanted. Still not sure where the field mismatch was, but it probably didn't help that I tried to add the calculate fields in my feature layer after already creating the survey. Regardless, I'm so glad that it's working now. And I appreciate the details regarding calculate and hidden field types - that cleared it up for me. Really appreciate your help! Colin ... View more

Hi Phil, Attached is my most updated version of the form. I kept tinkering with some of those things I had already mentioned above, but the calculations still do not show up in the form nor my ArcGIS online feature layer. Do I need to set the field type to calculate to get the calculations to work properly? At least for now, I would like to be able to view those calculated fields in the form, but the calculate field type automatically hides it. Another thing that I thought of that could be part of my problem: I added the calculate questions to the survey AFTER populating the form with my ArcGIS Online feature layer, then went into ArcGIS Online and added the appropriate fields to match what was entered in the survey. It still publishes fine and they are both integer field types. Do I need to go back and re-create the form from a new feature layer? ... View more

Hi Phil, Thanks for the reply. I'm very much a novice with this, so I really appreciate your help. I tried your suggestions, but I still can't manage to get things to work. If the select_one and select_multiple questions in my survey are strings, that's fine. All I want is the separate calculation fields (integer) to run a conditional statement on those select_one / select_multiple questions and, if that certain response was selected, to add a value to the field. So my calculation fields should only contain numbers, not a blend of string and number fields. The basic syntax I have looks like: int(if(selected(${question}, 'abc'), 5, 0)) + int(if(selected(${question}, 'def'), 5, 0)) + ... My calculation fields are set to integer type in both the survey and the hosted feature layer and in the survey, bind::esri:fieldType is set to esriFieldTypeInteger and bind::type is now set to int. What else I tried: replaced the number function with int function in my calculation fields, removed quotations around the numbers in my calculations (e.g. they were '5' before where they are simply 5 now), used the coalesce function before the calculation, and tried to change the bind::type in the select_one and select_multiple questions to int (got an error message preventing me from converting the form). I must still be missing something! ... View more