Sandboxcalsync - Revision history

Bcoope14 at 22:13, 25 July 2025

2025-07-25T22:13:46Z

← Older revision		Revision as of 22:13, 25 July 2025
Line 1:		Line 1:
			{{#get_web_data:
			url=https://docs.google.com/spreadsheets/u/0/d/1J_mrE18Kf_mbcbYFDThwqnmtgfK5OLwFF4T-U0BpTgM/gviz/tq?tqx=out:csv&gid=1076536326
			\|format=CSV with header
			\|data=Date=Date, Start=Start Time, End=End Time, Employee=Employee, Skills=Skills
			}}

	== Sandbox MOD Schedule ==		== Sandbox MOD Schedule ==
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
Line 5:		Line 11:
	{{!}}-		{{!}}-
	{{!}} {{{Date}}}		{{!}} {{{Date}}}
	{{!}} {{{Start ~~Time~~}}}		{{!}} {{{Start}}}
	{{!}} {{{End ~~Time~~}}}		{{!}} {{{End}}}
	{{!}} {{{Employee}}}		{{!}} {{{Employee}}}
	{{!}} {{{Skills}}}		{{!}} {{{Skills}}}
	}}		}}
	\|}		\|}
	~~<!-- Fetch schedule CSV from Google Sheets -->~~
	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/u/0/d/1J_mrE18Kf_mbcbYFDThwqnmtgfK5OLwFF4T-U0BpTgM/gviz/tq?tqx=out:csv&gid=1076536326~~
	~~\|format=CSV with header~~
	~~\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills~~
	}}

Bcoope14: /* Sandbox MOD Schedule */

2025-07-25T22:12:18Z

Sandbox MOD Schedule

← Older revision		Revision as of 22:12, 25 July 2025
Line 1:		Line 1:
	== Sandbox MOD Schedule ==		== Sandbox MOD Schedule ==

	{\| class="wikitable sortable"		{\| class="wikitable sortable"
	! Date !! Start Time !! End Time !! Employee !! Skills		! Date !! Start Time !! End Time !! Employee !! Skills
Line 12:		Line 11:
	}}		}}
	\|}		\|}
			<!-- Fetch schedule CSV from Google Sheets -->
	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/~~2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ~~/~~pub~~?gid=1076536326~~&output=csv~~		url=https://docs.google.com/spreadsheets/u/0/d/1J_mrE18Kf_mbcbYFDThwqnmtgfK5OLwFF4T-U0BpTgM/gviz/tq?tqx=out:csv&gid=1076536326
	\|format=CSV with header		\|format=CSV with header
	\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills		\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
	}}		}}

Bcoope14: /* Sandbox MOD Schedule */

2025-07-25T22:09:18Z

Sandbox MOD Schedule

← Older revision		Revision as of 22:09, 25 July 2025
Line 14:		Line 14:

	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/u/2/~~d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94~~-~~hlRNhZdkDiVG0~~/~~gviz/tq~~?~~tqx=out:csv&~~gid=1076536326&tq=~~select%20A%2CB%2CC%2CD%2CE~~		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&output=csv
	\|format=CSV with header		\|format=CSV with header
	\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills		\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
	}}		}}

Bcoope14 at 22:08, 25 July 2025

2025-07-25T22:08:17Z

← Older revision		Revision as of 22:08, 25 July 2025
Line 1:		Line 1:
	==~~{{#external_value:StudioName}}~~==		== Sandbox MOD Schedule ==
	~~==={{#external_value:Room}}===~~
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
	! ~~Material~~		! Date !! Start Time !! End Time !! Employee !! Skills
	! ~~SDS Doc~~		{{#for_external_table:<nowiki/>
	! ~~SDS Link~~
	~~! Tool~~ {{#for_external_table:<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{~~SDSName~~}}}		{{!}} {{{Date}}}
	{{!}} [{{{~~SDS Doc~~}}} ~~(view local copy) ]~~		{{!}} {{{Start Time}}}
	{{!}} [{{{~~SDS Link~~}}} ~~(weblink to SDS)]~~		{{!}} {{{End Time}}}
	{{!}} {{{~~ToolName~~}}}		{{!}} {{{Employee}}}
			{{!}} {{{Skills}}}
	}}		}}
	\|}		\|}
	~~<!-- Crafts and Sewing -->~~
	{{#get_web_data:		{{#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~~		url=https://docs.google.com/spreadsheets/u/2/d/1PxEME2nnUvaZ1qj2ZEh5xxFyDBi94-hlRNhZdkDiVG0/gviz/tq?tqx=out:csv&gid=1076536326&tq=select%20A%2CB%2CC%2CD%2CE
	\|format=CSV with header		\|format=CSV with header
	\|data=~~StudioName~~=~~Studio~~, ~~ToolName~~=~~Tool~~, ~~SDSName~~=~~SDSName~~, ~~SDS Link~~=~~SDSLink~~, ~~SDS Doc~~=~~SDSGoogleDoc, Room=Room~~		\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
	}}		}}

Bcoope14 at 22:07, 25 July 2025

2025-07-25T22:07:54Z

@@ Line 1: / Line 1: @@
 {{#get_web_data:
-  url=https://upload.wikimedia.org/wikipedia/commons/3/3c/Test_external_data.csv
+  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=Item=Item, Quantity=Quantity
+  |data=StudioName=Studio, ToolName=Tool, SDSName=SDSName, SDS Link=SDSLink, SDS Doc=SDSGoogleDoc, Room=Room
 }}

Bcoope14 at 22:07, 25 July 2025

2025-07-25T22:07:08Z

@@ Line 1: / Line 1: @@
-== Sandbox MOD Schedule ==
+{{#get_web_data:
-{| class="wikitable sortable"
+ url=https://upload.wikimedia.org/wikipedia/commons/3/3c/Test_external_data.csv
-! Date !! Start Time !! End Time !! Employee !! Skills
+ |format=CSV with header
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} {{{Date}}}
+{{!}} {{{Item}}}
-{{!}} {{{Start Time}}}
+{{!}} {{{Quantity}}}
 }}
 |}

Bcoope14 at 22:06, 25 July 2025

2025-07-25T22:06:29Z

← Older revision		Revision as of 22:06, 25 July 2025
Line 11:		Line 11:
	}}		}}
	\|}		\|}



	{{#get_web_data:		{{#get_web_data:
Line 17:		Line 19:
	\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills		\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
	}}		}}

			== Diagnostic: Raw Value Check ==
			* Date: {{{Date}}}
			* Start Time: {{{Start Time}}}
			* Employee: {{{Employee}}}

Bcoope14 at 22:05, 25 July 2025

2025-07-25T22:05:29Z

← Older revision		Revision as of 22:05, 25 July 2025
Line 1:		Line 1:

	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	== Sandbox MOD Schedule ==		== Sandbox MOD Schedule ==
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
Line 19:		Line 12:
	\|}		\|}

	~~<!-- Data Source -->~~
	{{#get_web_data:		{{#get_web_data:
	url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv		url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv

Bcoope14: /* Sandbox MOD Schedule */

2025-07-25T22:02:29Z

Sandbox MOD Schedule

← Older revision		Revision as of 22:02, 25 July 2025
Line 9:		Line 9:
	{\| class="wikitable sortable"		{\| class="wikitable sortable"
	! Date !! Start Time !! End Time !! Employee !! Skills		! Date !! Start Time !! End Time !! Employee !! Skills
	{{#for_external_table:		{{#for_external_table:<nowiki/>
	\|<tr>		{{!}}-
	~~<td>~~{{{Date}}}~~</td>~~		{{!}} {{{Date}}}
	~~<td>~~{{{Start Time}}}~~</td>~~		{{!}} {{{Start Time}}}
	~~<td>~~{{{End Time}}}~~</td>~~		{{!}} {{{End Time}}}
	~~<td>~~{{{Employee}}}~~</td>~~		{{!}} {{{Employee}}}
	~~<td>~~{{{Skills}}}~~</td>~~		{{!}} {{{Skills}}}
	~~</tr>~~
	}}		}}
	\|}		\|}

			<!-- Data Source -->
			{{#get_web_data:
			url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv
			\|format=CSV with header
			\|data=Date=Date, Start Time=Start Time, End Time=End Time, Employee=Employee, Skills=Skills
			}}

Gfc at 22:00, 25 July 2025

2025-07-25T22:00:29Z

← Older revision		Revision as of 22:00, 25 July 2025
Line 1:		Line 1:
	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	~~{{#get_web_data:~~
	~~url=https://docs.google.com/spreadsheets/d/e/2PACX-1vSIM1yBnpvkC5F-lLHbxjagSJ6zcUbFXdwdCzG86PlNzKkCZF6ynj0L7PPuvZQRZsAvikJXFlNVBOZJ/pub?gid=1076536326&single=true&output=csv~~
	~~\|format=CSV~~
	~~\|data=Date,Start Time,End Time,Employee,Skills~~
	}}

	{{#get_web_data:		{{#get_web_data: