Safety Data Sheets: Difference between revisions

From sandbox
Jump to navigation Jump to search
Gfc (talk | contribs)
Replaced all with contents of test page
Mharrit1 (talk | contribs)
No edit summary
Line 9: Line 9:
             https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0  
             https://drive.google.com/open?id=1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0  
             (must have permission to edit)  
             (must have permission to edit)  
 
https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
-->
-->
<!-- Electronics Studio -->
<!-- Electronics Studio -->
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
  url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:html&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1246%22
  |format=CSV with header
  |format=CSV with header
  |filters=Room=IRB1246
  |filters=Room=IRB1246
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
}}
}}
=={{#external_value:StudioName}}==
=={{#external_value:StudioName}}==
==={{#external_value:Room}}===
==={{#external_value:Room}}===

Revision as of 20:18, 10 October 2020

{{#get_web_data:

url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:html&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1246%22
|format=CSV with header
|filters=Room=IRB1246
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1242
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1238
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1223
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1224
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1222
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|filters=Room=IRB1220
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

{{#external_value:StudioName}}

{{#external_value:Room}}

Material SDS Doc SDS Link Tool {{#for_external_table:
{{{SDSName}}} [{{{SDS Doc}}} (view local copy) ] [{{{SDS Link}}} (weblink to SDS)] {{{ToolName}}}

}}

{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room

}}

All Safety Data Sheets

Room Studio Name Tool Material SDS Doc SDS Link {{#for_external_table:
{{{Room}}} {{{StudioName}}} {{{ToolName}}} {{{SDSName}}} [{{{SDS Doc}}} Sandbox local PDF copy ] [{{{SDS Link}}} Safety Data Sheet]

}}