Latest Contributions by GISAdminGKB

We had the same problem since last week. But we could solve it by setting the coordinate system in the environments tab of the tool. However we never had to do this before. ... View more

Hi Ismaël, Great video;s, very interesting. But where can we find the scripts as explained in the videos like the one by James Tedrick about updating attachment keywords ? It would be very helpfull if we can get these samples somewhere.   Kind regards from Holland, Dirk-Jan ... View more

Yes. We did some investigation and were able to do. Although in this way it's not respecting the relation. But according to the documentation the syntax for statistics/summary is ${layerName | stats:"outStatistics":"groupByFieldsForStatistics":"havingClause"} For LayerName you can use each layer within the hosted layer. Creating and publishing a survey with repeats will create a hosted layer with mulitple layers. Each repeat will be a layer (a table) within the hosted layer. For example. The hydrants has a repeat for the inspections. In the report you can have: ${Hydrants | stats:"count,OJBECT_ID"} (the number of hydrants) ${Inspections | stats:"count,OJBECT_ID"} (the total number of inspections)   IMPORTANT: the relation between e.g. the hydrants and inspections is not taken into account. You can do it yourselves using the WHERE clausule in de syntax. In our repeats we always have a number of fields from the parentlayer to be able to report indepently from the parentlayer. We use this fields for grouping and selecting. ... View more

Hi, What about statistics, summary and repeats (related tables). Is it possible to use stats on related tables ? In our case, using forms to collect data, most of the information is stored in the related tables (repeats) ?? However, we like all of the (coming soon) new reporting and other new features in survey123 connect and fieldapp  ... View more