Latest Contributions by erica_poisson

Perhaps since it is a second survey Survey123 doesn't view it as an "edit". I wonder if you could revert the Survey123 Setting>Webhook to trigger event=new survey and add a conditional to your Power Automate webhook to control when it is triggered.  I have only done this workflow using a single survey for submitted and edited records. ... View more

Hi Doug, It looks like removing the relevant statements work, however this isn't practical for me as I have 282 fields - imagine the nightmare. I want my users to only see the fields relevant to the violation code they have selected, hence the relevant statements.  I really just need a way for the relevant statements to stay in place but to ensure that all 282 fields are 0 even if they haven't been "activated" via the relevant statements so that my sum statements work. Then selected violations would get some # greater than 0. I was hoping a calculation could help with that, but I haven't figured out the proper calculation either inside the repeat or outside of it.  Ismael Chivite‌ - do you have any thoughts on this problem? ... View more

Hi Dave, For your second webhook, did you go into the Survey123 website and the view the Settings > Webhooks for your survey? You need to modify the webhook's settings here so that trigger events = existing record edited. Until you do this, this webhook will not trigger properly when data is edited.  ... View more

Hi Paul Sweeney  - Somewhere between testing this and publishing this things are not working. I am feeling extra dense about it at this point. I have got to be missing something simple - I just can't figure it out.   I created 31x3 questions within my repeat (one per violation code per type of thing [citation, written warning, violation]) - totaling 293 fields within the repeat to deal with this. Outside of the repeat, I have 31x3 calculations with the sum (field1) + sum (field2) + sum (field3).    These still do not work properly when a violation code (e.g. 2a1) is not filled in for each of the three options. I feel like it is because I don't have an "if" statement calculation for each field within the repeat. I am having a hard time creating a statement that works...I basically need every single field to have a value of 0 (at least) for the sum calculation outside of the repeat to work.    I've added in these statements, but the calculation still doesn't work properly...   if(selected(${cmr_violations1}, '2a12'), 1, 0) if(selected(${cmr_violations2}, '2a12'), 1, 0) if(selected(${cmr_violations3}, '2a12'), 1, 0)   Calculation for final sum: sum(${ParkTicket2a12First}) + sum(${ParkTicket2a12Second}) + sum(${ParkTicket2a12Third})   I've also tried this calculation for the final sum, but that also doesn't work: if(sum(${ParkTicket2a12First}), ${ParkTicket2a12First}, 0) + if(sum(${ParkTicket2a12Second}), ${ParkTicket2a12Second}, 0) + if(sum(${ParkTicket2a12Third}), ${ParkTicket2a12Third}, 0)   My XLS is here if you would like to take a look at it.     Thank you, Erica  ... View more

Ismael Chivite‌ I am wondering if it is possible to calculate the statistic sum for multiple fields.  I am attempting this syntax - ${WachusettSudbury_Region_Daily_Patrol_Log | stats:"sum,SumCMRViolations2a12" + "sum,SumParkTicket2a12"} When I upload my report template, I do not get an error. I am also able to generate a report, however the output is: [objectObject]. I am wondering if this is not possible or if I am doing something wrong.  Thanks! ... View more

Ismael Chivite‌ - the blog post is great. I figured out that the error I received above was related to "curly" quotes. Thank you for including how to disable that in Word!  ... View more

Hi Survey123 team, I am attempting lots of repetitive calculations and running into some issues I hope you can help with.  I am designing a "Daily Log" survey where the repeat is for creating multiple "Log Entries". Each entry can record up to three violation codes; our violation code list consists of 31 choices. For each violation code, the # violations, # written warnings and # citations can be recorded. Violation codes can be collected in any order, in each entry. Sometimes there are no violations in an entry. Sometimes there will be 1, sometimes 2, sometimes 3. They can be recorded in any order. See example in photo 1 at bottom. I am attempting a series of calculate questions outside of the repeat so that we can determine, per violation code, the # violations, # written warnings and # citations. I am running into issues because if (using photo 1 below as an example) my "select first CMR violation type" is 2a1 in my first repeat "entry", but my "select first CMR violation type" is 2a2 in my second repeat "entry" it is adding them together anyways - giving me an incorrect total.  These calculations work correctly if my "select first CMR violation type" is 2a1 in my first repeat "entry"; if in my second repeat "entry" I leave "select first CMR violation type" blank and then select 2a1 as my "select second CMR violation type" - in this situation, they are tallied properly.    These are the calculations I am using: Each calculation also has a relevant statement for the correct violation code. This is what my repeat looks like: I am happy to share my XLS if anyone is able/willing to help! Thank you in advance!! Photo 1: ... View more

Hi Ismael Chivite‌, I look forward to the blog.  I am attempting this on one of my surveys and am receiving an error when generating a preview report. Oddly, the syntax is approved when I upload my template. Here is the error: Here is the report template syntax: This is all placed within a summary section.  ... View more

Hi Ismael Chivite‌ -  Is it possible for the hydrant summary report template showcased in the blog above to get shared so users can see the syntax?  ... View more

Hi Karl, I actually opened a support case with Esri around this because it was such a painful experience for us. We did so many different rounds of testing. When the most recent version (20.2.2) was released, the problem seemed to go away and we were able to stream long line features without the program crashing. So, whatever was wrong seems to have been fixed. So far we've had good success!  Erica ... View more

This is great! Just a heads up, the instructions on updating report template syntax to deal with multiple photos per image question is different than it is stated above. I could not get the syntax above to work, however the syntax from the report template help did work: ... View more

Thanks James; I didn't think to look there as I just got the notification today and thought it corresponded with this update.  As to my other question - does this 3.10 update support the full payload on edit when using Power Automate?  Thanks!  ... View more

Hi Ismael Chivite‌, At the UC it was mentioned that this released would support the full payload being sent to Power Automate on an edit operation. I don't see anything mentioned about this in the blog - is this now supported?  I also received an email that BUG-000126498 has been implemented, but I do not see it in the list above. I'd just like to confirm that this has been corrected with this released.  This is an exciting update! Thanks for all the great content around it! Erica  ... View more

Sorry - I did a poor job wording that. I was basically wondering about the repeat count in the lookup, which by your expatiation above seems possible. This is something I will dig into.  Thanks for you help and patience.  ... View more