I'm trying to automate the process of an intersect which passes values from many Points within a layer, to the polygon that it intersects. However I'm getting stuck when it comes to passing the values using the field calculator.
Here is what I have done so far.
1. Created an ActivityDate on my point layer (previously I was using the CreatedDate as the date field, however this wasn't coming across in fields)
2. Spatial join 1:many Polygon:Point
3. Joined this spatial join layer to the original Polygon layer (so that I can field calculate layers from the spatial join to the original layer).
4. Calculate field: LastMown (polygon) = ActivityDate (originally point but joined)
ERROR: Invalid Expression Datasource could not be found.
Some of the fields from the join are coming through (Action, Notes), however that field (or the createdDate field) aren't coming through.
There may be an easier way to do what I'm after - I'm all ears for a different way of doing this.
Ultimately I want to populate a 'last mown' field on my polygon layer with the date from the intersecting point layer which has a) the action 'completed' and b) the latest date.
After the above steps I was planning on doing a filter, to filter based on the Action == 'completed'. Then dissolve the reserves (based on target_ID) with the latest date on it.