Requests Sheet - Revision history

Prostagma: how to update lists

2024-04-01T00:14:37Z

how to update lists

← Older revision		Revision as of 01:14, 1 April 2024
Line 56:		Line 56:
	# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.		# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.
	[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]		[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]

			==Updating the Master Lists==

			# Download and open [https://sqlitebrowser.org/ DB Browser for SQLite].
			# Open an updated <code>flashpoint.sqlite</code> file (<code>File -> Open Database...</code>)
			# Open the <code>Execute SQL</code> tab and use the following: <pre>SELECT title, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(platformsStr, "; HTML5", ""), "Flash", "Flash Player"), "HTML5", "HTML5, WebGL, or WASM"), "Shockwave", "Shockwave Player"), "Java", "Java Applet"), "Unity", "Unity Web Player"), "Silverlight", "Microsoft Silverlight"), "ActiveX", "ActiveX (Internet Explorer only)"), "Authorware", "Authorware Web") AS platform FROM game WHERE library = "arcade" ORDER BY platform, title;</pre>Change <code>arcade</code> to <code>theatre</code> if you intend to update the Animation Master List instead.
			# Execute the command and save the view as a CSV file, or select all entries and copy it to your clipboard.
			# Paste its contents into the "Game/Animation Master List" sheet, starting from the '''A2''' cell. If a third empty column is created, you can simply remove it.

	<noinclude>		<noinclude>
	[[Category:Requests]]		[[Category:Requests]]
	</noinclude>		</noinclude>

Colin969 at 11:27, 6 September 2023

2023-09-06T11:27:35Z

← Older revision		Revision as of 12:27, 6 September 2023
Line 54:		Line 54:
	# Click <code>Format -> Conditional Formatting</code> in the menu. This will open the "Conditional format rules" sidebar on the right.		# Click <code>Format -> Conditional Formatting</code> in the menu. This will open the "Conditional format rules" sidebar on the right.
	# Click the formatting rule to edit it. Click the "Apply to range" field and delete the numbers from the end. In the example below, you would change the range from <code>F1:F10946</code> to <code>F1:F</code>.		# Click the formatting rule to edit it. Click the "Apply to range" field and delete the numbers from the end. In the example below, you would change the range from <code>F1:F10946</code> to <code>F1:F</code>.
	# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.~~test~~		# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.
	[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]		[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]

Colin969 at 11:27, 6 September 2023

2023-09-06T11:27:25Z

← Older revision		Revision as of 12:27, 6 September 2023
Line 54:		Line 54:
	# Click <code>Format -> Conditional Formatting</code> in the menu. This will open the "Conditional format rules" sidebar on the right.		# Click <code>Format -> Conditional Formatting</code> in the menu. This will open the "Conditional format rules" sidebar on the right.
	# Click the formatting rule to edit it. Click the "Apply to range" field and delete the numbers from the end. In the example below, you would change the range from <code>F1:F10946</code> to <code>F1:F</code>.		# Click the formatting rule to edit it. Click the "Apply to range" field and delete the numbers from the end. In the example below, you would change the range from <code>F1:F10946</code> to <code>F1:F</code>.
	# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.		# Click "Done" to save the rule. The range will be be automatically updated and the rule will be fixed.test
	[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]		[[File:ConditionalFormatting.png\|1000px\|alt=How to access the Conditional Formatting options on the Requests Sheet]]

	<noinclude>[[Category:Requests]]</noinclude>		<noinclude>
			[[Category:Requests]]
			</noinclude>

Nosamu: Updated Discord link

2023-07-26T09:48:11Z

Updated Discord link

← Older revision		Revision as of 10:48, 26 July 2023
Line 35:		Line 35:
	* If you see two requests for different games with the same name, make sure that the requests are not marked as duplicates. If they are not duplicates, click the cell under the Duplicate column of each request, type "No", and press Enter.		* If you see two requests for different games with the same name, make sure that the requests are not marked as duplicates. If they are not duplicates, click the cell under the Duplicate column of each request, type "No", and press Enter.

	If you're not sure whether a request is invalid or duplicate, please ask in the [~~http~~://discord.gg/~~S9uJ794~~ Flashpoint Discord server].		If you're not sure whether a request is invalid or duplicate, please ask in the [https://discord.gg/kY8r2BbPQ9 Flashpoint Discord server].

	==Using Filters==		==Using Filters==

Nosamu at 11:10, 17 October 2022

2022-10-17T11:10:57Z

← Older revision		Revision as of 12:10, 17 October 2022
Line 7:		Line 7:

	In order to mark requests as curated, you will need editing privileges on the sheet. [https://docs.google.com/forms/d/e/1FAIpQLSdyCD1rOHbipmBb9qtRXSZSBB7bOSUcIWnF2GzsHU4ahPDtgg/viewform Fill out the Access Request Form], and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask for someone in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. [https://docs.google.com/forms/d/e/1FAIpQLSdyCD1rOHbipmBb9qtRXSZSBB7bOSUcIWnF2GzsHU4ahPDtgg/viewform Fill out the Access Request Form], and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask for someone in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	~~[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]~~

	==Completing Requests==		==Completing Requests==

Dukktape: new form for requesting access

2022-10-10T01:58:33Z

new form for requesting access

← Older revision		Revision as of 02:58, 10 October 2022
Line 6:		Line 6:
	* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit		* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit

	In order to mark requests as curated, you will need editing privileges on the sheet. ~~Sign into your Google account and request access to~~ the ~~sheet~~, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask for someone in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. [https://docs.google.com/forms/d/e/1FAIpQLSdyCD1rOHbipmBb9qtRXSZSBB7bOSUcIWnF2GzsHU4ahPDtgg/viewform Fill out the Access Request Form], and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask for someone in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]		[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]

Nosamu at 19:36, 5 December 2021

2021-12-05T19:36:04Z

← Older revision		Revision as of 20:36, 5 December 2021
Line 6:		Line 6:
	* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit		* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit

	In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask for someone in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]		[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]

Nosamu at 19:35, 5 December 2021

2021-12-05T19:35:10Z

← Older revision		Revision as of 20:35, 5 December 2021
Line 6:		Line 6:
	* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit		* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit

	In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in <code>#Requests Sheet</code> (thread ~~from~~ <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in <code>#Requests Sheet</code> (thread in <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]		[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]

Nosamu at 19:34, 5 December 2021

2021-12-05T19:34:13Z

← Older revision		Revision as of 20:34, 5 December 2021
Line 6:		Line 6:
	* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit		* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit

	In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in #~~Requests_Sheet~~ (thread from #curator-lounge) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in <code>#Requests Sheet</code> (thread from <code>#curator-lounge</code>) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]		[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]

Prostagma: /* Accessing the Sheet */

2021-12-04T00:42:25Z

Accessing the Sheet

← Older revision		Revision as of 01:42, 4 December 2021
Line 6:		Line 6:
	* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit		* Animations: https://docs.google.com/spreadsheets/d/1EqBmxtNnNAupmGBoY35fy5ngEaZzPFIRuHJmNssA04s/edit

	In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask ~~a Curator~~ to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.		In order to mark requests as curated, you will need editing privileges on the sheet. Sign into your Google account and request access to the sheet, and if you've curated enough, you'll receive editing privileges within a few days. If you've curated 10 or fewer games, you should ask in #Requests_Sheet (thread from #curator-lounge) to mark the requests for you instead. Be sure to mention your Discord username when you request access to the sheet so we know who you are.

	[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]		[[File:RequestAccess.png\|alt=How to request access to the Game Requests sheet]]