Latest Contributions by KerryKang

Hello all,   I used to check our web apps' usage since the app was created in the mid april in 2020 . Last week, I realized that the usage search only offers up to 1 year range, and had to some manual calculation to get the cumulated total and average usage per day. It was quite inconvenient and I hope to get the number using Python API.    I searched some resources but I don't see any example which actually used a custom range. Has anyone done it? What all I need is total cumulated number and daily average.   Even if I cannot do over 1 year, if I can apply custom date range with Python API, I can probably skip manual calculation work.    Cheers,   Kerry ... View more

Hello Esri Survey123 team, @JamesTedrick , @Anonymous User  or @IsmaelChivite could you please help me,,,?    I am creating a web form that will use the pulldata function to retrieve the attributes from another feature layer. This is how I'd like to set up. - Survey1 is used to create a project list and its detail information such as year, client, and team members. - Survey2 is used to track hours per each project created in Survey1. I hope to use 'dynamic dropdown' for the project list but I am aware that it's not implemented yet. So the project list is coming from another CSV table hosted on AGOL. - In Survey2, when user select a project name, the project name will be used to query the attributes in Survey1 feature layer, and pullout its relevant information. This will be done using pulldata javascript as it will access the feature layer directly which will be consistently updated by managers rather than using pulldata csv. To do that, I created a JavaScript functions that query the record with 'where clause' only (not using x, y location), and I am supposed to get the attributes in json. It worked perfect when I tested in Connect and Survey123 app on mobile device, but in web form I can confirm that json result area is empty where I used pulldata @javascript, and therefore pulldata@json questions that I am using to get each attribute value are empty, too. When I tested using with 'featureByLocation' from the sample form, it worked fine on the web form. So I am not sure why my function does not work on web form, assuming that something must be wrong with my code. I used something that may not recognized by web browser??   The images below show the reusult of my javascript request in the mobile app vs. web browser.   pulldata("@javascript", "getProjectDetail.js", "featureByAttribute", ${Project_Name}, ${Token}))    Result in the mobile app     Result in the web form (empty)     This is what I did for scripting,.. sorry for poor coding. I hope to get some advice.     function featureByAttribute(projectName, token) { // Output value. Initially set to an empty string (XLSForm null) let outValue = ""; // Check to make sure both layerURL and location are provided if (projectName == null || projectName == "") { // The function can't go forward; exit with the empty value return projectName; } // I used these variables to replace '=' and ''' in url let newEqual = "%3D" let sgQuote = "%27" // Set up query parameters let parameter1 = "where=Project_Name" let parameter2 = [parameter1, newEqual,sgQuote,projectName,sgQuote].join('') let parameter3 = "f=pjson&outFields=*&returnGeometry=false" let parameters = [parameter2, parameter3].join("&"); let layerURL = 'https://services1.arcgis.com/..../FeatureServer/0' if (token) { parameters = parameters + `&token=${token}`; } let url = `${layerURL}/query?${parameters}`; ... View more

Hello all,    I am quite new to JavaScript and ArcGIS REST API and looking for some help on creating JavaScript that works for querying attribute with feature services. I hope to pull out relevant information through hosted feature layer instead of CSV pull data function. I tried the sample with intersect with geometry, but I'd like to achieve this by using attribute values.   For example, there is a store database which has store names, address, operating hours and type of store. Once I select store name from the dropdown in the survey, store address, hours, type in the feature layer would be entered automatically.    Kerry ... View more

Hello all,    Last week I asked a question regarding 'auto updating choice list' and got some directions using 'select_one_from_file' which I was not aware of. This was great! (https://community.esri.com/t5/arcgis-survey123-questions/update-choice-list-with-python-api-in-notebook/m-p/1042263#M33537)     My main goal of using this approach is automating choice list update process through Python or overwrite csv on AGOL (added as Linked content in the Connect), not necessarily going through Survey123 Connect. Based on the comment I received, it sounded like updating CSV on AGOL  will automatically update the choice list, but I do not see the expected result.   1. Survey has been published. 2. Created a csv file for external choice and uploaded on AGOL. 3. Downloaded csv within Linked Content and republished the survey. --> I can see the new list from csv. ------- 4. Overwrite csv manually with new file on AGOL. 5. Checked the survey. The selection list has not been changed. It shows the original choice list. ------- 6. Updated some values (name/ label) in the csv table on  AGOL Data page directly. 7. Checked the survey. The selection list has not been changed. It shows the original choice list. ------- 8. Overwrite csv automatically using the sample Python script. 9. Checked the survey. The selection list has not been changed. It shows the original choice list. ------- 10. Republished the survey. The selection list has not been changed.  ------- 11. Downloaded csv in Linked Content (updated from previous steps) in the media folder and republished the survey. Then the list has been updated.   So this is a summary. - Connecting CSV in Linked Content first time populated expected choice list. - Any changes in CSV is not reflected since then. - If I download the CSV in media folder, then hit 'refresh' in Survey123 Connect I can see the new list.   ... View more