I have a Form that is using an entity list called ‘farmers_list.csv’. With this form all farmers that receive trees are listed. At a second stage, we want to register the areas of farmers that received trees. This is basically a monitoring. What I do is call a farmer name from the farmers entity list. Than we map the area for that farmer. The mapped area must then be stored in the entity list (under ‘geometry’) so that we can later on monitor their tree planting.
I now encounter a problem with updating the geometry column in the entity list. I can’t get it working. Please find the attached excel (extraction of the full version). Can someone give me a hint how I will be able to update the geometry field? Thanks!
I have just done the same thing with a form and entity list for the first time - published the form yesterday!
Your tree_registration_name_recipient looks like you have parameter: value=site_id_dist is that the Entity_ID? - in your entities sheet it says entity_id is tree_registration_name_recipient - are they the same? If not, that might be the problem?
When you submit a form, do you get a value in select_geometry?
And I assume you have published the form, not testing a draft (I confess to having done that and wondered why the Entity was not updated…)
I’ll give you my example, in case it sheds any light: I have 3 possible geometry types (like you) and the enumerator selects an Item which is the Enity_ID
I also have a question (UpdateGeom) which asks whether to update the existing geometry value in the Entity…
My Calculate is:
if(${Item}='' or ${UpdateGeom}!='',coalesce(${Length-measure},coalesce(${Area-measure},${Location})),instance('ENTITYLISTNAME')/root/item[name=${Item}]/geometry)
And I have save_to as geometry
Mine works… it is a ‘nested’ Coalesce as I only allow one geometry question to be answered, so if it is a new entity or the enumerator asks to update the geometry, I’m looking for a non-blank from those 3 fields, or the use the existing Entity geometry.
Thanks for the response. The issue indeed had to do with the parameter settings (value = site_id_dist). This probably caused the update not to be triggered by tree_registration_name_recipient. Once I removed the parameter setting, it worked. The only issue now is that I need a parameter setting for good visualisation…. Anyway, the cause for this problem is found now. Many thanks!