Latest Contributions by AndyHeller

Thanks Zach, I've attached a version of the XLSF with the necessary fields. What I'd like to do is take the data from the fsLog repeat, aggregate it, and send it to the appropriate record in the the stpLog repeat. The Stratum field (integer) is the common field in the repeats. The data that I'd like to pass is in the fsLog_art_sample field (text). When there is a common value in the Stratum fields, I'd like to pass the text in fsLog_art_sample to a similar field in the stpLog (I've removed this field from the survey, but it would just be a basic text field). There could be multiple fsLog records associated with a single point, as well as multiple strata. For example: STP 1-1 has three strata (A, B, C). Strata B and C each have 2 FS log records. I would like to take the data from the FS Log that corresponds to Stratum B and join it to the STP Log entry for Stratum B and then do the same for Stratum C. Alternatively, if an text field is unnecessarily difficult, I would happy to aggregate the fsLog_fs field (integer) to their respective stpLog records.  Our current workflow works like this: A technician navigates to a location and collects data. When there is a specific find to record, the technician fills out the FS Log repeat. The summary field (fsLog_art_sample [text]) is then joined back to a field in the main feature service - art_sample (text). Later, we go through and join the fsLog data to the stpLog based on the stpID and Stratum fields. Note this is only important when the stpLog is relevant (pointType = 'stp', 'tu' or status = 'auger', 'soil_prob', 'trowel_test', 'trench', or 'scrape').  Best, Andy ... View more