Sandboxcalsync: Difference between revisions

Revision as of 22:07, 25 July 2025

Material	SDS Doc	SDS Link	Tool

@@ Line 1: / Line 1: @@
+=={{#external_value:StudioName}}==
+==={{#external_value:Room}}===
+{| class="wikitable sortable"
+! Material
+! SDS Doc
+! SDS Link
+! Tool {{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} {{{SDSName}}}
+{{!}} [{{{SDS Doc}}} (view local copy) ]
+{{!}} [{{{SDS Link}}} (weblink to SDS)]
+{{!}} {{{ToolName}}}
+}}
+|}
+<!-- Crafts and Sewing -->
 {{#get_web_data:
-  url=https://upload.wikimedia.org/wikipedia/commons/3/3c/Test_external_data.csv
+  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=Item=Item, Quantity=Quantity
+  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
-}}
-== Test Table ==
-{| class="wikitable"
-! Item !! Quantity
-{{#for_external_table:<nowiki/>
-{{!}}-
-{{!}} {{{Item}}}
-{{!}} {{{Quantity}}}
 }}
-|}