Form Publisher (Moved)



https://slite.com/api/files/2_ZVXAnlKL-cP8/image.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiOUo1YlJVMjU0RTM5QmUiLCJpYXQiOjE3MzA5NTgzMjcsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiYU13cWhKa1N5MWd2S1QiLCJleHAiOjE3MzM1NTAzMjd9.JwQaZ-rpQRsV2cBsUBSKOUnTh8k8sBpoZ95sD4i3Hbc

What is Form Publisher?

 Form Publisher  is a software tool that allows users to automate the creation of documents based on Google Forms responses. With Form Publisher, you can generate customized PDFs, Google Docs, Sheets, Slides, or Microsoft Word documents based on the information submitted through your Google Forms.
Form Publisher streamlines document creation by eliminating the need for manual data entry and copy-pasting, saving users time and reducing the risk of errors. It allows you to define document templates that can include dynamic fields, such as date and time stamps, conditional text, and images.
Form Publisher also provides advanced features like document approval workflows, document sharing and publishing, as well as the ability to customize the look and feel of the generated documents. Additionally, the tool offers integration with third-party platforms, such as Dropbox, Box, and Zapier, for more advanced automation capabilities.
Overall, Form Publisher is an intuitive and efficient tool for creating customized documents based on form submissions, making it a useful tool for businesses, organizations, and individuals looking to streamline their document creation process.

Configuring Form Publisher

Form Publisher Settings

<< >> Template and Markers
  • Set multiple-choice questions to be created with commas
  • Change DOB to dd/MM/YYYY
  • Double check Timestamp is displaying timezone indicator

Add-On Settings

File Folder Destination folders & routing rules

  • We recommended that you select a designation folder for all form submission generated files to be sent to, for example; Completed Folder
  • In this setting you will want to select the chosen folder.
  • This will have to be done for each of your Google Forms
  • If you elect not choose a folder custom folder, Form Publisher will create a new destination folder
  • Known Issues
  • Form Publisher will create a new destination folder for each from unless you elect to use a Drive Folder
  • The default designation folder created by Form Publisher are all titled the same, which could cause confusion.
  • If you delete a dentition folder that us linked to a Google Form, generated form submission files will be sent to your Google Drive but not placed in a folder.

Paperclip File generation options


https://slite.com/api/files/KYlRsPxt-WaxXc/image.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiOUo1YlJVMjU0RTM5QmUiLCJpYXQiOjE3MzA5NTgzMjcsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiYU13cWhKa1N5MWd2S1QiLCJleHAiOjE3MzM1NTAzMjd9.JwQaZ-rpQRsV2cBsUBSKOUnTh8k8sBpoZ95sD4i3Hbc

https://slite.com/api/files/4R6oywRFIahTmH/image.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiOUo1YlJVMjU0RTM5QmUiLCJpYXQiOjE3MzA5NTgzMjcsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiYU13cWhKa1N5MWd2S1QiLCJleHAiOjE3MzM1NTAzMjd9.JwQaZ-rpQRsV2cBsUBSKOUnTh8k8sBpoZ95sD4i3Hbc
Response spreadsheet: - Keep file URL = On - Keep increment = On
Form submission edit
  • Enable response editing = On
  • Edit existing files in place = On Other Options
  • Keep PDF copy in Drive = Off

Memo Naming convention

Generated files title
  • Timestamp = On
  • Timestamp Formmating = MM.dd.YYYY hh:mm:ss z e.g., 08:15:03 EDT
  • <<Today>> <<First Name>> <<Last Name>> <<Template Title>> <<Increment>>
  • Today Formating = YYYY.MM.dd e.g. 2023.04.11
  • Template Title = On
  • Increment = One *Start on 1 unless form has been submitted already

Shuffle Tracks Button Sharing options and notifications

Sharing list
  •  edward@darrahcounseling.com 
  • Share Google Docs = Can Edit *Can not change setting

https://slite.com/api/files/u3WjkKzGlqKUxf/image.png?apiToken=eyJhbGciOiJIUzI1NiIsImtpZCI6IjIwMjMtMDUtMDQifQ.eyJzY29wZSI6Im5vdGUtZXhwb3J0IiwibmlkIjoiOUo1YlJVMjU0RTM5QmUiLCJpYXQiOjE3MzA5NTgzMjcsImlzcyI6Imh0dHBzOi8vc2xpdGUuY29tIiwianRpIjoiYU13cWhKa1N5MWd2S1QiLCJleHAiOjE3MzM1NTAzMjd9.JwQaZ-rpQRsV2cBsUBSKOUnTh8k8sBpoZ95sD4i3Hbc

Bookmark Tabs Additional templates

Counterclockwise Arrows Button Regenerate files

Man Frowning Form status and account info

Form Publisher Checklist

  • Review Question Flow
  • Review Form Publisher Template
  • Run Form Publisher checker within Google Forms
  • Look at both goal questions, potentially remove one
  • Update Template Sheet
  • Link Form Submission Sheet to Darrah Counseling EHR Sheet
  • Add form links to EHR Forms Sheet

Form Publisher Help Doc References

  •  Form Publisher 
  •  Configure the format of date-time question markers 
  •  Use advanced formulas in your Google Sheets template 
  •  Standard markers in Form Publisher