Our support site has moved, please go to https://support.formsonfire.com

Using Word/Excel Comments To Preserve Template Formatting

Often when building a template, your formula or placeholder syntax is too long to fit in the designated area of the template. 

The result is ugly word wrapping and it becomes harder to see how the template layout looks because of the distortion of the placeholder text.

Now, of course, the actual generated result still comes out just fine, but we wanted to make it easier to design your templates without having to constantly test the generated output to see if output formatting remained correct.

What we need is a way to "annotate" the placeholder/formula syntax onto specified text in the template.

Comments were the perfect answer, since these hover above the Word/Excel content without changing the actual layout.

Our template generation engine actively scans for comments that contain placeholder or formula syntax, and replaces the text linked to a comment with the placeholder/formula extracted from the comment itself.

Below is an example of a Word template that is using normal inline placeholder and formula syntax, resulting in word wrapping of the table cells:



Now here's the same template adjusted to use comments to hold formula syntax.
Note the checkbox characters in the table cells are simply text linked to the comments.
Those are replaced by the outcome of the comment syntax when the template generates.



Below is the output of the above template:



Assign Folders to the User from the list of available Folders.
Every Folder assigned to a User allows the Screens, Docs, and Data Sources inside that Folder to be downloaded and viewed when the User logs into the mobile app.

If you are using User Groups, then you can assign the user to one or more Groups as desired.

Once you’ve filled out the fields, hit the Create button to create the App User.  

When you create a new User an invitation email is automatically sent to their specified email address. 
The email contains the temporary password that must be used when logging into the website/app for the first time.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk