Latest Contributions by Jean-YvesLandry1

Still travelling but I'll try to summarize best I can here: PART 1: CREATE TOKEN    ArcGIS for Developers  Sign into the same AGOL account that holds your survey feature layer Select New Application            d.Give your application a name, then click "Register"          e. Note the Client ID and Client Secret IN EXCEL:  Insert three Tables  Enter the Client ID and Client Secret you just copied from the application you just created. I like to name my tables; From Top to bottom:  AGOL_ACCESS, Token_auto, Hosted_FS0 ... View more

Just saw this, I'll put together the how-to to help you out. ... View more

Hi Michelle, I believe I removed this {"editMode":1,"globalIdField":"globalid","objectIdField":"objectid"} ... View more

Found a Solution on updating repeats within repeats.  I added the fields through Arcgis online, then republished the survey on survey123 connect.  Connect did not need to add the 2 new fields and only needs to update the form.  Perfect. ... View more

Ok so I've pinpointed the publish error... it is when I try to add a field to a repeat within a repeat. Is there any way I can do modifications to this repeat within a repeat? ... View more

I'm getting a similar error when I add a new variable to my survey. Ran a log and the error I see if <12>1 2018-12-10T20:11:24Z RPTORWK008 Survey123ConnectforArcGIS 9176 - [AppStudio@11205 category="default" filename="PublishSurvey.qml" line="511"][check] qrc:/qml/Connect/PublishSurvey.qml:511: TypeError: Cannot read property 'fields' of undefined any idea? ... View more

Ok so I figured it out,  I thought I could save some time by having the relevance on a group containing the required questions, but it looks like you need a relevant logic on each required question in order for them to be validated. ... View more

Thanks James, note that there are many null columns.  ... View more

I'm using version 3.0.127 and I'm still having this error, required questions within a group that is not relevant are being flagged ... View more

I can't share publicly, but message me privately please.  ... View more

  I was thinking of using a word template, fill in using the the output from the web hooks, then send it as a report through email.  I however don't see the attachments (imagery) as an output in the webhooks. Is this possible? ... View more

Wanted to add that with Excel powerquery you may also show the URL to your hosted feature attachments.  1) Create the Query to your attachment table 2) Customize a column; = SERVICEURL &  parentObjectId & "/attachments/" & attachmentID & Token You can then open all your attachments using the hyperlink from your custom column (note that your token will need to be constantly refreshed). BONUS: With a little VBA you can then download all your photos to a local folder using the attachment URL. (modified from excel - Convert code for 32 bit to 64 bit - Stack Overflow ) *update: Added a line to add images that are not already present in the folder, reducing downloading time. Option Explicit Private Declare Function URLDownloadToFile Lib "urlmon" _ Alias "URLDownloadToFileA" (ByVal pCaller As Long, _ ByVal szURL As String, ByVal szFileName As String, _ ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long Dim Ret As Long Sub Download_image_structure()     Dim ws As Worksheet     Dim LastRow As Long, i As Long     Dim countupdate As Long     Dim strPath As String     Dim FolderName As String     Dim fs         Set fs = CreateObject("Scripting.FileSystemObject")         FolderName = "W:\IMAGES\STRUCTURE\" '<-- folder where images will be saved     '~~> create folder if it does not exist     If Len(Dir(FolderName, vbDirectory)) = 0 Then     MkDir FolderName     End If         '~~> name of sheets with image to download     Set ws = Sheets("STRUCTURES_PHOTO")     LastRow = ws.Range("A" & Rows.Count).End(xlUp).Row         For i = 2 To LastRow '<~~ 2 because row 1 has headers             strPath = FolderName & ws.Range("F" & i).Value                         If Not fs.FileExists(strPath) Then '<-- if image does not exist in folder then skip to next                 Ret = URLDownloadToFile(0, ws.Range("I" & i).Value, strPath, 0, 0)             countupdate = countupdate + 1             End If                 Next i     MsgBox countupdate & " added images" '<-- how many image added to folder End Sub‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more