Latest Contributions by JedJackson

@IsmaelChivite. Great article and great resource.  I have a survey where people can put in several records of Bycatch throughout a month (site, date, Fish species and number released and number died etc).  I want to create an aggregate report to summarize by site, year, month, Fish Species, and total number released and total mortalities.   As such I have a summary report that I created to aggregate all the fields from the original survey by grouping them by a sortfield (a concatenation of Site, Year, Month, FishSpecies) to give distinct values.  This works great to populate the data table needed on 11/12 fields of various types (like facility #, site Name, Date, Month, Year, FishSpecies, OtherSpecies, sum Mortalities, sum Released, comments), using min stats for both text and dates etc. Syntax is verifying and report produces without errors, also gives me what I am looking for results for  11/12 fields except one field will not populate (FishSpecies).  I have tried first, last, min and max stats (last is the only stat that does not seem to crash table when creating) on this text field and it still will not populate, yet field beside OtherSpecies is also text and populates completely fine with min stat.  Any help will be greatly appreciated, as I know I am pushing boundaries with aggregating text fields and cannot see tons of documentation in that regard. here is the first column of the summary table that works out all the stats:   ${#Report_Details|stats:"min, Facility_Ref_Nbr, Ref_Nbr; min,Facility_Name, Name; min, Sort_Concat, Sortfield; min, Date_of_Catch,DateCatch;min, Month_Of_Catch, Month; min, Year_Of_Catch, Year; last, Species_Common_Name, Spp; min, Other_Species, OtherSpp; sum,Released_Pieces, sumReleased; sum, Mortalities_Pieces, sumMort; avg, Ave_Weight, aveWeight; min, Comments, Comms":"Sort_Concat"|where: "Event_Type='Carcass_Recovery'"|orderByFields:"Sort_Concat ASC"}${ Ref_Nbr}   then I have a table with a column for each aggregate field ${Name} ${Sortfield} Carcass Recovery ${DateCatch} ${Month} ${Year} ${Spp} ${OtherSpp} ${sumReleased} ${sumMort} ${aveWeight} ${Comms}${/}   In the survey Name, Spp are both Choice fields in the xlsForm, whereas OtherSpecies is just open text box.  so not sure why I can pull min Name, and min OtherSpecies but not min Spp.   End table looks like this (some information has been changed for privacy reasons). I would like Species Common Name field to have the fish species populate (i.e. record 1 would be Copper Rockfish).   ... View more

I am creating a survey for auditing sites.  It has 137 questions with  5 simple attributes each (Standard #; Standard Details; Comply to Standard yes/no; Severity of Non-Compliance major/minor/critical; and Details).  Perfect candidate for repeat but navigating through 137 records back and forth is a pain (particularly if not doing a survey in a linear fashion or if 90% of all the answers are comply with the standard and thus do not need the Non-compliance question or details).  I found the post on Pages (Fix painful repeat navigation issues - have navigation mirror that of the pages group appearance)  that allow for you to navigate to a certain section it also means that I have to change from 1 table with  roughly 4 fields and easy structure to analyse or update to multiple tables with many fields for each question to make the pages navigation work.  A table type view would significantly help this situation.  Owners can edit survey123 in the data tab in Survey123 website and it would be nice if field workers can do something like this as well. ... View more

we have a need at my company to do surveys within a specified window when certain conditions exist (i.e. survey a site within 1 week of peak biomass).  This it needs to be recorded when and what the peak biomass.  The person with the best information and models to determine that is the dispatcher whom would then be able to schedule an assignment and put in 2 custom fields (Peak Biomass, Peak Date).  I have created a survey123 to handle the actual survey but would love to have these two custom fields to be passed from the assignment to the survey to facilitate data plug in.  otherwise once the filed worker does the survey the dispatcher would have to go back into the data to fill in these fields either before or after the field worker does the survey (too many unnecessary touches of the data).  the ideal situation would be the dispatcher creates and assignment for a site and fills in these two fields of the expected date and weight of peak biomass into the assignment tab and this information flows to the survey123 together with the site location and survey planned date.  ... View more

This is definitely a down grade from functionality in ArcMap, where one can easily stretch a legend to fit how the map is displayed (especially for poster or wall maps). I have a Project with 15 different layers that I turn on and off to create a series of maps at the same scale and layout then export to a series PDF.  Having to make a graphic image for each Legend so that I can resize and everyone of those maps and layers in order that I can dynamically stretch to fit the presentation is time consuming and dangerous if I do not check every single map and legend to ensure all the layers are on or off (not to mention symbology changes). I can have a layout for each version of the map but that still does not correct the problem of the scale of legend. ... View more

I will look into that as still having issues with it. Thanks for the tip. Jed Best regards –––––––––––––––––––––––––––––––– Jed Jackson, BSc, ADIP-GIS, CGS GIS Analyst Mowi Canada West –––––––––––––––––––––––––––––––– Mobile: (250) 202-4488 Mail: [email protected]<mailto:[email protected]> ... View more

Yes still happening for me, it seems that it has something to do with size or how much is hidden by relevant statements.  I get the survey working and then add a section or a couple of questions then it crashes again.   ... View more

I also am in an IT controlled environment and it seems that the updates for Survey123 connect are coming out faster than I can get my IT people to update and in fact because it is a pain and I do not have permissions I have been scanning the whats new and version releases to see if my particular issues are solved before sending a note to IT to ask them to update the version. ... View more

I am having a similar problem, whereby the survey (created with Survey123 Connect 3.3.51) works on my laptop (lenovo Windows) but crashes at certain questions within the survey when trying to use it on an iPad.  I have been able to add 54 records with a windows machine but can not add one record with iOS iPad to the same survey. Survey123 Field app 3.3.64 I have removed the Repeat_Count references as mentioned in other posts, republished and it is still crashing on iOS. suggestions? ... View more

might be related to number of repeat records not matching... I have tested and when number of repeats for sampling is the same as the number of repeat records for Results the survey seems to work fine. ... View more