Sandboxcalsync: Difference between revisions

@@ Line 1: / Line 1: @@
-=={{#external_value:StudioName}}==
+<!--
-==={{#external_value:Room}}===
+{{#get_web_data:
+ url=https://docs.google.com/spreadsheets/u/0/d/1J_mrE18Kf_mbcbYFDThwqnmtgfK5OLwFF4T-U0BpTgM/gviz/tq?tqx=out:csv&gid=1076536326
+ |format=CSV with header
+ |data=Date=Date, Start=Start Time, End=End Time, Employee=Employee, Skills=Skills
+}}
+== Sandbox MOD Schedule ==
 {| class="wikitable sortable"
-! Material
+! Date !! Start Time !! End Time !! Employee !! Skills
-! SDS Doc
+{{#for_external_table:<nowiki/>
-! SDS Link
-! Tool {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{SDSName}}}
+{{!}} {{{Date}}}
-{{!}} [{{{SDS Doc}}} (view local copy) ]
+{{!}} {{{Start}}}
-{{!}} [{{{SDS Link}}} (weblink to SDS)]
+{{!}} {{{End}}}
-{{!}} {{{ToolName}}}
+{{!}} {{{Employee}}}
+{{!}} {{{Skills}}}
 }}
 |}
-<!-- Crafts and Sewing -->
+-->
-{{#get_web_data:
- url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1242%22%20or%20A%3D%22Room%22
- |format=CSV with header
- |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
-}}

Latest revision as of 21:28, 28 September 2026