Latest Contributions by LynnBerni

In the following screenshot, the fields 5 & 6 are calculated based on data in fields 1-4. The whole group (fields1-6) is relevant as to whether or not a sample is collected. But, when no sample is collected, the calculated fields are returning 0.00. I would like them to be blank. Is there a way to control (cancel) the calculation when the relevant expression is not met? ... View more

Our current workflow for data entered in the field is to "send later", and then send all from the outbox when back in the office. We're testing a new survey which includes a count limit on a repeat (8 records only). We just discovered that when the survey is opened up from the outbox and edited, all fields for the first record in the repeat are blank.  Data for all subsequent records (2 thru 😎 is still there and editable.  My fix for now?  Delete the number in the repeat_count column in the XLS form. Is this a bug? We're using Survey123 Connect v2.6.6 and  ios app v3.0.132. I could not duplicate the problem in the desktop version of Survey123.  ... View more

Hello, I am attempting to tweak the XLS form fields created from an existing feature service in order to populate two tables, but it isn't working. I think I understand why but not how to fix the problem...or even if what I'm trying to do is possible. Here's the basic structure of my data in SDE: Sample Sites (point data) ==> Related Table:  Bacteria Samples [1:M, SiteHasSamples, related on SITEID fields]   Bacteria Batch (table) ==> Related Table: Bacteria Samples [1:M, BatchHasSamples, related on GlobalID/ParentGlobalID fields]     What I want is a survey that populates the Bacteria Batch & Bacteria Samples tables only. But, since the Batch table is not related to SampleSites, it does not get included in the XLS form created from the existing feature service.  Here are my tweaks to the XLS to include Batch in the survey: delete all fields related to Sample Sites replace them with my Bacteria Batch fields keeping Bacteria Samples as a repeat change the form_id to pweng.SLCOEN.BacteriaBatch.  But it's not working. I've been working my way through each error that the survey snags on when trying to publish it in Survey123 Connect (v2.6.6).  Here's the current error:  I assume this is because I kept the samples fields in a repeat, and it thinks the repeat should be based on SITEID, but it's not anymore. As previously mentioned, I think I understand the problem but not how to fix it...or even if what I'm trying to do is possible. I really, really want to figure out how to make this survey work. The fallback option would be to have 2 separate surveys and then manually copy in the unique BATCHID to each sample processed in the batch. Not horrible, but definitely not ideal. Please help!!! Thanks, Lynn p.s.  More screenshots for context: ... View more

We have a FieldParameters survey that was created from an existing feature service on Portal (behind the firewall).  The survey is populating a related table only and has photo attachments. When I look at the data in Catalog I can see the FieldParameters table, the FieldParameters_ATTACH photos table, and the relationship class that was created by Survey123: What has me concerned is that when I open the FieldParameters table in ArcMap, and then click on the "Related Tables" button, FieldParameters_ATTACH is not in the list.  And it should be, since there's a relationship class. I have to create a relate on-the fly to check my photo attachments.  ... View more

Is it possible to open an excel sheet from within a survey, to do some quick calcuations needed to answer one of the questions?  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 answered in the survey.  Just wondering.... Thanks! Lynn ... View more