Index_S

S

Sales Report, sample forms, 322–323

sample forms, 4, 318–329

Absence Request, 318–319

Applicant Rating, 319

Asset Tracking, 319

Change Order, 319–320

customizing, 318

Expense Report, 320

form design and, 69

Invoice (Multiple Tax Rates & Single Tax Rate), 320

Issue Tracking (Simple & Detailed), 320–321

Meeting Agenda, 321

Performance Review, 321

Project Plan, 322

Purchase Order & Purchase Request, 322

Resume, 322

Sales Report, 322–323

Service Request, 323

Status Report, 323

Time Card (Simple & Detailed), 323–324

Travel Itinerary, 324

Travel Request, 324

Vendor Information, 324–325

viewing XML schema underlying, 325–329

Save As dialog box, 87

saving forms

blank forms, 87–88

in form libraries, 256–258

overview, 6, 56

prior to publishing, 238–240

Screen Tips, 117, 146, 199

Script Editor. See Microsoft Script Editor (MSE)

scripting, 214–228

alerts, 226–227

command buttons, 218

compared with expression boxes, 222

controlling flow of, 227

date fields, 223–224

debugger, 355

developers use of, 7–8

error catching, 227–228

events, 218–220

form fields, 220–223

InfoPath object model and, 216–218

Microsoft Script Editor for, 215–216

overview, 214–215

string manipulation, 225

trusted forms, 287–290

for validation, 208–211

scrolling, text, 123

SDK (Software Developers Kit)

downlevel tool in, 308

downloading, 286

RegForm utility, 284

resources in, 347–349

UI object, 226

secondary data sources, 230–234

sections, 138–157

nonrepeating, 142–146

optional, 55, 146–151

overview, 138–142

repeating, 54, 152–157

security. See trusted forms

Select Datasource dialog box, 97

selectNodes method, 222

send/receive options, web services, 106

Service Request, sample forms, 323

setup program

completing setup, 19–22

component selection, 16–19

running, 14–16

shading, 189–190

shared locations

publishing forms to, 304–305

publishing forms to shared folders, 244

troubleshooting publishing forms to, 354

SharePoint Portal Server

compared with SharePoint Services, 251

form libraries. see form libraries

opening forms from, 44–45

publishing forms to SharePoint form library, 245–246

publishing forms with, 8

SharePoint Services, 251

shortcuts, Windows Clipboard, 47, 76, 154

sizing

data entry controls, 115–116

nonrepeating sections, 145

Rich Text box objects, 125

text box objects, 123

sorting data, in form libraries, 262, 267–268

special characters, JScript, 343

spell checking, 47, 122–123

spreadsheets, Excel, 271–272

SQL (Structured Query Language), 102–104

SQL Server, 95–104

adding tables to, 100–102

data connection for, 97–100

as data source, 97

extracting database information with SQL statements, 102–104

overview, 30

Standard toolbar, 39–40

start tags, XML elements, 28

Status Report, sample forms, 323

string functions

JScript, 335–336

manipulating in scripts, 225

overview, 174–176

Structured Query Language (SQL), 102–104

style sheets

applying downlevel style sheet to XML file, 312

creating for form templates, 309

form views and, 312

updating when changing form template file, 313–314

Styles, applying to text, 48

Substring function, 175–176

Sum function, 172–173

summary operators, 265–266

switches, MSI files, 294

syntax, JScript, 332