Latest Contributions by Jim-Moore

Hi Josh Thanks for providing the XLSForm. A couple of hints below to help fix the issue you're seeing: Replace the text entries in the name column on the choices worksheet with integer values. The entries in the name column are the values that will be stored in the feature service; the label column is used to specify how to display each option in the form. Your survey has text in the name column for fields that are expecting an integer. Remove the 'int' entries from the bind::type column. The bind::type column works well with calculate questions (as documented here), however there is a bug when using this setting with select_one questions. We have an issue logged in our system to address this.   I've attached a revised XLSForm for your reference. If you needed to use the value from a select_one elsewhere in your form (for a calculation, for example) you could use the int() function in the calculation column to treat the value as an integer, for example: int(${field_1}) + int(${field_4}). EDIT: However, to avoid issues when including other integer or decimal type questions in a calculation it is recommended to add a calculate question with bind::type set to 'int' to store the answer to the select_one and then use this value in any calculations. More info on the choices worksheet available here: XLSForm essentials—Survey123 for ArcGIS | ArcGIS Survey123 for ArcGIS XLSForm Tutorial 2 of 5 Creating Selection Questions in a Survey - YouTube  Hope this helps, Jim ... View more

Hi Anna Thank you for providing the XLSForm for your survey.  The max() function Philip Wilson mentioned can be used to return the maximum value from a field in a repeat. However, in this case each time a new repeat record is added and the current meter reading entered, the max() function will read in this new value (essentially overwriting the previous maximum value). This then breaks the subsequent GallonsUsed calculation. The way you've designed your survey (i.e. user manually enters the previous reading each time a repeat is added) is currently the best option to ensure the form works. We have an open enhancement request to introduce indexed repeat functions (e.g. return value from first repeat, last repeat, repeat x of y, etc.). This would allow you to 'look up' the latest meter reading and use it in another calculation. We will add to this thread any updates on the progress with this enhancement. Best regards, Jim ... View more

Hi Ben Thanks for the screenshots. You should be able to control the scale of the map using the mapSettings tag as described here Feature report templates—Survey123 for ArcGIS | ArcGIS (and in your screenshot above) and discussed here I am using the "Report (Beta)" feature to generate a report using a report template. However, the map image generated by ${geometry} is a map inset that is zoomed out to the scale of the entire planet… Is there a way to generate a more useful map with a m  ${$shape | mapSettings:"webmapItemId(optional)":mapScale(optional)} For example: ${$shape | mapSettings:"10df2279f9684e4a9f6a7f08febac2a9":264800} You can leave the webmap item ID empty; alternatively, you can find IDs for ArcGIS basemaps here: http://www.arcgis.com/home/group.html?id=8cb0765d4f394cc097407068580188ad#overview  Hope this helps, Jim ... View more