BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
| Line 81: | Line 81: | ||
# '''Stolen''' - If a volunteer is making a theft or missing equipment report, this input field opens so they can describe what they saw and why they think the cache or cache equipment is missing or stolen. | # '''Stolen''' - If a volunteer is making a theft or missing equipment report, this input field opens so they can describe what they saw and why they think the cache or cache equipment is missing or stolen. | ||
# '''Note''' - If someone wants to note something about a BEECN resource that is not a visual check, inventory, test result, or theft report, they can use this input field. It's like a "miscellaneous" field. | # '''Note''' - If someone wants to note something about a BEECN resource that is not a visual check, inventory, test result, or theft report, they can use this input field. It's like a "miscellaneous" field. | ||
# '''Submit Trouble Ticket?''' - This is not a column that appears in the form used by volunteers. But if a volunteer writes a '''Note''' that warrants further action or investigation, the BEECN | # '''Submit Trouble Ticket?''' - This is not a column that appears in the form used by volunteers. But if a volunteer writes a '''Note''' that warrants further action or investigation, the BEECN Program Manager can click the flag icon and the row will be copied to 4.) BEECN Trouble Tickets. | ||
=== BEECN Journal Automations === | === BEECN Journal Automations === | ||
| Line 113: | Line 113: | ||
# '''SmSh Contact''' - The volunteer's profile name in SmartSheet. Having a profile in SmartSheet means the volunteer can be subject to SmartSheet automations. | # '''SmSh Contact''' - The volunteer's profile name in SmartSheet. Having a profile in SmartSheet means the volunteer can be subject to SmartSheet automations. | ||
# '''Call Sign''' - FCC issued radio call sign, if the volunteer has one. | # '''Call Sign''' - FCC issued radio call sign, if the volunteer has one. | ||
# '''Notes''' - Any special notes that the BEECN | # '''Notes''' - Any special notes that the BEECN Program Manager cares to add about this volunteer (e.g. "Speaks Spanish"). | ||
=== BEECN Volunteers Sheet Filters === | === BEECN Volunteers Sheet Filters === | ||
| Line 135: | Line 135: | ||
* An email is automatically sent to BEECN@portlandoregon.gov when a new row appears in this sheet, alerting PBEM to the issue. | * An email is automatically sent to BEECN@portlandoregon.gov when a new row appears in this sheet, alerting PBEM to the issue. | ||
A row is copied from 2.) BEECN Journal to 4.) BEECN Trouble Tickets also if, in the former sheet, the BEECN | A row is copied from 2.) BEECN Journal to 4.) BEECN Trouble Tickets also if, in the former sheet, the BEECN Program Manager clicks the flag icon in the column labeled "'''Submit Trouble Ticket?"''' | ||
A Trouble Ticket remains open until the BEECN | A Trouble Ticket remains open until the BEECN Program Manager closes it. Tickets are closed by placing a date in the '''"Close Date"''' column. | ||
=== Unhidden Columns === | === Unhidden Columns === | ||
| Line 143: | Line 143: | ||
# '''Resource Name -''' Name of the BEECN resource as a drop-down menu, under the same naming convention found in 1.) BEECN Master Tracker. | # '''Resource Name -''' Name of the BEECN resource as a drop-down menu, under the same naming convention found in 1.) BEECN Master Tracker. | ||
# '''Review Date''' - When the volunteer observed the resource (not when they reported it). | # '''Review Date''' - When the volunteer observed the resource (not when they reported it). | ||
# '''Close Date''' - Date the BEECN | # '''Close Date''' - Date the BEECN Program Manager closed the ticket. | ||
# '''Duration ''<span style="background:firebrick; color:firebrick">_</span><span style="background:firebrick; color:white">locked</span><span style="background:firebrick; color:firebrick">_</span>''''' - The number of days between '''Review Date''' and '''Close Date''' (and therefore, it only appears after a close date is inputted). <span style="background:yellow">Formula is:</span> ''=IFERROR(NETDAYS([Review Date]@row, [Close Date]@row), " - ")'' | # '''Duration ''<span style="background:firebrick; color:firebrick">_</span><span style="background:firebrick; color:white">locked</span><span style="background:firebrick; color:firebrick">_</span>''''' - The number of days between '''Review Date''' and '''Close Date''' (and therefore, it only appears after a close date is inputted). <span style="background:yellow">Formula is:</span> ''=IFERROR(NETDAYS([Review Date]@row, [Close Date]@row), " - ")'' | ||
# '''Type''' - This is the type of problem associated with the trouble ticket. '''The BEECN | # '''Type''' - This is the type of problem associated with the trouble ticket. '''The BEECN Program Manager must select this.''' It is a drop-down with the following options: | ||
#* Cache box - lid/lock | #* Cache box - lid/lock | ||
#* Cache box - contents | #* Cache box - contents | ||
