BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
| Line 63: | Line 63: | ||
=== Unhidden Columns === | === Unhidden Columns === | ||
# '''Reference Number''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span>'' - This column automatically gives a unique reference number to every new row added. This can make tracing an individual submitted form easier through the rest of the sheets that data is routed to. It is not governed by a formula but is automated. | # '''Reference Number''' ''<span style="background:firebrick; color:firebrick">'''_'''</span><span style="background:firebrick; color:white">'''locked'''</span><span style="background:firebrick; color:firebrick">'''_'''</span>'' - This column automatically gives a unique reference number to every new row added. This can make tracing an individual submitted form easier through the rest of the sheets that data is routed to. It is not governed by a formula but is automated. | ||
# '''Created ''<span style="background:firebrick; color:firebrick">_</span><span style="background:firebrick; color:white">locked</span><span style="background:firebrick; color:firebrick">_</span>''''' - Like the Reference Number column, this column is automated. It date stamps each new row as it comes in. | # '''Created ''<span style="background:firebrick; color:firebrick">_</span><span style="background:firebrick; color:white">locked</span><span style="background:firebrick; color:firebrick">_</span>''''' - Like the Reference Number column, this column is automated. It date stamps each new row as it comes in. | ||
# '''Resource Name -''' Name of the BEECN resource, under the same naming convention found in 1.) BEECN Master Tracker. | |||
# '''Journal Type''' - The type of report submitted: visual check, inventory, test results, theft, or a note. | |||
# '''Review Date''' - The date that the BEECN resource was reviewed (e.g. date a visual check was made or an inventory taken). This is ''not'' the same as when the report was submitted, which is the '''"Created"''' date mentioned earlier. | |||
# '''Reporter Name''' - Name of the volunteer making the report. | |||
# '''VC Report''' - Binary choice for a Visual Check, either "Looks Good" or "There is a problem". If "There is a problem" is selected, a text box opens on the form and the volunteer can provide details. | |||
# '''VC Problem''' - Details on any problems a volunteer observed concerning the BEECN resource while doing a visual check. | |||
# '''INV: Notes''' - Notes field for a volunteer to report any inventory problems with the cache. | |||
# '''INV: Rolling Cart, INV: Radio, INV: Support, INV: Notebooks, INV: Small Duffel, INV: Large Duffel,''' and '''INV: Clean''' are all checkboxes that guide a volunteer through completing a cache inventory. | |||
# '''TEST Signal''' - The quality of radio reception (on a one to five scale) received by the radio during a test. | |||
# '''TEST Issues''' - Any problems of note that a volunteer ran into during a BEECN test. | |||
# '''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. | |||
# '''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 Coordinator can click the flag icon and the row will be copied to 4.) BEECN Trouble Tickets. | |||
# | # | ||
