|
POST
|
I figure they must be some soft of trigger or sp but I cant find them. Thanks.
... View more
06-12-2020
11:09 AM
|
1
|
2
|
3578
|
|
POST
|
I am actually trying to edit a different feature class using "Edit", which still does not work. What you are doing does work: { return Null; }
... View more
05-07-2020
11:12 AM
|
1
|
1
|
3265
|
|
POST
|
Have you tested with S123? I have not had luck with a trigger producing incremental values with S123. I currently have to use a Trigger & Job for my incremental values. SQL Trigger on table causes CODE 500 Error. SQL Trigger on featurclass in SQL SERVER
... View more
05-01-2020
09:58 AM
|
0
|
1
|
4933
|
|
POST
|
This is great, but it doesn't seem to work correctly when creating records in a Web App or Survey123. It increments by 2. Posting from the server seems to make two inserts causing the double incremental value. Anyone figure this out?
... View more
05-01-2020
08:18 AM
|
0
|
3
|
4933
|
|
POST
|
This script adds sequential values based on the last value. My problem is I have to have at least one value already in place for First() to work, else it errors out. Also when I try to add a Count() I get Array type expected error. How do you properly code for: AKA how do you check for empty table and if empty give it a value? if count == 0 {return something}
else do this
else do that
This code below works great as long as there one record in the table with an assignednum. If not it errors on line 3. I tried to code with IIf & IsNaN/IsEmpty with no avail. (Attribute Calculation Rule on Insert) Thanks. Xander Bakker var sql = Concatenate("assignednum like", "'%", Year(Now()), "%'")
var fs = first(OrderBy(Filter(FeatureSetbyName($datastore, table), sql), 'assignednum DESC'))
var lastnum = Number(mid(fs.assignednum,11,4),'0000' )
var int = ++lastnum
if (number(mid(fs.assignednum,6,4)) == Year(Now())) {
return Concatenate("SUDOE ",Year(Now()),"-",text(int,'0000'),"RCI")
}
else if (number(mid(fs.assignednum,6,4)) != Year(Now())) {
return Concatenate("SUDOE ",Year(Now()),"-0001","RCI")
}
... View more
04-28-2020
02:29 PM
|
0
|
1
|
1337
|
|
BLOG
|
James Tedrick This is also an issue for me. Its seems using calculations fail because instance_name errors (doesn't return anything so you cant use a function) when using any function with the inbox. For instance, jr:choice does not work in the inbox. Huge limitation with no work around??
... View more
04-16-2020
10:00 AM
|
0
|
0
|
18428
|
|
BLOG
|
Thanks for the hard work. Can't wait to see the code in AppStudio in the next couple of days!
... View more
04-03-2020
05:25 AM
|
1
|
0
|
8948
|
|
BLOG
|
How does the S123 app know there is an update to a form? It does not seem to rely on the version manually entered...
... View more
04-02-2020
02:57 PM
|
0
|
0
|
1507
|
|
POST
|
Is there a way to force a recalculate? I would like a date field to be updated with the current date every time it is submitted from the inbox. Basically I have a filter on the Inbox to filter out current_month. So when a record is submitted it gets updated with current date, thence removed from the inbox. It will reappear the next month and so on.
... View more
03-11-2020
09:42 AM
|
0
|
0
|
5737
|
|
POST
|
I believe those are not stored in the database, they can be found in the My Survey Attachments folder on your device. ...\username\arcgis\My Survey Attachments
... View more
03-04-2020
05:45 AM
|
0
|
0
|
6269
|
|
POST
|
This is not fixed in 2.5 within Attribute Rules. BUG-000119064: Calculating a value to null using Arcade returns 0 is fixed when using the stand alone Calculate Field tool. https://community.esri.com/thread/247788-cant-return-null-when-using-attribute-rule-editupdate-and-arcade
... View more
02-07-2020
05:54 AM
|
0
|
0
|
5631
|
|
POST
|
While Null now works in arcade field calculations on Pro 2.5, it still does not work in Attribute Rules while using the edit keyword and update. Attribute rule dictionary keywords—Geodatabases | Documentation return {
"result": $feature.assetid,
"edit": [{
"className": "electricdistributionassembly",
"updates": [{
"objectID": feature_objectid,
"associationType": Null
}]
}]
} The above code will not work. It returns a what I am guessing is an empty field. It does not work on strings or dates. I need a simple attribute rule that updates a field to "Something" on insert/update and to <Null> on insert/update on "Something Else" My code works except that there is no way to return Null using Attribute Rules & Arcade. You can return a string, date or 0 (in the case of dates 12/30/1899). I have set to Null and tried to set it to a field that is Null.
... View more
02-06-2020
03:01 PM
|
0
|
5
|
3402
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 2 weeks ago | |
| 3 | 2 weeks ago | |
| 1 | 2 weeks ago | |
| 1 | 3 weeks ago | |
| 2 | 05-20-2026 02:50 PM |