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.
In hubot project repo, run:
npm install hubot-standup-formstack-cron --save
"hubot-standup-formstack-cron": "" to your package.json dependencies
Then add hubot-standup-formstack-cron to your
[ "hubot-standup-formstack-cron" ]
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".
- 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.
|'Date'||(REQUIRED) Formstack date the report is for|
|'Yesterday'||(REQUIRED) Formstack tasks from Yesterday|
|'Today'||(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|
A single form can be setup by default using the Environment Variables
Normal setup is done from the built in command
|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|
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 remove Remove the standup link form the room
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