Latest Contributions by DerrickWestoby

Same here. The issue seems to be resolved

‎08-10-2023

‎08-10-2023

Good Morning, I have a Survey123 form that has been in use for about 3 or 4 years, mostly with no issues. Part of the form includes the weather.js script provided by @IsmaelChivite in a blog post (this is a more recent blog post. I can't find the original one I used when javascript functionality was first added). Some time within the last month, some users (myself included) noticed that the weather data was no longer being included in the generated feature reports. After some digging, I noticed: * The fields that the feature report draws from are empty when viewing the feature service data page: Even though the data is present on the mobile form when submitting (Verified on 3x different devices. Also, the presence of the value in "Weather" column in the screenshot above shows that at least that field is working, which runs off the same script and pulldata functions) Odd behavior noted: The users/devices that have values not being submitted to the feature service can be identified ahead of time here. The group header/summary reports the field values, if available. Some users, like myself, do not see the field values here: Others do. The people that can see the values in the weather summary are the ones where the values are actually being submitted (everything works as expected) Hand-entered values work as expected and are submitted to the feature service (deleting the calculated value and then clicking the recalculate button does not work, however) : And here is how the values are calculated for the fields: And the summary: Any help would be appreciated. I assume it has something to do with a calculate setting. If you look at the screenshots of the mobile form that works vs the one that does not, the text color of the fields is different. If I remember correctly, that has something to do with an auto-calculate/re-calculate setting, but it's been awhile since I messed with that. It is odd that they are different on different devices though, since everyone is using the same version of the form. Thanks.

‎12-13-2022

Thanks Jimmy, this fixed the issue for me. The problem did start about a week after using "Optimize Layer Drawing" setting, but method=vertex still didn't work after disabling, it, pushing an update and trying a new submittal. removing method=sketch from the geoshape question works fine now.

‎11-16-2022

Left work yesterday with no resolution. Came in this morning and everything is working again. I wish the lawn would mow itself while I'm asleep, too.

‎11-15-2022

In the process of lighting some candles and looking up the chant to summon @Anonymous User the log file whisperer.

‎11-15-2022

Good Morning, I have a survey that's been up and running for about a year now, and I haven't made any changes to it for a couple months. The last successful submission was yesterday. As of this morning, all users are getting an "operation rolled back" error when trying to submit. Log file is attached, but I'm not used to picking through these and nothing is jumping out at me except this (which I'm not sure how to address): { "code": 1003, "description": "Operation rolled back.", "tableId": 0 }, { "code": 0, "description": "Invalid object name 'user_20440.service_62b31b57ac52464886b44afbab1d82df_GENERAL_NOTES__ATTACH__tracking'.", "tableId": 1 }, { "code": 0, "description": "The INSERT statement conflicted with the FOREIGN KEY constraint \"FK_service_62b31b57ac52464886b44afbab1d82df_GENERAL_NOTES_5DE05BDC\". The conflict occurred in database \"db_20440\", table \"user_20440.service_62b31b57ac52464886b44afbab1d82df_GENERAL_NOTES\", column 'globalid'.\r\nThe statement has been terminated.", "tableId": 1 } ] Any help would be greatly appreciated. Thank you

‎08-09-2022

I have about 10-20 surveys going through Integromat/Make a day now. This error (on established surveys and feature report templates that haven't changed in months) is one of the ~10 errors that pops up regularly that's always fixed by re-running the report generation. If it's not resolved, I'll wait 20 minutes and run it again. I know that's not exactly a "solution", but I'm just trying to point out that it might be a server side issue that will self resolve. I added a sleep module between the webhook and report generation hoping the issue would resolve, but that doesn't seem to have changed anything either. Long story short - make sure it's not a server side issue before you spend 3 days troubleshooting. Failed - The 10:15 run that threw an error is the screenshot above. 10:19 was after restarting the scenario. No changes to report template, feature service, survey submission, etc. successful

‎03-23-2022

Lake (Contains count of nets) -Net (Repeat) (Contains count of fish in net) --Fish (Nested Repeat) Is that correct? Why do you have once() included in one of your counts? That will prevent the count from updating as you add more fish/nets. If that's not your problem, you could make your "counts" relevant to some toggle-question, such as adding this to the relevant column: ${recalc_toggle}='calculate_it_again' That would allow you to keep once() in your calc (assuming it's there for a reason) and give the user an option to recalc when needed instead of automatically.

‎03-23-2022

As @BarbaraWebster1 said, the recent enhancements would allow you to print a map that contains all of your geopoint. If you combine it with a referenced web map ID and drawingInfo=currentLayer, you could hide all of the geopoints on the generated map as well. Prior to that feature being released, I was doing what you're after by generate an extent geoshape by calculating the min/max lat/lon values and then using that polygon for report generation, instead of the geopoints. (I'd still recommend using the recently-released feature Barbara linked, though)

‎03-03-2022

I'd need to see the result of the scenario running to make a guess, if what you have here isn't working (your screenshot looks correct). This probably isn't an issue, but just to rule out a few potential problems....delete what you have entered in "Output Report Name". Save your scenario, click "Run Once" in the bottom left, and then send in a test submission. My screenshot below is what what I need to see in your scenario. "Details" should give you an error message if the report fails to generate, and that error message is your clue. If the report succeeds to generate, you'll see the URL to download it like in my screenshot

‎03-02-2022

This is a quick reply because I'm on my phone....but I'm wondering if I misinterpreted your question. Are you just asking if you can geocode a polygon in S123 to store the address info in fields? If that was the question....no. but you could have a null geopoint in your survey and geocode that. And if you want the link in the pop-up to pre-fill some survey123 questions via url parameters, no you do not need a common field to join them (for it to function, at least. Its a good idea just to have one available though). If you want to use the link to launch a S123 form where you are editing the existing polygon feature (instead of creating a new feature), yes you would need to reference the objectid or globalid, along with enabling edit mode. If you want the pop-up to be updated with whatever information you're putting into the survey123 form, you would not need to create a link/join field to see the info from s123 if you set it up to edit the existing polygons. That link would have been handled when you launch the s123 form to edit. If you want to view the submitted info in the polygon pop-up and the s123 form is set up to create new features with a common join field, then yes, you'll want that available (and globalId is a good idea).

‎03-02-2022

Yes I did. I edited the resolution into my last post, but here it is as well. (use "predictivetext multiline", NOT "multiline predictivetext") EDIT for posterity: This was confirmed as a bug (BUG-000146779), but using "predictivetext multiline" in the appearance column (instead of "multiline predictivetext") does work. While troubleshooting, we noticed that "multiline predictivetext" will work if it's present when the survey is first published, but not if it's changed after first publishing.

‎03-02-2022

(This is just some info to move you in the right direction. I haven't used MS Flow and my workflows are normally the opposite of what you're doing) "Multiple emails for each line in the repeat table" This is resolved by using an array aggregator to combine each bundle into one. Sorry I don't have a screenshot to show you how it would be configured in Integromat. I do the opposite with an iterator, so that I can add each record as a row to a spreadsheet (which would cause an email to go out for each record, which is what you're seeing). On the off chance it helps to, here's a screenshot of how my iterator is set up by pointing at the repeat table: Once you get all of your repeat records aggregated to a single bundle, it'll end up sending out a single email instead. "Only email the last repeat section" I'm not sure if this means that you only want to email the aggregated repeat table (meaning every record in the repeat combined into a single bundle) or if you're saying that you want to find the very last record in the repeat and only email that one. If you're after the latter....you can ignore the first part of my post since you won't need to aggregate all those records into one. You would need to find the max() index of the record in your repeat and then set up MS flow to only email the record for that index position. I'm not sure how this looks in MS Flow, but in Integromat you could insert that index position here: (Sorry if this post isn't much help - I spent a lot of time trying to figure out how to work with the repeats when I first set up integromat and I would have saved a lot of time if I'd know iterators and aggregators even existed.)

‎03-02-2022

Try this instead: arcgis-survey123://?itemID=7f0e5eb93d424c1ea532da3d684c6a75?field:plot={st-cty-plt} The first URL parameter needs to be preceded by a ? Subsequent parameters should be preceded by a &

Online Status	Online
Date Last Visited	2 hours ago

My Ideas

Latest Contributions by DerrickWestoby

Re: Print fail started overnight

Re: (Inconsistent)Fields with values entered not being submitted to feature service

(Inconsistent)Fields with values entered not being submitted to feature service

Re: Send error: Polygon input not valid

Re: Operation rolled back (No recent changes)

Re: Operation rolled back (No recent changes)

Operation rolled back (No recent changes)

Re: Survey123 feature report error Cannot read property 'width' of undefined

Re: Counter within Repeat

Re: Print the mid (or central) Geopoint of a repeat in a map in the report and hide the marker

Re: Bundle Validation Error Survey123 and Integromat

Re: Get address/location details onto Survey123 from a web map object

Re: I can't get predictive text and multiline text working at the same time on Survey123 on Android app.

Re: Survey123 Power Automate email with repeats

Re: Simple prepopulate survey123 field from URL not working

Re: Survey123 Email Attachments using Gmail in Int...

Re: Position(..) malfunction in repeats in survey ...

Re: Survey123 Power Automate email with repeats

Re: Survey 123 feature report - filter map using g...

Re: Survey123 feature report error Cannot read pro...

Imagery and Remote Sensing User Group