Latest Contributions by BillKrukowski

‎10-23-2020

Hello Zachary Sutherby, Thank you for responding. The whole thing was acting funny (sometimes it would work other times I would get that message) so I decided to start from scratch because this was a pretty simple task, just a Catch Basin cleaning, and recreate my work, all aspects are now working correctly and I am no longer receiving any errors. The survey is posting back to my feature table as expected. Time for a dashboard. type name label hint appearance required required_message readonly default calculation constraint constraint_message relevant choice_filter repeat_count media::audio media::image bind::type bind::esri:fieldType text CB_ID Catch Basin ID yes esriFieldTypeString text CB_Loc Location esriFieldTypeString dateTime D_clean Date of Cleaning now() esriFieldTypeDate decimal Rm_Elev Rim Elevation esriFieldTypeDouble decimal CB_D Catch Basin Depth esriFieldTypeDouble decimal Sump_D Sump Height esriFieldTypeDouble decimal CB_A Catch Basin Area esriFieldTypeDouble decimal Sump_V Sump Volume ${CB_A}*${Sump_D} esriFieldTypeDouble decimal D_Sed Depth to Sediment yes esriFieldTypeDouble decimal Sed_V Sediment Volume (${CB_D}-${D_Sed})*${CB_A} esriFieldTypeDouble decimal D_Fin Final Depth yes esriFieldTypeDouble decimal V_Sed_R Volume of Sediment Removed yes (${D_Fin}-${D_Sed})*${CB_A} esriFieldTypeDouble decimal Sump_Fpcnt Sump % Full ((${CB_D}-${D_Sed})div${Sump_D})*100 esriFieldTypeDouble Catch Basin Cleaning Catch Basin Cleaning https://spencer-ma.maps.arcgis.com/sharing/rest/content/items/8285d33e6f204ceeb4446ef3db05d7c7 yes Attribute Display https: //survey123.arcgis.com/share/805e6075750a49b3b638f94b98f188b9?portalUrl=https://Spencer-MA.maps.arcgis.com&field:CB_ID={Town_ID}&field:CB_Loc={assetid}&field:Rm_Elev={rimelev}&field:CB_D={depth}&field:Sump_D={D_Sump}&field:CB_A={CB_Area} Feature Table Display Name Field Name Type OBJECTID OBJECTIDObjectID Catch Basin ID CB_IDString Location CB_LocString Date of Cleaning D_cleanDate Rim Elevation Rm_ElevDouble Catch Basin Depth CB_DDouble Sump Height Sump_DDouble Catch Basin Area CB_ADouble Sump Volume Sump_VDouble Depth to Sediment D_SedDouble Sediment Volume Sed_VDouble Final Depth D_FinDouble Volume of Sediment Removed V_Sed_RDouble Sump % Full Sump_FpcntDouble GlobalID GlobalIDGlobalID CreationDate CreationDateDate Creator CreatorString EditDate EditDateDate Editor EditorString

‎10-22-2020

I have created a Survey for Catch Basin Cleaning and added the pop-up link to work with the Collector App, however when I submit the Survey I get "Survey contains error: 1. Press here to navigate to each error" message. When I press here nothing happens and I cannot determine where the error is. Can anyone offer some tips or take a look at the app and assist. I looked at the error log and cannot make heads or tails of anything. #Survey123 #Error

‎11-25-2019

I would like to use Survey123 to track activity at a recycling center. I have set up a form with a few groups to separate the type of recycling (Electronics, Metals, Bulky Items, and Construction Debris). Each of the groups contain a repeat section to add multiple items. I would like to auto calculate the total fee based on the items selected and am having a rough go at it. I want to avoid using the pull-data function from a csv file to look up the disposal fee. At first I used the fee amount as the name but that created problems because multiple items have the same fee and thus the same name so my select-one question would have multiple items selected because the names were the same (it did not throw an error). So I guess my real question is: Is there a way to use a select-one field result (Item Drop Down) to match a second choices list and then pull the label from that second list and report it back to the Survey (Invoice Amount)? I would like to note that multiple class of items can be disposed of at a time so the Invoice Amount would need to look into every repeat and all table entries of that repeat for the specific survey instance. Can I create my own custom column in the choices tab of the excel sheet and somehow just reference a custom column to do calculations? My alternative is to have the workers manually enter a price for each item and then run a calculation to populate Invoice Amount, I did not want to create too many field in the survey.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by BillKrukowski

Re: Assistance resolving error

Assistance resolving error

Calculation based on select-one results