BEECN Journaling System Back-end: Difference between revisions
From Portland NET Wiki
| Line 56: | Line 56: | ||
== 2.) BEECN Journal == | == 2.) BEECN Journal == | ||
This back-end sheet collects data inputs from the front-end and routes that data to the other BEECN sheets, and ultimately the data is reflected in the BEECN Dashboard. That data is collected from BEECN volunteers through a [[BEECN Journaling System|SmartSheet form]] linked to this sheet, and the columns in this sheet correspond to the questions asked on the form. | This back-end sheet collects data inputs from the front-end and routes that data to the other BEECN sheets, and ultimately the data is reflected in the BEECN Dashboard. That data is collected from BEECN volunteers through a [[BEECN Journaling System|SmartSheet form]] linked to this sheet, and the columns in this sheet correspond to the questions asked on the form. When a form is submitted, the input is added as a new row to the top of this sheet. | ||
=== The BEECN Journal Form === | === The BEECN Journal Form === | ||
The BEECN Journal form is intended to act as a catch-all for volunteer reports of any kind: confirming a visual check of the cache, confirming an inventory of the cache, confirming a cache that is stolen or missing, and making a note about a cache. The form is constructed with question logic that revelas questions based on the type of report the volunteer is making. For example, at the start of the form, inventory questions only will be shown if the volunteer is reporting an inventory. A complete breakdown of the form is at: [[BEECN Journaling System]]. | The BEECN Journal form is intended to act as a catch-all for volunteer reports of any kind: confirming a visual check of the cache, confirming an inventory of the cache, confirming a cache that is stolen or missing, and making a note about a cache. The form is constructed with question logic that revelas questions based on the type of report the volunteer is making. For example, at the start of the form, inventory questions only will be shown if the volunteer is reporting an inventory. A complete breakdown of the form is at: [[BEECN Journaling System]]. | ||
=== 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. | |||
# '''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. | |||
# | # | ||
