Safety Data Sheets: Difference between revisions

From sandbox
Jump to navigation Jump to search
Gfc (talk | contribs)
No edit summary
Gfc (talk | contribs)
No edit summary
Line 37: Line 37:
<!-- Try2: Add SELECT WHERE clause to Google sheets query -->
<!-- Try2: Add SELECT WHERE clause to Google sheets query -->


 
{{#clear_external_data:}}
{{#get_web_data:
{{#get_web_data:
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20A%3D'Woodworking%20Studio'
  url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20A%3D'Woodworking%20Studio'

Revision as of 20:10, 13 November 2019

Prototyping Studio

Ultimaker S5 FDM 3D Printer


{{#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=SDS Name, SDSLink=SDS Link
|filters=StudioName=

}}


Studio Tool SDS Name SDS Link {{#for_external_table:
{{{StudioName}}} {{{ToolName}}} {{{SDSName}}} [{{{SDSLink}}} Safety Data Sheet]

}}


{{#clear_external_data:}} {{#get_web_data:

url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20A%3D'Woodworking%20Studio'
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link

}}


Studio Tool SDS Name SDS Link {{#for_external_table:
{{{StudioName}}} {{{ToolName}}} {{{SDSName}}} [{{{SDSLink}}} Safety Data Sheet]

}}


{{#get_web_data:

url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20C%2C%20D%20where%20A%3D'Electronics%20Studio'
|format=CSV with header
|data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link

}}


Studio Tool SDS Name SDS Link {{#for_external_table:
{{{StudioName}}} {{{ToolName}}} {{{SDSName}}} [{{{SDSLink}}} Safety Data Sheet]

}}