Sandboxcalsync: Difference between revisions

Revision as of 22:08, 25 July 2025

Date	Start Time	End Time	Employee	Skills

@@ Line 1: / Line 1: @@
-=={{#external_value:StudioName}}==
+== Sandbox MOD Schedule ==
-==={{#external_value:Room}}===
 {| 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 Time}}}
-{{!}} [{{{SDS Link}}} (weblink to SDS)]
+{{!}} {{{End Time}}}
-{{!}} {{{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
+  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=1076536326&tq=select%20A%2CB%2CC%2CD%2CE
   |format=CSV with header
-  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
+  |data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
 }}