Latest Contributions by TL2

Sounds like you need to add your portal url (you are pointed to AGO).  Use the cog in the upper right. ... View more

Looks like its fixed in 2.5  ... View more

Xander Bakker‌  I have the above question too. ... View more

Could you please make sure this hot fix makes it to the 3.7 template in Survey123 Connect. Thanks! Also in 3.6 the size function just increases the spacing (this is size 88).  I will open a ticket. ... View more

Yes ... View more

Its actually not a S123 issue but the way the rest endpoint posts to the database using Apply Edits at the feature service level.  From my testing it does two transactions, an insert and then an update.  Any executions fail in the trigger because they are called on the insert but the update has not occurred yet.  Hence the warning.  I have not found a work around, but that is whats happening. Additionally it is by design so basically not an ESRI problem. I'm not sure how Collector posts but this is not an issue with Collector. ... View more

I am trying to return just the globalid of the top record as set the globalID as the variable.  It works when I hard code a globalid. The below works, but it obviously does not use the variables. var valves = FeatureSetbyName($datastore, "UTILITIES.DBO.uti_wdSystemValve",['globalid']) var valve = first(filter(valves, "VALVE_ID = '" + $feature.valveid + "'")) var date_ = $feature.exercisedate return { 'edit': [{ 'className': 'UTILITIES.DBO.uti_wdSystemValve', 'updates': [{ 'globalID': '{DE10ED35-B0A6-4E0B-86E7-0012405029F8}', 'attributes': { 'lastexercised': date_ } }] }] }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Instead of doing a static field calculate in order to symbolize my data by the related features I am trying to updated the parent as the related records are edited using attribute rules.   Any suggestions? var sql = "VALVE_ID = '" + $feature.valveid + "'" var guid = "'" + TOP(filter(FeatureSetByName($datastore,'UTILITIES.DBO.uti_wdSystemValve',['globalid']),sql),1) + "'"; var date_ = $feature.exercisedate return { 'edit': [{ 'className': 'UTILITIES.DBO.uti_wdSystemValve', 'updates': [{ 'GLOBALID': guid, 'attributes': { 'lastexercised': date_ } }] }] }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Xander Bakker‌ Using this we can now access related table data but we still can't symbolize or label using the same logic? Is this still a limitation? Seems like we still can't. ... View more

Two Notes: 1. I had to make my Version Table a Feature Class for it to work. 2. Adding ${official_survey_version} = '' will allow the form to be displayed if the user is offline.  This will prevent the user from being locked out in the field if they did not upgrade while online.  When they get back online, it will hide the form (and their collected data), allow them to update, and send form.  If you properly update your forms you should always allow data to be submitted from any version. ... View more

[BUG-000126568: Photo watermark text after a pound sign (#) does not appear in resulting photos collected in Survey123.] ... View more

James, Error: Underlying DBMS error [HY000:[Microsoft][ODBC Driver 13 for SQL Server]Connection is busy with results for another command] [GISDB.DBO.FC_S123_TABLE]. I believe this to be the one error in my way.  Here are the scenarios that work and fail. This seems to not be a S123 issue so maybe you can point me to someone else. After Insert a. The post is successful and I am able to use data from inserted and update tables in the geodatabase with inserted data. b. The post is successful when I use an exec store procedure and do not use any data from inserted in the SP. c. The post fails when I use an exec store procedure and try to capture any data from inserted in the SP. example: exec sp_send_dbmail fails with inserted data in the email body/subject... This is the one I want and this is the one that gives me the error above. After Update d. The post is successful and I am able to use data from inserted and update tables in the geodatabase with inserted data. e. The post fails when I use an exec store procedure and do not use any data from inserted in the SP. f. The post fails when I use an exec store procedure and try to capture any data from inserted in the SP. example: exec sp_send_dbmail fails with inserted data in the email body/subject... This is the one I want and this is the one that gives me the error above. I do receive these same results when applying edits at the rest end point as mentioned above.  I am using SS2016 and 10.7.  Data is Archived. When applying the edits directly in ArcMap I do not have any issues. Thanks. ... View more