Latest Contributions by BrandonA_CDPH

‎06-09-2023

Thank you. I think this is the solution moving forward. For this form, I think I'll have to calculate a field in Pro to retain the current data, reconfigure the dashboards, then republish the data. Little more work, but a good note for the future. Live and learn. 😬

‎06-09-2023

Thank you for this idea. Unfrotunately, this has the same effect. The Update and Edit date for the appended data still shows when it was appended, not originally created.

‎06-06-2023

Core issue: I have Feature Service data downloaded as a FGDB. I need to append the data into a layer with the same schema and am looking for a way to keep the EditDate and CreationDate fields the same as when they were downloaded. Currently they are updating to the date and time the data is appended. I use these fields for other analyses, so if they change, it doesn't work. Longer explanation: I have a Feature Service fed by an existing Survey123 Form. I have a special project that needs to use the same form (and collect some additional data), so I am trying to make a related table to store the project-specific data. The way I have figured out to do this is by creating a repeat to store the project-specific data. When I publish the form with the additional repeat, the Feature Service is rebuilt and the data is erased. So, to get around this, I found a workaround that involves downloading the data as a FDGDB, republishing the form (eliminating the existing data), then appending the data back to the rebuilt Feature Service. I think this will work for my needs. Problem is that when I do this, the EditDate and CreatedDate fields are recalculated to be the date and time the data was appended. I need to preserve the original values since I use those to filter dashboards and for other analyses. So, if you're read this far and aren't lost yet, any ideas on how to maintain the EditDate and CreatedDate values? Also open to other ideas for relating this separate special project data to the data in the main form, but I think I have exhausted those options. Thank you in advance for the assistance.

‎05-10-2023

That could work.. I haven't experimented with delayed actions in Flow, so I'l lhave to look at that... 🤔 I was hoping to generate a summary report on a schedule (say monthly) and pull records from the previous month. Right now, users go into the Survey123 Website's data tab, select the records they want, then run the report from the Report Menu. Trying to automate that "select" action, then generate the report for the selected records.

‎05-09-2023

@SeanKMcGinnis - thank you for the great workflow. I know this is an older post, but it addresses exactly what I am trying to do. I, unfortunately, do not have access to the "Get Data From Feature Layer" action as it is a Premium feature. IS there a way to do this query without that action?

‎05-08-2023

Putting my support behind this! I would be willing to manually create two color schemes (light and dark) so that users could choose, but I don't have to maintain two identical (but color inverted) forms. This would also be helpful for accessibility as I could design a "traditional" form and a "color-blind" version(s). Besides the toggle (which I really like), another possible solution would be the ability to automatically update two forms at the same time (i.e. changes to the "light" form are automatically transferred to the "dark". This would look the same as it does now for the user (Form XYZ Light and Form XYZ Dark) but would prevent errors when updates are made on one version and not the other. Next level would be if it could dynamically respond to the OS settings (i.e. dark mode on the phone), but that may be level 2.

‎05-02-2023

I second this idea. I too have fields that are entry fields, but you are required to navigate away to commit the answer. On the computer, it's not so bad since users just have to press "tab". On a phone, it can be much more complicated because with the keyboard up and the field at the top of the screen there isn't really enough real estate to tap "away" from the field and commit the answer. @AndreaPecharich- As a workaround, I developed a form that had a "gatekeeper". After the field that was behaving the way you described, I had another integer field that wasn't actually recorded (Field Type - Null). That field had to be >0 in order to show the rest of the form. A little clunky, but it served the purpose. - side note: I actually made it into a "game" with a random number generating question and a note that congratulated you if you guessed the number right. Users were at least amused by that. 😁

‎05-02-2023

@IsmaelChivite - that's a great solution. Thank you so much! 🙂

‎05-01-2023

@IsmaelChivite and @JerrySneary - I have a slight variation on this theme. Is it possible to make a question/group visible dependent on whether they have a AGOL login or not. Thinking of somehting like this: - If they are an internal user (and have a login), record name and email automatically - if they are an external user (not logged in), ask for name and email. PS I really appreciate when these posts get the juices flowing about how I can make forms better. Thanks @JerrySneary for giving me inspiration.

‎04-28-2023

Thank you @DanielR. I was searching all over for this! Simple and effective - I should have known! 😀

‎04-25-2023

I would also like to see this. I have a dashboard of product recalls. It would be great to use this to visualize which suppliers have the most issues.

‎04-24-2023

I would like to add another use case, related to the one from PeterKnoop. The described overlay could also be a partially transparent version of another image from the form. Thinking about taking "panoramic"-type overlapping photos.

‎04-24-2023

I would like to add a slight variation as s use case. I would like the ability to edit/update a form in the Web Designer, even when published with Connect, even if limited to the capabilities in the Web Designer. For example, if I have a form that is published through Connect, I would like the capability to add fields without advanced features or move field orders using the Web Designer. I could return to Connect for the more advanced features, but would be able to make basic edits in the Web Designer.

‎04-17-2023

This would also help me. Currently, users have to download the excel file with all fields for the selected records. Then, they have to go through the additional step of removing unneeded fields for our laboratory reporting. Having preset templates for Excel export would greatly improve our workflow. With the addition of automated report generation (with third party integrations), this could be amazing! I'm picturing this workflow: Set up spreadsheet-based report format --> Collect data --> automatically generate report in a spreadsheet (csv, Excel, etc) --> email that excel spreadsheet directly to the laboratory.

‎03-06-2023

I have used the method in this blog to rename photos and it works great! it takes a little work in Connect, but I think it will do what you're describing. - Survey123 Tricks of the Trade: Set the file name of photos and signatures (esri.com) My particular form has a sample Identifier for each entry. For each photo, I have the name set to "Sample ID - #" so that each photo has a unique name (S45-1, S45-2, etc). I didn't have the unique name for each photo at first and it did not work right (the blog points this out, but I missed it at first), so be careful of that. The general workflow is as follows - this has to be done when designing the survey in Connect: 1) Enter (or calculate) the desired filename. 2) set the filename to the calculated field using the bind::esri:parameters column and the fileName=X parameter 3) when the survey is filled in, the name of the photo is changed. Hope this helps.

Online Status	Offline
Date Last Visited	Monday

My Ideas

Latest Contributions by BrandonA_CDPH

Re: ArcGIS Online - Append Data and maintain CreationDate and EditDate

Re: ArcGIS Online - Append Data and maintain CreationDate and EditDate

ArcGIS Online - Append Data and maintain CreationDate and EditDate

Re: Recurring Summary Report from Survey123 Using Microsoft Power Automate

Re: Recurring Summary Report from Survey123 Using Microsoft Power Automate

Re: Light Mode & Dark Mode for field app

Re: Data entered in form not coming over after submission unless focus is shifted off of field.

Re: Survey123 Tricks of the Trade: hidden, relevant and body::esri:visible

Re: Survey123 Tricks of the Trade: hidden, relevant and body::esri:visible

Re: Give a survey creator the ability to remove the 'collect' button, so I can direct users to use the Inbox only

Re: Word Cloud for Operations Dashboard for ArcGIS

Re: Custom Overlay Image For Camera Viewfinder In Photo Questions

Re: Survey123 Web Designer should have all Functionalities of Survey123 Connect Progressively Included and Integrated

Re: Enable the use of Excel in report templates

Re: Survey123 Tricks of the Trade: Download survey data (with attachments)

Re: Music from 2025 User Conference

Music from 2025 User Conference

Re: Data is Null Error

Data is Null Error

Re: 2024 Staff Engagement Appreciation

GIS Jobs