Google Drive Spreadsheet Data Xpages

<?xml version="1.0" encoding="UTF-8"?>
<xp:view xmlns:xp="http://www.ibm.com/xsp/core" pageTitle="Bulletin Posting Page"
	xmlns:xc="http://www.ibm.com/xsp/custom" style="background-color:rgb(234,253,239)">


	<xp:this.resources>
		<xp:script src="/docucontentGACodeTest.js" clientSide="true" />
	</xp:this.resources>


	<xp:this.navigationRules>
		<xp:navigationRule outcome="xsp-success" viewId="/xpgoogleworksheetsubs.xsp" />

		<xp:navigationRule outcome="xsp-failure" viewId="/xpnotauthorized.xsp" />

	</xp:this.navigationRules>

	<xp:tabbedPanel id="tabbedPanel1">
		<xp:tabPanel label="Insert Record" id="tabPanel1">
			<xp:panel
				style="width:682.0px;text-align:center;font-size:18pt;height:349.0px">
				<p style="text-align:center;font-size:19pt">
					<xp:div style="text-align:center;font-size:20pt">
						<xp:div style="text-align:center;font-size:21pt">
							<b style="font-size:22pt">
								<xp:div style="text-align:left;font-size:23pt">
									<xp:div style="text-align:center;font-size:24pt">
										<xp:table align="left"
											style="background-color:rgb(208,242,225);width:100.0%;font-size:9pt">
											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt">

													<xp:div style="font-weight:bold;font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:label value="Subject FullName:" id="subject_Label1"
																for="subject1"
																style="text-align:left;font-weight:bold;width:172.0px;font-size:12pt" />

														</xp:div>
													</xp:div>
												</xp:td>
												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">


															<xp:inputText value="#{SendGoogleRecordJavaBean.subjectFirst}"
																id="inputText3" style="font-size:9pt" />
															&#160;
															<xp:inputText value="#{SendGoogleRecordJavaBean.subjectLast}"
																id="inputText4" style="font-size:9pt" />

															<xp:inputText value="#{SendGoogleRecordJavaBean.userID}"
																id="inputText5" style="font-size:9pt;width:131.0px"
																rendered="true" defaultValue="#{SendGoogleRecordJavaBean.userNameValue}"
																disabled="true" />
														</xp:div>
													</xp:div>

												</xp:td>
											</xp:tr>
											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt">
													<xp:div style="font-weight:bold;font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:label value="Categories:" id="categories_Label1"
																for="categories1" style="font-weight:bold;font-size:12pt" />

														</xp:div>
													</xp:div>

												</xp:td>
												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">

															<xp:comboBox id="comboBox1"
																value="#{SendBulletinBean.categories}" style="font-size:9pt">
																<xp:selectItem itemLabel="Select Option"
																	itemValue="" />

																<xp:selectItem itemLabel="Client Dashboards"
																	itemValue="Client Dashboards" />
																<xp:selectItem itemLabel="Misc Dashboards"
																	itemValue="Misc Dashboards" />

																<xp:selectItem itemLabel="Resources Dashboards"
																	itemValue="Resources Dashboards" />

																<xp:selectItem itemLabel="Samples Dashboards"
																	itemValue="Samples Dashboards" />

																<xp:selectItem itemLabel="Web Dashboards"
																	itemValue="Web Dashboards" />

															</xp:comboBox>
														</xp:div>
													</xp:div>

												</xp:td>
											</xp:tr>
											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt">
													<xp:div style="font-weight:bold;font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:label value="Body:" id="body_Label1" for="body1"
																style="font-weight:bold;font-size:12pt" />

														</xp:div>
													</xp:div>
													<xp:div style="font-size:12pt" />

												</xp:td>
												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:inputTextarea value="#{SendBulletinBean.body}"
																id="body1" style="height:128.0px;width:519.0px;font-size:9pt" />


														</xp:div>
													</xp:div>



												</xp:td>


											</xp:tr>

											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt">

													<xp:div style="font-weight:bold;font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:label value="Age:" id="label3" for="subject1"
																style="text-align:left;font-weight:bold;width:172.0px;font-size:12pt"/>

														</xp:div>
													</xp:div>
												</xp:td>
												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">



															<xp:inputText value="#{SendGoogleRecordJavaBean.subjectAge}"
																id="inputText1" style="font-size:9pt" />
															&#160;

														</xp:div>
													</xp:div>

												</xp:td>
											</xp:tr>
											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt">
													<xp:div style="font-weight:bold;font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:label value="Height:" id="label4" for="categories1"
																style="font-weight:bold;font-size:12pt"/>

														</xp:div>
													</xp:div>

												</xp:td>
												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">


															<xp:inputText value="#{SendGoogleRecordJavaBean.subjectHeight}"
																id="inputText2" style="font-size:9pt" />
															&#160;

														</xp:div>
													</xp:div>

												</xp:td>
											</xp:tr>




											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt" />

												<xp:td style="margin-left:-24px;font-size:11pt">


													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:messages layout="table"
																style="color:red;font-size:14pt" id="messages1" />

														</xp:div>
													</xp:div>
												</xp:td>
											</xp:tr>
											<xp:tr style="font-size:10pt">
												<xp:td style="font-size:11pt" />

												<xp:td style="margin-left:-24px;font-size:11pt">
													<xp:div style="font-size:12pt">
														<xp:div style="font-size:13pt">
															<xp:button value="Submit" id="button1" style="font-size:9pt">
																<xp:eventHandler event="onclick" submit="true"
																	refreshMode="complete" immediate="false" save="true"
																	id="eventHandler1">

																	<xp:this.action><![CDATA[#{javascript:SendGoogleRecordJavaBean.submitEntry()}]]></xp:this.action>
																</xp:eventHandler>
															</xp:button>
															&#160;

														</xp:div>
													</xp:div>
												</xp:td>
											</xp:tr>
										</xp:table>
										<xp:span style="font-size:20pt;font-weight:bold" />

										<xp:span style="font-size:20pt" />

									</xp:div>
									<xp:div style="text-align:center;font-style:italic;font-size:24pt">

										<xp:span style="font-weight:bold;font-style:italic;font-size:17pt" />

									</xp:div>
								</xp:div>
							</b>
						</xp:div>
					</xp:div>

				</p>
			</xp:panel>
		</xp:tabPanel>
	</xp:tabbedPanel>
	<xp:div style="text-align:center" />
	<xp:span style="font-size:20pt;font-weight:bold">
		<xp:span style="font-weight:bold;font-style:italic;font-size:17pt" />
		<xp:span style="font-size:20pt" />
	</xp:span>
	<xp:div style="text-align:center;font-style:italic;font-size:16pt">
		<div id="content" style="text-align:center;font-size:17pt" />


		<div id="footer" style="font-size:17pt" />





	</xp:div>
</xp:view>





Copy and Paste this XSnippet in your software, with JAR configuration in place, and connect to Google Spreadsheet, and insert row(s) to current Worksheets...  Take a look the video tutorials for support.

 <!--CREATE GOOGLE API DOCS: Dököll Solutions, Inc.-->
 <managed-bean>
   <managed-bean-name>SendGoogleRecordJavaBean</managed-bean-name>
   <managed-bean-class>com.dokoll.solutions.inc.google.dev.SendGoogleRecordJavaBean
</managed-bean-class>
   <managed-bean-scope>session</managed-bean-scope>
 </managed-bean>

YouTube Tutorials:
http://www.youtube.com/watch?v=2TtnqJMNnXg&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=7U1HP5yEhI8&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=CTnUOLcOfgI&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=GCPsQwv7xVo&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=Rh0DJ8KHWzw&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=hemoGCIygZA&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=kGEPoylMIwA&list=UUSImDTpK0oe7QrPsYOE4nww
http://www.youtube.com/watch?v=uL2RDbKZyMs&list=UUSImDTpK0oe7QrPsYOE4nww

XPages
Köll S Cherizard
May 24, 2014 2:03 AM
Rating
7

All code submitted to OpenNTF XSnippets, whether submitted as a "Snippet" or in the body of a Comment, is provided under the Apache License Version 2.0. See Terms of Use for full details.



No comments yetLogin first to comment...