BLOG
|
This is great! Will this process work in reverse? For example, will (or can) the google sheets be automatically updated if new points are added to the map, or attributes are updated in the web map? Is this a possible workflow? For example, can I connect a feature layer to a google sheet, collect data on that feature layer in Survey123, and have this data populate in a connected Google Sheet based on the web map refresh interval?
... View more
06-12-2018
01:48 PM
|
3
|
0
|
3473
|
POST
|
Thank you for all the help Zhifang Wang! It is very much appreciated. This works great on the Survey123/Esri side of things. I'm now getting hung-up by Google and my own agency. I can get this to work in Google Drive Backup and Sync with my personal email account, but cannot get a symbolic link to function in Google Drive File Stream, which is what is required of us to use (agency G-Suite Drive vs personal Google Drive). The doc is pretty spotty, but I am pretty sure the symbolic link functionality is not yet available in Google Drive FS. Also, our users are going to soon be losing administrator rights on their computers, so running command prompt as an admin will not be allowed. If I can get the symbolic link to work with Google Drive FS, I could have the admins set up the symbolic links for end-users when needed, though this might get tedious as our S123 user group is pretty large and growing. I'm hoping, while we wait for Google Drive FS updates, to get an Open Source office program added to our agency's approved software list as a temporary fix.
... View more
05-21-2018
11:08 AM
|
0
|
0
|
2645
|
POST
|
Agreed 100%. If I could change the path for where the surveys are saved, many of my problems would be solved.
... View more
05-17-2018
09:42 AM
|
0
|
1
|
2645
|
POST
|
Awesome, Thanks! Gonna test this today! There's another issue that will likely get in the way of this work around that I forgot to mention. Most users are going to be losing admin rights on their computers as well...
... View more
05-17-2018
08:43 AM
|
0
|
0
|
2645
|
POST
|
Our agency is currently moving away from Microsoft Office to G-Suite. We will soon be losing Excel. Many of our employees utilize Survey123 Connect on a regular basis, and I feel as though things are going to get a bit tricky when we lose Excel completely. I was wondering if there is a more seamless way to build surveys using Google Sheets while still getting to see the live preview of the form with each save/without having to download the sheet and overwrite the version on my C: every time updates are made? Unless I am missing something, it seems that currently this cannot be done because I cannot change the path where surveys are stored? Setting Sheets as my default program also wont do the trick because a copy of the sheet is created in my google drive, and not on my C: Just looking for some insights and ideas. If anyone has had to go the Google route as well, and has any tips and tricks for making this process a little less painful, I would be extremely gracious to hear. I really don't want our folks to be turned away from utilizing such a great time/paper-saving program because of this G-Suite transition. Thanks a bunch!
... View more
05-11-2018
09:03 AM
|
1
|
6
|
3015
|
BLOG
|
This is very exciting! Thank you!! I, too, would be extremely interested in utilizing webhooks for public forms. I'd be happy to discuss our workflows with you.
... View more
03-20-2018
10:00 AM
|
4
|
0
|
11316
|
POST
|
I am creating a creel survey form and am currently having issues using the hidden field type and the bind:esriFieldType. In my form, I have a repeat question about whether or not each interview was accepted, declined, or missed. I then have three integer fields within the repeat that contain if statements making each of these options a 1 if picked and a 0 if not picked. If(${Interview}=’Accepted’,1,0) If(${Interview}=’Declined’,1,0) If(${Interview}=’Missed’,1,0) I then have three more integer fields outside of the repeat that take the sum of the total accepted, total missed, and total declined interviews. Sum(${AcceptedYN}) Sum(${DeclinedYN}) Sum(${MissedYN}) If i leave these six fields as integers, this works perfectly, but I am stuck seeing these fields in my form. I face issues when I try to hide these fields. When I set the field type to hidden, and then set the bind:esriFieldType as esriFieldTypeInteger for these fields, it does not honor the esriFieldType. Instead, it treats the field as boolean. Instead of adding 1+1+0+1+0+1 and displaying 4, it displays 110101. I'm probably missing something simple. I've been staring at this too long! Thanks for the help!
... View more
02-23-2018
10:25 AM
|
0
|
3
|
3807
|
Title | Kudos | Posted |
---|---|---|
1 | 05-11-2018 09:03 AM | |
3 | 06-12-2018 01:48 PM | |
4 | 03-20-2018 10:00 AM |
Online Status |
Offline
|
Date Last Visited |
03-09-2023
10:24 PM
|