|
POST
|
Hi All I recently required a form to be updated to include a repeat. I realized I could not add the repeat without republishing the form so i decided to add the new table and relationship via the REST API Addtodefintion. I was successfully able to republish the form and survey123 connect recognized to new table and the relationship however when I try to submit a form now I am met with the following error (taken from .sqlite file) {"code":1003,"description":"Operation rolled back.","tableId":0},{"code":1003,"description":"Operation rolled back.","tableId":0},{"code":1003,"description":"Operation rolled back.","tableId":5},{"code":1003,"description":"Operation rolled back.","tableId":5},{"code":1003,"description":"Operation rolled back.","tableId":5},{"code":1003,"description":"Operation rolled back.","tableId":5},{"code":1003,"description":"Operation rolled back.","tableId":3},{"code":1003,"description":"Operation rolled back.","tableId":3},{"code":1003,"description":"Operation rolled back.","tableId":3},{"cod N Oe":1003,"description":"Operation rolled back.","tableId":1},{"code":1003,"description":"Operation rolled back.","tableId":1},{"code":1003,"description":"Operation rolled back.","tableId":1},{"code":1000,"description":"Cannot insert the value NULL into column 'globalid', table 'db_19692.user_19692.service_5822ca4cbf4645d2acd99c69fb8d5c8c_DEVIATION_REVIEW'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated.","tableId":6}]{ has anyone any ideas as to what may be the issue? @Tedrick
... View more
01-14-2021
01:00 AM
|
0
|
4
|
2276
|
|
POST
|
Thanks @XanderBakker it is working for me now and the good news is the pop up is working in the field maps app so i can use it in that for our field crews. Really appreciate the help on this , I applaud your efforts to support everyone on this page with arcade quieres it really is very helpful. Well done.
... View more
12-08-2020
07:21 AM
|
0
|
0
|
1287
|
|
POST
|
HI @XanderBakker The field in question is "Test_Note , feel free to try, i tried previously in Pro but could not get it to work either.
... View more
11-30-2020
08:53 AM
|
0
|
4
|
1331
|
|
POST
|
Hi @XanderBakker yes this is expected it works for me in the pop up as well however when i try to calculate a field with the same expression it doesn't work. i shared the test map in there now but i understand you do not have the ability to calculate fields via arcade
... View more
11-27-2020
12:24 AM
|
0
|
6
|
3579
|
|
POST
|
@XanderBakker @XanderBakker Again apologies for the delayed response i have set up a group and added you with the layers and a map with the expression included. Please feel free to investigate if you have an opportunity , thanks for your help on this .
... View more
11-26-2020
01:55 AM
|
1
|
1
|
3586
|
|
POST
|
Hi @Anonymous User I had the same issue this morning, turns out i was passing the wrong object id into my HTTP module. Have you checked your parsing the right Module and using the right object id value?. I somehow managed to skip a module and used a previous object id.
... View more
11-13-2020
01:07 AM
|
0
|
0
|
1986
|
|
POST
|
Hi @XanderBakker My turn to apologise for the late response , i have tried you expression and i am still getting the same error unfortunately . Just in response to some of your comments The when statement , in theory there should only be 2 features intersecting the line at either end and it should be a pole or a chamber so 5 potential scenarios. Would this account for the error ? where it is only 1 pole or chamber i don't need a value i thought this would return just 'n/a' 1 pole 1Pole (cnt <= 2 && cntchambers==0) 1 Pole 'n/a' 1 Pole 1 chamber (cnt == 1 && cntchambers==1) 1 chamber 1chamber (cnt == 0 && cntchambers==2) 1 chamber 'n/a' // does you code include the layerID for poles? Yes my code contains the layer ID for the poles and chambers why is this an underscore? No major reason had it as a blank but then i thought perhaps the blank value was creating the issue so i just tried it with an underscore I filtered it down to one objectid i knew worked with the pop up? A new source? do you mean re publish the feature layers ? Thanks for your help on this Regards
... View more
11-13-2020
12:26 AM
|
0
|
1
|
3631
|
|
BLOG
|
Hi James Tedrick i see what you mean it took a bit of trial and error the path is shown as 1 [] you need to specify the number of the item in he array and then then x y and z are represented by numbers themselves in each item of the array. So the first and second x y coordinates in the path array is is entered as follows 1,1 1,2 2,1 2,2 my issue now is how to extract the first and last point from the path array so i can project a simplified version of the original path(polyline) . i can use the first and the second one for the time being but if you know how to get the final item in an array with different counts then that would be great.
... View more
11-08-2020
02:13 PM
|
0
|
0
|
12315
|
|
BLOG
|
Hi James Tedrick This is what i would have expected but this is all i see, paths is not listed anywhere in the geometry section . What i have done is entered a query to return the feature that was submitted in survey123 and parsed to return the geometry with the paths array included. however when i try to construct the geometry i am getting blank values
... View more
11-06-2020
03:27 PM
|
0
|
0
|
12315
|
|
BLOG
|
hi James Tedrick I am wondering if you can help with this one , I have a survey in a projection 4326. the survey has 2 repeats in it, one point and one polyline, both restricted to a count of 1 . I am trying to append each repeat to another feature layer which is polyline layer. The problem i had was the layer i am appending to is in a different projection 102100. For the point repeats i managed to figure out how to project it the 102100 and represent the point as a short polyline and append with attachments . However i am running in to difficulty as i cannot figure out how to extract the geometry from the repeat polyline entry and feed it in to the project module. it does not make sense to me how it's represented. in the survey 123 module i can see the paths as i would expect but in the mapping for integromat it is shown as some kind of array , see images below. Can you possibly explain how i use this to represent the geometry in my projection request. Hopefully this make some sense. Thanks in advance
... View more
11-06-2020
09:05 AM
|
0
|
0
|
12315
|
|
POST
|
Hi Xander Bakker Thanks for your comments , i have added console messages to the expression and everything returns the expected results including counts in line 6 and 7 . Is it the fact that if it returns a zero in some instances that is causing the error? i have updated the expression to return a value if the count is zero. I have also filtered that table down to one feature and it is still not working on that feature even though the pop up returns the expected result. What would count as an invalid feature ? Var polesLayer = FeatureSetByPortalItem(Portal('my portal'), 'xxxxxxx')
console('polesLayer '+polesLayer )
var chambers = FeatureSetByPortalItem(Portal('my portal'), 'xxxxxxx')
console('chamnbers '+chambers )
Var buff = buffer($feature,.1,'meters')
console('buff '+buff)
Var poles = Intersects(buff,polesLayer)
console('poles '+poles )
Var chambers = Intersects(buff,chambers)
var cnt = count(poles)
console('cnt '+cnt)
var cntchambers = count(chambers)
console('cntchambers'+cntchambers)
var popupResult = '_'
for (var f in poles) {
if (cnt>0) {
popupResult += f.barcode + " to pole " ;
} else {
popupResult = "There is no Link required here";
}
}
console('popupresult '+popupResult)
var ChambResult = '_'
for (var f in chambers) {
if (cntchambers>0) {
ChambResult += f.label + " to chamber " ;
} else {
ChambResult = "There is no Link required here";
}
}
console('ChambResult '+ChambResult)
var strLenght = count(popupResult)-8
console('strLenght '+strLenght)
var note = left(popupResult,strLenght)
console('note '+note)
var strLenght2 = count(ChambResult)-15
console('strLenght2 '+strLenght)
var note2 = left(ChambResult,strLenght2)
console('note2 '+note2)
var popup = IIf(cnt==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)),'to pole',''), ("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)))
console('popup '+popup)
var popup2 = IIf(cntchambers==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)),'to chamber',''), ("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)))
console('popup2 '+popup2)
var popup3 = "install subduct " + DomainName($feature,"sub_size")+" from the chamber "+ChambResult+" to the pole "+popupResult
console('popup3 '+popup3)
var popup3 = replace(popup3,' to pole ',"")
console('popup3 '+popup3)
var popup3 = replace(popup3,' to chamber ',"")
console('popup3 '+popup3)
var finalresult = when(cnt <= 2 && cntchambers==0,popup,cnt == 0 && cntchambers==2, popup2,cnt == 1 && cntchambers==1, popup3,'n/a')
console('finalresult '+finalresult)
return finalresult
... View more
10-28-2020
03:17 PM
|
0
|
3
|
3633
|
|
POST
|
Hi All See Acade expression Var polesLayer = FeatureSetByPortalItem(Portal('myportal'), 'xxxxxxxxxx')
var chambers = FeatureSetByPortalItem(Portal(''my portal'), 'xxxxxxxxxx')
Var buff = buffer($feature,1,'meters')
Var poles = Intersects(buff,polesLayer)
Var chambers = Intersects(buff,chambers)
var cnt = count(poles)
var cntchambers = count(chambers)
var popupResult = ''
for (var f in poles) {
popupResult += f.barcode + " to pole "
}var ChambResult = ''
for (var f in chambers) {
ChambResult += f.label + " to chamber "
}
var strLenght = count(popupResult)-8
var note = left(popupResult,strLenght)
var strLenght2 = count(ChambResult)-15
var note2 = left(ChambResult,strLenght2)
var popup = IIf(cnt==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)),'to pole',''), ("install subduct " + DomainName($feature,"sub_size")+ " from pole " +text(note)))
var popup2 = IIf(cntchambers==1, replace(("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)),'to chamber',''), ("install subduct " + DomainName($feature,"sub_size")+ " from chamber " +text(note2)))
var popup3 = "install subduct " + DomainName($feature,"sub_size")+" from the chamber "+ChambResult+" to the pole "+popupResult
var popup3 = replace(popup3,' to pole ',"")
var popup3 = replace(popup3,' to chamber ',"")
var finalresult = when(cnt <= 2 && cntchambers==0,popup,cnt == 0 && cntchambers==2, popup2,cnt == 1 && cntchambers==1, popup3,'n/a')
return finalresult i am using this expression to check if a line is intersecting two point feature layers and return an expression to run a specific type of subduct between each feature. the expression works as expected in the pop up but when i try to run it in the field calculator it fails with the expression "Cannot read property 'length' of undefined error"
... View more
10-28-2020
05:59 AM
|
0
|
14
|
5050
|
|
POST
|
Hi Carlos Ruano Did you try to make the referer the actual form url as opposed to just survey123 website? You are experiencing the same issue as me only I am seeing this behavior on the desktop browser my form loads fine on the mobile device.
... View more
10-27-2020
01:30 PM
|
0
|
1
|
2889
|
|
POST
|
Hi Jay Johnson On my phone it is android 10 ,samsung galaxy AE20. The tablet I have tried it on is 8.1.0 neither are working. Samsung Galaxy tab. The Workforce app is version 20.1.1
... View more
10-27-2020
01:22 PM
|
0
|
0
|
712
|
|
BLOG
|
Hi James Tedrick Thanks i had rasied a ticket but it suddenly started working again over the week end all scenarios returning expected results with out any changes made on my side I can only guess it was some service issue. i ll work with support and explain the situation. Thanks for your response.
... View more
10-27-2020
03:11 AM
|
0
|
0
|
12315
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-27-2025 09:54 AM | |
| 2 | 08-27-2025 09:46 AM | |
| 11 | 05-06-2025 03:32 AM | |
| 1 | 03-30-2022 03:21 AM | |
| 1 | 05-03-2022 03:29 AM |
| Online Status |
Online
|
| Date Last Visited |
yesterday
|