Skip to main content

Dear community,

 

I am trying to activate a workspace when a survey123 form has been edited and the user confirms that all necessary information has been completed (yes/no field). The work space would then extract data from ArcGIS online feature layer of incidents and the relevant repeat tables. The extracted data would then be used to populate a MS word template which once complete would be saved/exported as a pdf document. This pdf document would then be attached to an email and sent to the manager of who filled in the survey123.

 

My main problem is trying to find a way to fill in the relevant field in the template with the extracted information from the ArcGIS online layer. Is there a transformer or series of transformers which make this possible?

 

Thanks in advance.

 

Hi ​@kt_fish! Do you happen to have a workspace screenshot or some sample data you could share? That would help give the community more context about what you’ve tried so far and where things might not be working as expected.

Also, what version of FME are you working with? It sounds like you might have data coming into FME from ArcGIS Online. If that isn’t the case, my first thought is that the new ArcGIS Connector might be a good fit here. Here’s an article about it!
https://support.safe.com/hc/en-us/articles/25407563623565-How-to-Use-the-ArcGISOnlineConnector

Besides that, I could also see FME Flow webhooks might be useful to watch for Survey123 updates, and perhaps an AttributeManager to help map attribute values for a Word or PDF file styler/writer then the emailer or a Flow automation.

I haven’t tried these options out myself in a workflow, but I’m curious what you think or tried out!


Hi ​@desiree_at_safe  thanks for getting back to me.

See below screen shot of the workspace I have been working on.  I am afraid I cant share the AGOL feature service with the community as it confidential but a copy of the template I want to fill in with the AGOL data is in my post above. I am working with version 2025.1 of FME (as this version supports document PDF writer  )   

I was going to work on FME flow (webhook and Email part)  after I created the workspace to fill in the template data correctly using the AGOL data/feature service.