hubot-standup-formstack-cron

A hubot script that gets Formstack entries from a form for a stand up scrum meeting and posts the info on a cron or by command.

Installation

In hubot project repo, run:

npm install hubot-standup-formstack-cron --save

Or add "hubot-standup-formstack-cron": "" to your package.json dependencies

Then add hubot-standup-formstack-cron to your external-scripts.json:

[
  "hubot-standup-formstack-cron"
]

Configuration

Requires a Formstack form and access to Formstack api. All forms must be on the same account, and the api key must have access to all of the forms you want to add to this script.
Formstack - "An intuitive, drag-and-drop form and workflow builder that allows businesses to collect information that matters and automate processes".

Note

• Formstack form MUST have fields with the following key terms (in any order).
• The fields do not need to be verbatim and are not case sensitive.
• "Date of report" would work for the "Date" field.

| Key Term | Description | | -------- | ----------- | | 'Date' | (REQUIRED) Formstack date the report is for | | 'Yesterday' | (REQUIRED) Formstack tasks from Yesterday| | 'Today' or 'Previous' | (REQUIRED) Formstack tasks for Today | | 'Blocker' or 'Impeding' | (REQUIRED) Blockers or items keeping work or tasks from happening | | 'First Name' | (REQUIRED) Formstack User (first or other) name | | 'Last Name' | (OPTIONAL) Formstack User Last Name |

Environment Variables:

A single form can be setup by default using the Environment Variables

Normal setup is done from the built in command

| Key Term | Description | | -------- | ----------- | | HUBOT_FORMSTACK_TOKEN | (Required) Formstack API Token | | HUBOT_FORMSTACK_PREFIX | (Optional) set a prefix for multiple standup reports | | HUBOT_FORMSTACK_HEAR | (Optional) Turn on or off hubot hear (default off) | | HUBOT_FORMSTACK_SUBMISSIONS_LOOKBACK | (Optional) Filter Formstack submissions within X day ago (default 5 days) | | HUBOT_FORMSTACK_TIMEZONE | (Optional) global timezone for all forms used by the reminder and report | |-- Preset From Options --|| | HUBOT_FORMSTACK_FORM_ID | (Optional) Formstack preset form ID | | HUBOT_FORMSTACK_URL | (Optional for reminder) url of the preset form for auto reminder | | HUBOT_FORMSTACK_CHAT_ROOM_NAME | (Optional for reminder and report) Preset Chat room name for auto reminder and report | | HUBOT_FORMSTACK_REMINDER_CRON | (Optional for reminder) Preset schedule a reminder to fill the form | | HUBOT_FORMSTACK_STANDUP_REPORT_CRON | (Optional for auto report) Preset schedule to send the submissions |

Commands:

hubot standup setup <FORMID> <TIME> <REMINDER> <CRONDAYS> - Setup the script for the first time
    FORMID - Formstack Form ID\n`;
    TIME - Time of auto post (8:00am or 14:00)
    REMINDER - Number of minutes before to send reminder (15) Default 30
    CRONDAYS - Days to post in cron format (1-5 or 0,1,2,3) 0 = Sunday. Default 1-5 (weekdays)
    Reminder and crondays can be skipped to accept defaults

hubot standup            List all results of standup form for today
hubot standup today      List all who have filled out the standup form today
hubot standup <person>   List <person> results of standup form today (search first and/or last name)
hubot standup randomize  Randomize the list of all results of standup form
hubot standup remove     Remove the standup link form the room

Sample Interaction:

CustomPrefix = Ateam (Optional)
Kate and Sam fill out form:

(on reminder cron)
Hubot:        @here Time to fill out the stand up report <Link_to_form>
              Sam has filled out the report for today

Sam:          hubot Ateam-standup
Hubot:        Kate: Jan-01-2019
                Yesterday:
                  - tasks
                Today:
                  - tasks
                Blocker:
                  - none

              Sam:
                Yesterday:
                  - tasks
                Today:
                  - tasks
                Blocker:
                  - none

Sam:          hubot Ateam-standup today
Hubot:        Kate and Sam have filled out the report for today

Sam:          hubot Ateam-standup Kate
Hubot:        Kate: Jan-01-2019
                Yesterday:
                  - tasks
                Today:
                  - tasks
                Blocker:
                  - none

NPM Module

https://www.npmjs.com/package/hubot-standup-formstack-cron