Safety Data Sheets: Difference between revisions

From sandbox
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
|filters=StudioName=
}}
}}


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