Safety Data Sheets: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
<!-- Try1: Filter using External Data filters feature --> | <!-- Try1: Filter using External Data filters feature | ||
Why doesn't this filter? | |||
--> | |||
{{#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/d/e/2PACX-1vQaivE1SSnZM2WJLGCX5Xx3w_8ZcJdGt6XI6JB-bVtugrvbqvKpN8TkqJDFfJh4EhDS-YAF3Plh-1Rf/pub?gid=0&single=true&output=csv | ||
|format=CSV with header | |format=CSV with header | ||
|filters=StudioName=Prototyping Studio | |||
|data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link | |data=StudioName=Studio, ToolName=Tool, SDSName=SDS Name, SDSLink=SDS Link | ||
}} | }} | ||
| Line 35: | Line 37: | ||
<!-- Try2: Add SELECT WHERE clause to Google sheets query --> | <!-- Try2: Add SELECT WHERE clause to Google sheets query | ||
Why doesn't the query SELECT WHERE clause work? If I cut and paste the URL into a web browser the results seem correct. | |||
--> | |||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
| Line 59: | Line 64: | ||
<!-- Try3: Add SELECT WHERE clause to Google sheets query | |||
Why doesn't the query SELECT WHERE clause work? If I cut and paste the URL into a web browser the results seem correct. | |||
--> | |||
{{#get_web_data: | {{#get_web_data: | ||
Revision as of 20:21, 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 |filters=StudioName=Prototyping Studio |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]
}} |
{{#clear_external_data:}} {{#get_web_data:
url=https://docs.google.com/spreadsheets/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&tq=select%20A%2C%20B%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]
}} |