The "Forms" tab in DevResults offers some basic tools to help you create reports, briefings, letters, forms, or other paperwork in Microsoft Word.
Forms in DevResults work like Microsoft Word's Mail Merge. First, you create a template document that contains fixed text and appropriate formatting. Then you add specific field names which act as placeholders. The placeholders are replaced with information from DevResults when you download the form.
NOTE: The formatted document should be saved as a .mht file before uploading to DevResults.
When you download a form, you get a Word document with any headings/logos/formatting/text that you designed, but with up-to-date information filled in about an activity.
How to Make a Form Template
- Make the Word document that will be populated with DevResults information.
- Add placeholders for the information that should be populated from DevResults. All you have to do is write those placeholders in double brackets, like
[[this]]. For a list of the field names that serve as placeholders, please see Form Templates: Activity, Form Templates: Indicator, and Form Templates - Reporting Periods. While it may go against your better instincts, we recommend typing the placeholders out by hand rather than copying and pasting, as hidden characters may be copied without your knowledge that would break the placeholder code.
- Save the document as a Single File Web Page (*.mht, *.mhtml)
- Upload your form to the Forms Templates page (under the Administration menu). Mark the form type as "Activity".
- Now save time on repetitive paperwork by downloading your updated document the Forms tab of your activities.
Here's an example of a Word document designed to be a form in DevResults. Note the placeholders in
To add a form template to DevResults, go to the Administration menu and select Form Templates.
Click "Upload Form Templates" and select the Single File Web Page(*.mht, *.mhtml) you'd like to upload.
By default, all forms are created as Activity Form Templates. To change this or edit details for the template, hover over the template and click on the Edit button that appears.
Here, you can edit the Form Template Title, add a Description for the template or instructions for when to use it, and select the form template Type. "Activity" forms add a copy of the form template to each activity so it can be populated with any activity's information. "Activity (one reporting period)" forms add a copy of the form template to each activity/reporting period combination so it can be populated with the activity's information for each reporting period. For this example, we'll keep Activity selected.
Now go Program Info > Activities and select your activity from the index. Then, click on the Forms tab to see all the forms available for that activity. Click on the form's hyperlink to automatically populate the Word document with the activity's information and download it.
Once downloaded, the [[bracketed fields]] in your template will be populated with your selected information.
Exporting with Formatting
If you use Markdown to format your text, you can keep the formatting when you download the form by adding the following text to your [[bracketed field]]:
For example, if you're trying to include Markdown formatting in the Activity's Objectives field, the [[bracketed field]] would look like this:
The exception is for narrative response fields, where you don't repeat the field name. For example:
Didn't answer your question? Please email us at firstname.lastname@example.org.