Safety Data Sheets: Difference between revisions

From sandbox
Jump to navigation Jump to search
← Older editNewer edit →
Mharrit1 (talk | contribs)
sandbox-editors
509 edits
No edit summary
Gfc (talk | contribs)
Bureaucrats, sandbox-editors, Administrators, Widget editors
2,219 edits
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)  
------
        need to switch to:    https://drive.google.com/open?id=1Ob36a_Dzh5EALMhyPMuvA7wWiAVMb9qQ
          which is in the Sandbox Managers & Staff Shared Drive in the /Safety/SDS/ folder
can't get csv query to work        tried: https://drive.google.com/file/d/1Ob36a_Dzh5EALMhyPMuvA7wWiAVMb9qQ/gviz/tq?tqx=out:csv


-->
-->

Revision as of 20:47, 1 April 2021

{{#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%22IRB1246%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

}}

{{#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/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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1238%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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1223%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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1224%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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1222%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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0&tq=select%20A%2CB%2CC%2CD%2CE%2CF%20where%20A%3D%22IRB1220%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

}}

{{#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/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=0
|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]

}}

Retrieved from "https://sandbox.umd.edu/wiki/index.php?title=Safety_Data_Sheets&oldid=2190"