Team Fact Sheet
This is the documentation Wiki for SARCOP related to Team Fact Sheet and associated Power Automate / Make workflows.
The Team Fact Sheet Survey was created in the Survey123 Web Designer - item: f0c2ab27da8f49e6bf98d28926b416a0 https://survey123.arcgis.com/surveys/f0c2ab27da8f49e6bf98d28926b416a0/design
IMPORTANT: When sharing a direct link to TFS, use the suffix ?isOrgSignIn=false so the end user is not prompted with the NAPSG log-in page. https://survey123.arcgis.com/share/f0c2ab27da8f49e6bf98d28926b416a0?isOrgSignIn=false
The Survey is setup in sections with additional questions for FEMA Task Forces. See note below about making changes to the Design!
Whenever you make a change in Survey123 Web Designer - you must go to these feature layers and make this specific change to editing so that more than just the person who entered the Survey can make updates. 9794a7 SARCOP v9 Team Fact Sheet Editable View (arcgis.com) - this one seems to repeatedly set itself back to only allowing editors to edit their own features.
Be sure to check the settings for the Webhooks to make sure that they are set to both add and edit.
Team Fact Sheet adds row to Excel when added or edited. We use this spreadsheet as a back-up and "log" of adds and edits since we only keep the last record in Survey123 for each form entered.
Be sure to format this as shown to convert to Eastern Time (Zulu -4, and don't forget to update for -5 when Daylights Savings changes...)
This .txt file is saved in the Projects / Team Fact Sheet folder
This flow will send a Teams notification and email every time a new entry is added or when an entry is edited.
Survey123 Configuration
Send an E-mail Configuration
HTML Format for e-mail can be copied and pasted from here https://github.com/pjdohertygis/SARCOP/blob/62be7e7eb1ef5020d08b6a237a2e91932f318ef0/Team%20Fact%20Sheet%20to%20Email%20HTML.html
More details coming soon.
For awareness - I have created a Team Fact Sheet Dashboard - owned by nsargc_napsg App https://www.arcgis.com/apps/dashboards/f1bdf94be2c94c8c96e0b8654c7fcd9a Web Map Team Fact Sheet Overview Web Map - Overview (arcgis.com)
This is an ArcGIS Dashboard for quickly filtering and accessing Team Fact Sheet information and downloading attachments. The primary audience is the US&R IST Resource Unit Leader but may be used by NRCC SAR Unit Leader and similar roles.
It defaults to only showing Deployed Teams and Delete This = No. You can turn those off from the sidebar.