Latest Contributions by TL2

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

The '#' character breaks the watermark.  Is this by design?  I have thousands of domains with '#'s.   topLeftWatermark="D##" The "D" will show up but nothing after the ## ... View more

This has been logged: BUG-000126023 I just wanted to add that this camera issue occurs in Tablet mode and Non-tablet mode on the MS Surface. ... View more

Thanks!  We appreciate all the Survey123 Teams hard work! ... View more

Thanks for responding... I was able to install an older build of 3.0 that does work with the Surface Pen.  3.5 and 3.6 do not. I also installed AppStudio Player which also does not work which leads me to believe it originates from AppStudio 4. Windows 10 Pro v 1809 Installed on 6/4/2019 OS Build 17763.379 The pen works as expected for all other apps including Collector. This issue relates to this question: Microsoft Pen Support in AppStudio 4  I will log a bug with tech support regarding the camera. ... View more