Latest Contributions by LynnBerni

Is there a way to open up an excel sheet from within a survey, and then have a field in the spreadsheet populate a field in the survey?  Specifically, we have a simple streamflow calculator, and "Avg Flow (CFS)" is what we want in the survey. ... View more

The feature services for the three “test” surveys were created by Survey123 connect directly in AGOL The existing feature service for the SDE survey originated from our ArcGIS Server (federated Portal something or other) ... View more

Thanks for the speedy reply!  I'm fairly certain it's the GlobalID's that are holding us up.  We've resolved the first two items on the list. What I'm not clear on, after reading this post and all comments, is the correct way to add  the"parentglobalid". Is it enough to add a GUID field in my related table and name it "ParentGlobalID"?  Will it then be populated automatically when surveys are submitted?   Or do I need to include hidden fields in the survey to capture the globalID and then transfer that to a parentglobalID field in the repeat? ... View more

Hello James, Thank you for your succinct summarry [Dec 7, 2017] of the comments in this post.  Per your notes  "Next is to make sure that the form can accept the GlobalID of the parent in the form."You will then need to manually add the parentglobalid field (or other name for the parent key field) to the survey as a question " ,  I am attempting to follow the steps outlined in Chris Goessel's comment [Jan 16, 2018].  But I am unsure as to how to create the URL connection to the survey.  I've built my survey on an existing feature service in our internal Portal. Here's my submission URL: https://www.slcounty.org/gisportal/sharing/rest/content/items/659e2a7851494f0b84c0de1f89eff7b2. I have another survey that is working just fine with this submission URL, but it doesn't have repeats! Also, I have not yet been able to publish this survey, as I keep getting the following error: "The Feature Service does not meet the requirement for a survey with repeats - supportsApplyEditsWithGlobalIds".  Which is why I am trying to setup the GlobalID and ParentGlobalID correctly.  I think that's the key to my problem. Also, once I do determine the correct custom URL scheme, where exactly does that information go in my survey??  In the calculate field? Please advise, Thanks! Lynn ... View more

I ended up adding a new field to capture the start date of the survey, and then referenced that in the calculation. And it worked!  So that may have basically had the same effect as your suggestion.                            ... View more

Hi James, I am attempting to generate a unique BATCHID that gets copied in to multiple samples in a repeat.  I'm finding that wrapping with the once() function is not working. Each sample in the repeat has a different value (time) in the BATCHID2 field.  My calculations: BATCHID :    concat('BATCH ', format-date(once(now()), '%Y%m%d %H%M%S%3')) BATCHID2 (in the repeat):    ${BATCHID} Both are "calculate" field type. Not sure if this is relevant, but the value that gets recorded for BATCHID matches the BATCHID2 value for the last sample. ... View more

Hi James, Here's a sketch of the data relationships in our database, which you might find helpful.  As mentioned, I want to build a survey to populate the Bacteria Batch TO Bacteria Samples tables.  One batch, multiple samples processed per batch.  ... View more

Yes, our SampleSites points are independent of BacteriaBatch. And yes, we have fields to store the relationships.  For each batch, we collect multiple samples (one sample per site). The BacteriaBatch ("batch-level") data pertain to all samples in the batch (e.g. date/time/incubator temp when all samples go into the incubator, date/time/temp when they come out, expiration dates for the bottles used to collect the samples, staff that collect & process the samples, etc.).  Data recorded for each sample (in the repeat) includes things like date/time collected, weather, results after incubation, etc.  One batch, many samples. I haven't yet explored the Inbox functionality, but we do record batch level data and individual sample data on both days.  We've been saving the survey as a draft on Day1.  I'm not sure how to get away from the repeat, and thus the need for a related table....if that's what you meant by two forms. ... View more

Can I publish a survey based on related nonspatial tables in an existing feature service? I need to create a survey to populate the BacteriaBatch/BacteriaSamples tables: SampleSites (points) === 1:M ===> BacteriaSamples (table) BacteriaBatch (table) === 1:M ===> BacteriaSamples (table) Here's more detail, if needed: Currently we collect field data on paper forms, and then manually update an Access database. We're working to streamline this process, but we want survey data to populate SDE (not my AGOL).  I've built the survey to collect our Bacteria data in Connect, and its working great in my AGOL...but creating everything "from scratch" in SDE is a little more complex. Relationships are so confusing!!  I'm attempting to model things so we can use Survey123. Bacteria Survey We test for bacteria (ecoli, etc.) each month and it is a 2-day process. Day1:  Samples are collected at multiple sites (one sample per site) and then processed as a batch in the lab. Day 2, the samples are taken out of the incubator to see what grew.  Based on this workflow, I created a survey with batch level questions and samples in a repeat. It works like a charm and will really simplify our data collection process. But, in my AGOL the batch level data is saved as point data (feature layer), and samples are in a related table. What we need is both as nonspatial tables in SDE. From the original blog post, the example of collecting parcel assessment data that would populate the related table only---by changing the form_id in a survey created from an existing feature service (which has spatial data with a related table) and deleting all questions that point to the spatial data---makes perfect sense. This is exactly what we need! But will it work if both are nonspatial?  I haven't tried yet, thought would I would ask first. Hope this makes sense. Please advise, thanks! ... View more

Hi James, Are you referring this note from https://community.esri.com/groups/survey123/blog/2017/09/25/working-with-existing-feature-services-in-survey123-for-arcgis? ... View more

Yes!! That solved it. Any idea why this happened with one layer, but not another? Thanks John :^D ... View more

Hi John, Both of the surveys that I mentioned have multiple image questions. As you can see from this screenshot, the photos attachments in the StabilityPoints survey are clickable links in the popup in Pro.  Lynn p.s.  [...5 min later]  This is truly bizarre, but now I can't see the StabilityPoints photo attachments at all in my Pro map popups!  I can, however, still see the thumbnails in FieldParameters. p.p.s. what happened to all of our previous comments? ... View more