Latest Contributions by MikeBruening1

Here is something that can help you out possibly. ArcGIS REST API | ArcGIS for Developers  Also, one other thing to think about would be the possible use of a "webhook" to help transform the Survey123 data submittal JSON into an "AI readable" format that you need. "Integromat" or "Power Automate" are two possibilities for webhooks that could parse or translate the JSON into the AI format that you need? ... View more

Currently, the XLSX form will not contain the "theme-grid" within the "appearance (column I) field" drop-down selection on the "survey" tab. Instead you will need to place "theme-grid" into the "style (column G) field" within the "settings" tab of the XLSX form.  The "appearance (column I) field" drop-down selection will not contain the "w#" value in front of the appearance choice either. You will need to select your appearance type first, then double click within the field, add in the w#, then hit return and select "yes" to the non-standard input question you will be prompted with. In terms of updating your form to contain the "table list" and other functionality, you should be able to follow Doug's instructions from his linked post. That is the way I have done things since Survey123 was released and it seems to help with updating the forms. However, this could be a potential enhancement for Survey123; to update an out-dated XLSX form to the most recent standard XLSX form that would be created by the most current version of Connect. ... View more

Samir, this can be done and you would use the method that James outlined with the appearance of the question. Then within Survey123 Connect you could do the following - Use the Grid Theme appearance on the group that contains the question you want to have three responses to. Create a note question to hold "What are the top three sellers? Create 3 questions that are text fields and have a Distinct Field Name TopSeller1, TopSeller2, & TopSeller3 for the "name" column Within the "Label" column add in 1., 2., and 3. for them to rank what are the top sellers. You might want to make each of these required; that's up to you. Then you could also have a third field that is hidden that will concat() all 3 answers into one field. You could also set the "bind::esri:fieldType" to "null" for the three questions that will contain the rank and they will not be submitted into your Hosted Feature Service. I have uploaded an example XLSX form for you. Good Luck, Mike ... View more

I have a quick question for what you are attempting to truly accomplish with this post? Are you wanting to add in multiple photos to the initial survey or do you want to have a true repeat that contains other questions along with the photo? If you are attempting to just add multiple photos to the original survey, then this should be fairly easy to accomplish. However, if you are in need of adding a repeat to record additional information, then this is might be more challenging to accomplish and requires some testing. I know that if you are simply attempting to add multiple photos to the initial survey feature geometry, then you could do the following - Login to ArcGIS Online and find the details page for your survey's hosted feature service Then you will need to "Enable attachments" for the Survey Feature service Open Survey123 Connect Open the Excel spreadsheet used and add in multiple image questions. Keep in mind that the photos will inherit the question name as part of the attachment/photo name. SurveyPhoto1 SurveyPhoto2 SurveyPhoto3 SurveyPhotoX Republish your survey Re-download the survey to your field app and open the form You should be able to add in multiple photos for the survey. I have tested this above and it works as expected. If you are looking to enable a repeat that creates a related table to hold additional information, then you might be able to complete this is a different manner and I am unsure if this would work? I have not tried this, but in theory (PLEASE TEST ON A SAMPLE DATASET) you should be able to download your hosted feature service Open this copy within your Desktop or ArcGIS Pro Within the FGDB that you downloaded you would create a new table Name of this table will be used within the repeat question within the Survey123 Excel file Create all of the data field names(name column in S123 excel) and associated alias's (label column is S123 excel) that you want to capture within the Survey form Take notes as you will in turn use this same exact data field schema within your Survey123 Excel file Create a data field that is named "parentglobalid" and is a "GUID" data type Within Catalog you will need to create the relationship to match that of Survey123 uses for the HFS created by Connect. Name of the Relationship Class will be the same as the Table that you created above Origin Table/Feature Class would be the Survey Feature Class Destination Table/Feature Class would be the new table you created. Type of relationship would be "Composite" Accept defaults for labels Notifications would be "None" Cardinality would "1 - M (one to many) No, I do not want to add attributes to this relationship class. Primary Key would be the "globalid" field from the Survey Feature Class Foreign Key would be the GUID field from the table you created named "parentglobalid" Now I would pull this Feature class and the newly created/related table into ArcMap or ArcGIS Pro and test to see if the relationship has been established. If all is good, then you will need to publish this while "Overwriting an Existing Feature Service" (THIS is why it is important to test this out first). The idea is that since you downloaded the original dataset and are using it to overwrite that you would not loose any of the data. However, I do believe this could interrupt any other web maps, web apps, operations dashboards that are using "pop-ups". You will need to recreate them. Within your Survey123 form you will have to do the following Open the survey form. Add a repeat that contains the same name as the new table you created. Add in all of the data fields and have them match the data schema exactly Add in an image question Try to republish your survey and hopefully it works. Then download the re-published survey form and test out the form. This is very tricky in nature and I have NOT tested the second option on a live service, but it depends on what your end goal is for this survey? The original survey with multiple photos attached to the feature being created (option 1) or a survey that contains one feature with a related table that contains additional information along with photos? Good Luck! Mike ... View more

The likert appearance does work within the Survey123 form, but I believe you will need to use the "begin group" while having the appearance set to w4 or whatever number you are using for your columns. Then when it comes to the question that would use the likert question; just make the appearance be "w4 likert" and it should fit the scale within that cell. ... View more

This functionality is not within the form yet, but I wonder if there would be another way to structure your query string to trim down the number of returned surveys? ... View more

Yuko, You can achieve the functionality that you are looking for by completing the following from this page - Prepare for editing existing survey data—Survey123 for ArcGIS | Documentation The following paragraph is about a quarter of the way down the page, but make sure that you read through the documentation to include repeats if your survey has them. Inbox queries also support the username variable, to cause the inbox to only be populated by surveys that match the user's ArcGIS named account information. This variable must be specified in the same format as XLSForm expressions, so for example, the query Creator=${username} would search for all records created by the currently signed-in user. Cheers, Mike ... View more

This looks very promising for something that I will be attempting to do with one of my surveys. I have one question about the use of this function and it pertains to being offline. If I have a worker out in the middle of nowhere without connectivity to the internet, then will this function still work or is this a function that requires you to be connected to the internet? I am guessing there would be a need to be connected in order for it to work. Thank you for posting this for other to use. ... View more