Survey123 for ArcGIS: Tips and Tricks

okay good morning everyone so it's bang-on 10:30 so we'll make a start with this session just a quick show of hands with who was in this morning's session guys we've got a few G so this is a Tips & Tricks session in which we're going to hopefully give you bits of information that help you to do more with Sofie one two three and take your existing surveys a little bit further between myself and James's experience we've definitely come through a few little nuances of the product and we're going to help share we'll share these things of you so you can basically be more productive and get get more things done so a quick overview in terms of what we're going to take a look at will give you a basic overview of formulas and functions again to try and you know if you're not using them already or try and make this as accessible as possible we'll also take you through using external forms perhaps you want to look up data maybe you've got big extensive pick lists you want to give you all your users in the form will take you through the options of getting that working we also look at geopoint questions and working with the Jo point from a question perspective and what you can do with the output of that question type we'll look at going offline so building ppk/s how to build them and also how to get those ppk/s on your device we've also attempted to get this question a lot you know when she'll use collector versus wench I use survey one two three so we'll give you a bit of an answer to that one to help you make your decisions and again I did cover the functionality at one point ten where we created a survey for an existing feature service I'm just going to take you through a little bit more of an advanced workflow and give you some tips to get that working effectively with the minimal of Troubles and speaking of Troubles the final part of the session will be troubleshooting things that you can do to debug any problems that you've got your application so let's get started okay so formulas these are as I mentioned this morning for you those that were there it's smart form functionality Borman is enable us to do things like calculate the answer to our questions based on the input of a previous question this is all about doing some very advanced things giving quite complicated answers but also meaning we can reduce the amount that the end user or the surveyor has to actually type in if we can help it relevancy is all about showing questions are actually relevant to the user just because we've got a question there it doesn't necessarily mean that every surveyor is going to want or need to answer it so we're able to be quite responsive here and if someone's on said yes to a particular question we can then hide or show other questions as a results okay so in terms of calculations you can do some pretty clever stuff in survey one two three they support for mathematical functions you know plus minus divide even advanced things like flow calculations in pipes you can do logical functions or comparisons where you can do comparison between two answers maybe compare an answer to a fixed value whatever you can do texts mimic a manipulation meaning that you can work with strings maybe pull out a subset of information from a string or perhaps you know calculate the length of a string we can work with dates so those functions that enable you to work out what the current time is maybe what the cat the time is two weeks from now etc and you can also look at multiple choice questions so where you've got a multiple choice question how many answers have been selected and also work out which part has been selected okay so relevant questions we've spoken about this today earlier on this morning really a relevant question is going to give you an answer true or false so based on whatever formula you type in for example if selected that question or that answer then that may be true or false if the the formula results to true will show one or more questions if it's false then we'll hide them you've also got a function that will maybe to do this for multiple choice questions where we can basically use the selected function to say if they've selected that question and the corresponding value will be true or false and we'll make a questions display based on that answer one little point here and I'll reinforce distant part of the demonstration is that we've all of these formulas you know certainly one two three is doing work using memory so you need to be a little bit clever in terms of how you apply them it's not necessarily best practice to apply formulas to every single question when you could pass group a number of questions and then ploy formula to the group which means that basically you can hide or display a group of questions as opposed to individual questions okay so I'll jump in to the quick demonstration okay so this is a survey that's been set up I'm doing it in connect and the whole point of the survey is to collect your roadkill information and there is well pretty much out of the box a little bit of a relevant question behavior in it already the first one you can see that basically when we're talking about species identification if there's any degree of hesitation in terms of working out what that species was we're going to get give or give me the usually option to provide a little bit more information about the details of the animal that they've seen on the road if they're absolutely certain that the animal was a bad juror Fox mature regional animals you have here then we're going to remove that question because not relevant we can then give them the option to take a photo we do have another bit of relevant behavior here so effectively if I take one photo with the birth on wonderful it will then make a second photo question relevant so we can then go ahead and take it a second photo and I'm going to jump into the Eva spreadsheet now and show you basically what's happening here and then we'll go in and make some modifications to further improve the survey as part of this demo so the field that we're we're interesting here is the relevant fields as you can see this is identified by text you can have it in different locations but the first option we had was we only wanted to show that textbooks if the user was absolutely confident on the animal that they've seen so the equation here is just saw the formula here is saying okay further question species confidence which is here if they the answer is not absolutely confident which is one of the options in the drop-down list then the question is is is not going to be relevant so it will be hidden the other thing here is that we've got another formula which is effectively looking at the an surface species photo number one and it's saying basically if the length of the answer or the text link for the answer is any more than zero it means that there is an answer then we'll show the second question for second photo the thing here is that photo questions don't actually store a photo they store a string of the photo name so that's what's happening okay so in terms of the improvement that we want to make to this particular survey is that we've got some instant details here and you've got the option to say were you responsible did you actually not be the animal down if you are responsible then you'll be able to answer questions like the time stands impacts the speed of impact and maybe have a stab at the estimated stopping distance so we're going to make these questions relevant based on that preview previous answer so with the first question so we'll have impact time we're going to set up be the relevant equation and we're going to point to the answer of the responsible question again we need to define this to be a field or an answer and then we'll just copy that value in then we need to specify okay so if that value equals absolutely confident and that was one of the choices in the question here or as grout for the answer okay so here's the answer here I'm absolutely also led the answer absolutely confident grab it let's go back to the survey and then we'll type that in as a value and then we'll save it update it and we'll have a look at the results look you are correct it's the wrong one oh yeah I did need to be yes okay good spot okay all right so if we were responsible yes no actually is that like absolutely confident yeah sorry and I think I was writing first place you need to nationally choiceless yeah no yet and I you should have been sorry I was on the right track okay back in clear we want to absolutely confident so clouded myself okay let's try again and I saw you my favorite new alright it's the snow that's whether it's low case responsible yes sorry it's just a case issue but yes we responsible yes we say there we go so we want to apply the same relevance or relevant relevancy to all of these other questions highlighted in blue so they go back into the spreadsheet immediately option is basically just to paste this in but is there before if you want to have performance optimization you're better off creating a group and grouping those questions and then applying the relevancy to the entire group not each individual question okay so I'm going to apply those the other thing that I want to do is set a default value as well so the default value is that yes you were responsible okay and save that okay so default yes but if you're not responsible you will then minimize the answers to those three questions okay so next thing I want to do is perhaps calculating the stopping distance it's not really something once someone wants to be manly on the when they're out in the field we can go in and actually add in a calculation so that it's done based on whatever speed the user enters so if we go and find the calculation field and I'm just going to grab in a stopping distance calculation here okay and I'll add that into the stopping distance calculation click paste which is working out meters-per-second-square and then dividing it by a gravitational constant it's fairly basic and probably not that accurate but it gives you the general idea of what you can do okay let's just reload okay so now if I type in the speed say hundred kilometers per hour we'll get that estimated the stopping distance automatically calculated you could choose the height this field it doesn't really it's not the end user really needs to know about it we could just call to actually calculate it behind the scenes and write it to the database so the final thing I want to do is just put in some constraints so we have an email question that we want to answer in this case we want to make sure that the email is at the valid so back into the spreadsheet go in and find the constraint attribute for the email grab what we're using here is a regular expression to basically ensure that the format of the email is correct paste it in and then basically if it's incorrect is going to return the message that you put in the constraint message box here click Save okay if I type in an interim valid email we'll get that error message so I type in something that looks generally like a decent format so they make sure you get the Apps Gmail com oh there it doesn't like that one yeah try again like I you see that you're able to progress and successfully submit the survey if it was invalid you would have to fix it before you could actually submit the survey back to the server the service ok another function that can be used with the calculation that really helps extend surveys is one that meant lets you work with external datasets it's called pull data this is basically lets you have a CSV file accompany your survey and then reference the use it as a search basically a search stated database in your field so for example if I was providing a station ID here of this value 3 100 to I would then look up that row in that CSV file and then bring in in this case the name field so this is a call to Station subsidy file we're looking for the name field here and they're basing it on the station ID with this as the ID hopefully that makes sense I will present a demo of this in a in a second the pull data field also lets us begin to also work with location data be able to store point information obviously we can store the point you collect as a point inside your feature service but many people need to have the x value or the y value or the altitude or accuracy that you're collecting as part of your survey the pull data function when we provide this parameter to look at the Geo point look at the point allows us to then grab that information so looking at the point for example gathering the little kick from the field of publication the x value just as a quick note and will also providing a few more notes on location for some reason you're not collecting a location either your device doesn't have a GPS or they person or your so you know in the middle of the field and under so much canopy that you're not getting a GPS signal we store the value at zero zero that's because and that's to allow other applications that may not be comfortable with the notion of null geometry to still be able to access and work with your data so really quickly I want to switch over and begin to work with that location data this is a form that's based around doing an inspection of bike share stations in Washington DC this could be any type of asset be a fire hydrant could be manholes could be street signs I just chose bike share stations because the data set was readily available each of those stations has an ID and so once I select an ID let me go with three 200 one once I feel that once I select that you can see that we actually are loading in information we're loading into the location of the text item we're loading in the location on the map of the location of the of the biker station and other information this is being done by accompanying that CSV file here in the media folder of our form so if I take a look at this CSV file you can see we have here again the terminal name that I that's the idea that we're looking up as well as things like the name the latitude and the longitude accessing that here inside of the form is using the pull data function so first question of course is to select that station ID note that in this case we have those listed as a set of choices here that I basically copied those over as an index and then after that occurs we use the value that we got through this pull data function to look up the information so pull data looking at the station's CSV file the name field using the terminal name and the station ID similarly for latitude and longitude in this case I've put them in separate hidden fields and then created the location as a string with the x and y or legend longitude to yn X as a calculation for the Gio point so we're again reading these values from this table and then inserting them into the locations in the form that you see here if I went to starting to connect now that I've got this I'll validate the input you can take a look we have the latitude record and the longitude those are the fields that aren't visible as well as the legend large roots set as our geometry the other use of pull data as I mentioned is working with the X&Y coordinate so you can see here if i refresh my location it's updating you can see the location as we're receiving it we're receiving in this case latitude longitude altitude and accuracy and then you can see these are being now being filled and isolated out as it happens we're also receiving vertical accuracy the which particularly and were however we're not receiving anything regard to speed or direction no compass orientation the Gio point properties we receive do vary from device to device some devices will have a compass and provide you bearing and heading direction though you also need to know how that works in relation to how you're holding the phone is the compass facing out from the phone is it facing from the top so we do the access information but that can also be a little in terms of in terms of understanding it taking a look at that form there we go here you can see we're beginning with the location call and then we're just beginning to get the string that is being stored from the point that was at for sequence there of latitude longitude altitude and accuracy over here you're starting to see the actual calculation of integral values so for the latitude latitude is y we're asking for the y-value using that pull data with the geopoint it sort of key word for accessing location information same with X Z accuracy and then the other ones in terms of collecting at a in terms of collecting a point with sufficient accuracy within the seat within the where did you get to there is a horizontal accuracy constraint my apologies I'll talk about it in a little bit so that's again taking advantage of the Geo point the Geo point option for pull data in terms of calculating answers couple more notes on location we have had a number of what people asked about using an external receiver with zero one two three so every one two three can work with external receivers however it's always receiving the GPS information via the operating system location provider just as a quick show of hands how many people know what a comport is how many people of those who know comport is know because they've been using GPS devices see so that's how that's how a Windows Device has traditionally used a GPS it connects with a dedicated communications port to receive the GPS information that is then piped over to a specific program that doesn't work on phones instead the operating system is responsible for providing access to the location information in the normal course of operation so what you see is that these GPS devices are now being made for iPhone and made for Android and are and once they're connected in they automatically override the internal GPS to provide their information as well this lets us work with external receivers it also does mean that we don't necessarily work with full high accuracy device hierarchies devices because we need to get additional metadata information that is not being provided by the operating system that's why you saw a collector had to work on that as a specific feature enhancement it's something we would like to pursue in the future but with the case with 30 one two three we believe that we're meeting something like 85 90 percent just by being able to connect to an external receiver and getting se meter meter and a half level accuracy this is really an issue if we're trying to go but you know really below that really into that sub-meter component you can use sets the accuracy using a feet using a settings field called body accuracy threshold that will force the survey to not submit until you will receive a point with the desired accuracy also by default we record 2d points when we strike them out you can easily set that to a 3d point by just switching out and saying I want to store a point type with Z in it this is again to work with other applications that may not know how to deal with the dead values altitude values again with R if external GPS receivers we do work with them one also issue in addition is that windows still win your cognitive devices to Windows they're still being being connected normally via that legacy comm system there are other third-party pieces of software that let us redirect that signal from the comm port into the location provider one particular one I use is called GPS direct so that's a small caveat if you're using oh it's very large III on Windows with an external receiver so next it will switch over to John because if we keep the questions to the end the cool points just got a fair bit to get fruit okay so the next bit we're going to cover it's about taking your base maps offline as we mentioned before survey one two three does support offline data collection however by default you have access to online esri basemap in if you want to work offline and still have access to base maps then you need to create something called a tile package a tile package is a bit like a zip file containing all your tiles so you can view them in offline mode now there are a few general options for getting tile packages onto your device you can copy them directly onto your device into specified directories and I'll take you through those now otherwise we call this side lonely side loading the data directly people TPK directly onto the device the other thing you can do is upload your your typical artists online and you can enable users out in the field to actually directly download it to the device so let's just take a look yeah so in terms of your options are actually creating hull packages you can use your own data using arcmap or our Jes Pro it's really a matter of just using a tool called the crate map whole package tool a few considerations in terms of actually getting your data ready you need to ensure that your data frame is in WGS 1984 auxilary sphere otherwise the Tal package won't display within servi one two three additionally there are considerations you need to make to ensure that your data looked acute at the scales your l20 going to view the various whole package lay layers in but that's basically a whole lesson in itself so i'll give you a quick look at the tool crate map tile package take you through the inputs first one being a MXD you need to specify an output file okay you need to specify the tile format format whether it's PNG or JPEG PNG tends to be better for color resolutions JPEGs tend to be a little bit more compact you also specify the level of detail obviously the higher the number the higher the levels of detail the more tiles you can generate and effectively each level is going to have a exponential increase the number of tiles you can provide summary tags and also specify the extent of the data that you want to basically put into your tile package we're not the extended the file the data frame etc and click OK you can run it I'm not going to wait for the result this one I'm just going to show you another option that we have for building tile packages then it's a application you can download called tile package creator actually we came out of the the Melbourne team and it was actually built to help users of survey 1-2-3 to build whole packages we've got options to upload existing tile packages ArcGIS online you can browse your organizational file packages but there's also an option to create a new tile package from not from scratch foot and building new one for your survey what this is doing here is pointing to all of the ESRI basemaps services that have the capability to enable you to export tiles from it and build tile packages so the key thing here is they've got that for export in the end of them you can basically search for them on ArcGIS online but this brings them into one central location that you can use to build your own tile packages if you have your own artist for server services that use or have that capability in able to export tiles you can also add them in and build packages using this application so I'm going to use the world street map you can see that it loads it up and it gives you two options to basically define your extent I'll zoom roughly to the general area room okay so we could define a line to build a buffer around and generate a whole package to basically cover that line maybe as a pipeline road network trail network etc and double click to finish it the other thing we can do is just drag a bounding box to define the extent we can specify the number of zoom levels take it down to 8 specify a name so ok you can save the Tal package locally to your desktop or whatever machine you're using or you can choose to add it as an item in ArcGIS online ok you also can set the permissions to make it public to share the organization or to make it private ok so I'm going to leave its do its thing what this will do it will create the tile package and then when it's done it will give you a link to the top packaging going access to the artists and line-item ok we'll just leave that running away in the background ok sorry so there felt well really brief answers again we want to try to keep questions towards the end we'll do a run free program okay so this is the the survey one two three application I'll just tidy things up a little bit here and you have the option to as I said for side load trial package directly onto the device what you need to do here is jump into settings there's a little option down here called map and then you can see that it's pointing to the defaults tile package directory where if you copy tile packages to that location it means they'll be accessible to the all surveys on the device effectively so I'm going to do is to show you that this works I'm going to grab an existing tile package I'm going to copy it and I'm going to navigate to that maps directory click paste and then I go back into settings once more map going to map library you'll see that that tile package is now available to the the surveys on the device okay the other option is you may have some kind of external drive so in this case I've set one up the storage cards so we're not external drive some kind of external media I'm going to grab the URL and what you can do here is you can actually add additional locations that the server once agree application is going to look at to define tile packages you just need to if you want to have multiple locations you just need to separate each one with a semicolon and you can paste them in you can also navigate using the Explorer option here but once more I'll go back and we'll also do is grab a CPK and then copy it into the storage card location then go back into the Vice go into settings going to map and again into map library you can now save it we're looking at two separate locations and we're just putting through all the tile packages they're sitting there okay so let's go back to tile package creator and go to the Browse orbit EP case that have been created okay I believe check this ArcGIS online okay so here's the TPK I can go in and grab the item ID for it and there's a little bit of configuration works required if you want to make sure that users have the ability to download this particular TPK from ArcGIS online to their device and the best thing to do is actually just go straight to the resources the survey one two three so I got a shortcut here anyway and there's a whole resources section devoted to taking your base maps offline if you go down here and scan down to the bottom you can see an example bit of JSON which enables you to specify this TPK not just align and make it accessible to your end-users so I'm going to quickly just copy and paste it and tell you where you need to update this so into connect go to your survey and then there's a shortcut to take you to all the various files that associated with that survey if you click this directory if you've published your survey already it you will have a file called TP Kade info available for you survey name dozens of survey names or intellect indicators like it's the survey name so if we go in and we'll open it up with brackets and some reason brackets is not the speedy asan opening up but what you need to do is add this JSON into the file and of course update a few of the parameters to make it specify a specific to you so let's grab the item ID of that file package and we'll update it yeah you have a few parameters you have you've got this include library and append calls true so a pen just basically means that if you want to have your local tile packages and the online versions of Illinois based maps available or viewable to your users you would set that to true if you want to include library basic means for this particular survey do you want to include other tile packages that are sitting within your your media folder so in case yes I want to see all of the other TP caves on the device and I also want this TPK to be available to other other surveys so I store it in the map library click Save and then we need to go and publish the survey ok so once that is uploaded will jump into the the field app and update the survey to be the latest so we've got all that configuration information that we just pasted in I would say that the reason that we're using the this particular application is that we're able to check and make sure that all the brackets line up there's also another application or website called jslint it enables you to check to make sure that your JSON is accurate you're not having additional or missing commas or or unbalanced brackets so especially definitely worth doing some validation okay so now when we go in and look at the ga point question and with the math options you can see that we've got those two local TP caves that we we copied onto the device so you where they are okay there we go okay and if we go back one more you'll see that on top of the options to delete the survey we've now got the option to download maps so this is because we've configured that file we've pointed it to the on target alignment Facebook TPK and you can see that we've now got the option to download that locally onto the device from artists online and then view it so it should be a relatively small TPK I think because we're fairly hand tight on time I have to trust me that this will now be accessible so I switch over yes cool so that was working with TV case for offline in addition you can also just simply copy the TDK into the media folder and that will come as a certain house the Tbk company the survey as well so that's an option we'd recommend for Windows Phone because Windows Phone there is a support for actually copying files directly onto your device or side loading them the other little tip and trick is that if you're using iOS devices you and you're using what you need to use iTunes or I Explorer the little nuance with with iTunes in the fact that you can't get direct all the way down to the maps folder so what you need to do is grab the the arcgis folder copy onto your desktop put your TP k's in there then copy the whole lot back using iTunes so the next we want to talk about was so everyone to drink collector we get this a lot when is collector 1-2-3 coming out which one should I use we definitely see differences between to everyone to turn collector they are perhaps a little different than how we as GTRs people professionally tend to think of them we see the difference mainly and who in the intended user of the application so every one to three is as you know very focused on the form experience and creating a form that is easy for someone to fill out so what we see is people who are may not need to have much training literally we're talking about people who we give we create the form loaded on the device give them 15 minutes of training on how to sell the questions out and then send them on their way collector tend to require a slightly more sophisticated person I mean partly because they're collecting additionally because they're collecting information that maybe is a little more complex with regards to the map and with wrote to the map we also see collector as sort of a map first or map forward collection capability so from our perspective as u.s. users we tend to sort of conflate the two very often but you know in terms of features and functionality but in terms of the user inputting it that's where we see the distinction between survey 1 2 3 and collector generally the other sort of option the right now at least is 73 does handle forms much better than collector that being said you're going to find that collector is going to integrate at least some level of smartphone capability as it goes through the collector it's process they fully intend to do that likewise collector currently product let's lines and polygons so every one two three we do want to support line capture and polycon capture at some point you know as well we're not planning forward by you see but we do know it's a major request so what we're trying to do is create two apps that are has enough of a different focus in terms of the user and the user experience that they that deployment will make sense when you consider okay I'm giving you this to this group of people what do I want you know which app is more appropriate in terms of specific level to this level of sophistication for that user base we've got a blog that explains that a little bit more detail at this every one to three health plate more exits we're into the help page as well as a blog actually in the Geo net not being said we have plenty of customers who are using three one two three and collector together on Tuesday we did a demo theater on app linking between app app linking so that collector for example can open up survey one two three this is done by using a special URL and they for example you know your URLs starting with for example HTTP that means open up the browser in this case the URL ArcGIS every one to three means open up survey one to three and then we have to provide the IV for my item as well as if you wanted to pre-populate any fields this works really well with a pop-up pop-ups we can create a custom display that includes URLs so for example you can see that pop up there with a link to tell the repair report that link opens up so everyone two three with the station with that particular stations information loaded into the forum again we heard this on Tuesday and just because of time I don't want to cover this in a demo I'm very happy to cover this again afterwards and also as you know the slides Harvey from all of our from all of our sessions are going to be posted and fortunately the video from demo theaters generally isn't posted but the slides will be posted in the Proceedings that's a very good question if we don't we can work to get it up and running for this next season so moving on to connecting to a feature service okay so we touch miss in the earlier session 110 you can basically take existing feature services and build a survey around it meaning that you don't have to type in all of the field names yourself and it does a lot of the checking and to make sure that the questions at the or basically checks the data things like aliases domains and uses that to build your survey now the example that I showed earlier this morning it's back so we've got water quality sample locations these are features that can not be updated very frequently and then we have a related table which has all our water quality samples so one water quality location is likely to have one or more water quality samples in that related table now just have a quick look at the data when building a relate you're looking for a common ID and you know most of you are thinking okay we have a station ID number let's have a look at the the raelia table and again we have think all the way at the other end we have a station ID number so they wants you free actually requires that the child table is joined via a Buick or a global unique identifier and that global unique identifier me to be populated with the global ID of the the parents or in this case the water quality site so just to show you that we have got the global ID in the feature layer these are calculated using a geoprocessing tool and then we can actually go in and just add in a new field of the type gear it's it's a standard ESRI field taking a little bit of time to open but if you go into the properties you can see it of type G UID once you have those fields in place this is going to be the ones that we use as the basis of our release so within the database we can go in new relationship class give it a name it's going to call it release and I'm going to specify the parent to be the water station that's the feature of the geometry and the child is going to be the water quality samples table in this case with no geometries a simple relationship we would just say okay we'll if we delete a site we still want to keep those water quality samples and and this is a little thing that is definitely tripped up a few people we need to ensure that both labels forward and backwards are the same so otherwise you will have problems using this in survey one two three so if you ensure these are the same then progress the relationship that we want needs to be one too many one sample location to Medawar many water quality samples and we can accept the defaults here and of course we just need to point to the global ID of the feature layer here and the parent global idea will that GUI feel that we created in the water samples history click Next finish and your August for publishing ok so I'm gonna take you through the workflow but I'm just going to show you a few things that you need to consider when actually publishing a service next okay so around capabilities and under feature access we need to ensure that we're able to create delete and update the feature service you can optionally enable sync if you want to use the same service within collective for our tests and you want to take your your maps offline item description this is coming from the actual map documents but in terms of sharing if you're using one point 10 of survey one two three you need to ensure that you don't make this service public of wise basically it won't appear in the options when you're searching for services to build a survey on top of that something that changes in in version 2 you're able to see publicly shared services but they all need to be coming from your portal or from the ArcGIS online account that you've logged in as a named user for in this case I'll just keep the defaults and I'll publish in the background ok let's just jump into the field application Hey all right sorry and I'll just actually go back into connect so this is the same workflow that I use this morning we'll go to the file and I sort will go to feature service and all search for that service and which is created yeah now what you're hoping here is that it's always gone well the server went to free connect application will identify that related table and create a repeat around it so they'd either way that the the forms deal with related tables and that's work that's fine we have that repeat in place and this would enable us to work with a workflow where we click the water quality site and we would then go in and collect a number of water quality samples for many of you that's probably not a realistic work so you might be updating information about your wallet water quality sample occasions or you might be collecting new water quality samples so we can readily go in and just update this particular survey and make it just point to that attributes coming from the feature layer click Save so these will just leave the attributes there and then click publish so if you want to build a survey that actually just goes directly to that related table so you can go out and field and just capture water quality samples and there are a few things that you need to do and I'll just give you okay I like nothing existing survey that's doing exactly that so this one is pointing at all of those a related table fields and to get this working there were a few things that needed to be configured and the first one being the layer that you're pointing to so we need to say okay by name I'm pointing to that related table in the feature service so you update that form ID the submission URL can stay the same and then within the survey because by default that global unique identifier field is not copied over by so they once you're free connect so you need to manually add it in so you take that field which was in the mxv so just to show you that one within the related table so parent global ID we want to take the name there and back in the spreadsheet add it in and you need to also tell connect that the field type is actually of the type is really GU GU ID and that's available in the drop-down list of options okay so let's just save it and open up the survey okay so this would work pretty much out the box but you'd have to go out into the field and the end-user would to type in the global ID of that feature if you're going to collect if each if you're going to collect a water quality sample and that's not really very practical so one opportunity you can use is the app linking or the custom URLs that James mentioned so you can link from collector grab that view is globally unique identifier and the site name and auto populate it they have a bit of functionality that James spoke about was the pool data function so in this scenario they deleted a lookup table between site name and the parent global ID so that when the user goes in and selects the appropriate site then the global ID will be Auto populated and we can then carry on capturing all the information so this is probably a field that we don't want to hide so people could not change it orders it but it is another way of us getting that functionality working okay so we want to wrap up briefly with a little bit of troubleshooting going to actually switch over to my mobile device just because we've included some slides but just intuitions of time I'm going to skip those in favor of showing you directly so the first thing is that 3123 if you have a problem repeatedly with it we're definitely wanting you to file a technical request to pre please support that as part of that we can actually log what's happening with survey 1 2 3 and provide that log file to either technical support or that's everyone's e3 team by doing that we go to settings and there's a Diagnostics if for some reason you have apps to do like you're using a custom version of it you can connect it to apps to do otherwise it'll save a log file on your device so you can go through work with your way 1 2 3 up until it crashes and then extract out that file to do that it's a little bit easier in Android because Android as exposure to the file system with iOS similar to the tale package and we need to use iTunes to load it we need iTunes to extract it so if I take a look here we've got iTunes it's recognizing my phone I go to the apps section and I don't know how many people have loaded our files into their iPhone or not this is not the most obviously exposed at the bottom of the apps list is the list of the files that can share so for example to go to survey one two three oh yeah you can see that it's got a folder here called ArcGIS I mean we could have added to it that's what I that's what Jonathan was mentioning about creating a TPK I can also save so you can see that I can out load that you can see I do have customer issues that I use this for I'll just save it there and now it's a folder that's available right here in my right here in my file system the logs are stored in a studio here under this logs area so you can see the files that we've created including the one we created today this is also useful for doing data recovery if for some reason your survey is not going to post we can take the my surveys folder here and copy it over into our computer to post this using a version of server 1-2-3 on our computer in addition you'll see that we have the database here this is what is storing the surveys as you post them this is a sequel like database so there's many different tools that let you access them it's actually the survey folder here so you can see the data here so you know for each of my surveys I have for each of the trees submitted you can see that I've got the data that I've had as well as what its last status was so we can easily go in and begin to manually recover if we need to so that's pretty much all the one cover with tips and tricks we've got as I said about five minutes for questioning my apologies and I know we do have a question from u-thor and a question from you in the front to get through first so let's go with you since you actually raised your hand first estimated accuracy is that can't be calculated CEP or CI my apologies I'm normally used to talk about H stuff and vertical and vertical so I'm not quite sure what check Ren's your meaning there so that's a good question that I do not have the answer to we can take a look at again we're giving this from the operating system so we'd have to research what the operating system provides normally it's normally with run in terms of total accuracy which is a sum of square roots or a square root of sums some Squared's or it's horizontal and vertical okay Oh confidence interval sorry okay and then you had a question about the tell package and the bit so there isn't a size limit on the top package download except for the total mouth storage you have on your device that being said large Attell package the more awkward it is to load into a device over network transfer obviously question so the question is there any integration between Jones and map answer one two three currently there isn't an integration point except that we could take the photos that are collected via drone and add them on you aren't required to use the camera of the device you can use a you can load an image via the file system repeating data that has that's already available so we have what's called begin begin repeat that creates that related table that Johnson was talking about in working with the feature service and that allows you to create a collect multiple instances of a set of questions that why we you could build a survey from scratch so as you know if you've built a survey it was automatically build a feature service with that capability enabled so you could start in the forum you could put your repeat questions together publish it to artists online and you would have those related tables created behind the scenes anyway yeah yes its season what's called one feature service which is a set of one or more tables that have relationships among each other for coming up to the end of the time I'm actually leading so if something happens the question is what happens if an error occurs during data transmission thus every one to three submits data using this capability called rollback so if there is an error that occurs during data transmission it should undo the ads that you're doing current that caused that error and that would basically halt the submission and basically it would flash as an icon read in the outbox folder and a way for you to try to send again yeah so the question is around constrict behavior the default constraint behavior will present the error box on a faulty submission or a faulty value and then will not allow the submission of that faulty value what you could do is have an option box that basically Overlook provides an override so your constraint would be you know the value it must be less than 10 or the override box has been checked okay we are still going to here for a few more minutes obviously it is lunch and we know how the lunch fun will get so we want to lay you if you don't want to thank you for attending [Applause]

Channel: Esri Events

Views: 16,000

Rating: 4.9428573 out of 5

Keywords: Esri, ArcGIS, GIS, Esri Events, Survey123

Id: n5ytk52KlAk

Length: 61min 5sec (3665 seconds)

Published: Fri Mar 31 2017