®
Overlay #01
Processing...
AppForms for Sharepoint
AppForms Enterprise Edition
Cloud Appforms for Office 365
Pricing
Start Building
Solutions
show / hide menu
Overview
What’s new
Getting Started
System Requirements
Install ClaySys AppForms
ClaySys AppForms Enterprise Version Installation Guide
ClaySys AppForms SharePoint Installation Guide
Add ClaySys App in office365
Begin with AppForms
Create new tenant in Enterprise version
Create a basic AppForm
Add rules in AppForms
Edit Rules in AppForms
Add trigger in rules
Rules Debugger
Rules Picker
Changing the properties of the form and controls using properties window
Basic Controls in ClaySys AppForms
Default Triggers
How to Launch AppForms Designer in Enterprise Edition
Rules Expression Builder
Launch AppForms Designer in SharePoint
Add AppForm to web part in SharePoint
Import/Export in SharePoint
Managing List Forms in SharePoint
Create List Form in SharePoint
AppForms Explorer
AppForms Explorer – An Overview
Forms Explorer
Creating a New Folder
Creating a New Form
Session Variables
Application Setting Variables
Global Variables
Global Rules
AppForms Designer
AppForms Designer Basics
Toolbox
DataSources Panel
Properties Window
Rules Panel
Property Popup
Undo & Redo
Reports
Rules Expression Builder
Rules Debugger
Controls
Standard Controls
AutoComplete Textbox
Button
CheckBox
CheckBox Group
ComboBox
DateTimePicker
FileUpload
HyperLink
Image
Image Button
Label
Listbox
MultiListBox
PasswordBox
RadioButton
RadioButton Group
TextBox
Timer
Captcha
Rich Text Box
People Picker
Data Controls
Dynamic Grid
Dynamic Grid – Row Split
Search Grid
MS SQL DataSource
SharePoint DataSource
Web Service DataSource
Search Control
Lookup Control
Lookup with MS SQL DataSource
Lookup with SharePoint DataSource
Validation Controls
Captcha Control
Group Controls
Tab Control
Tab Control – Accord View
External Form
External Form Control
Repeater
RepeaterGetFormName
RepeaterQuickAction
Properties
Border Control
SubForm Control
Hidden Control
Functions
Alerts
MessageBox
Clear Operations
Clear
ClearHiddenControls
ClearItems
ClearVisibleControls
Collection Controls
AddItems
MoveDown
MoveUp
RemoveItems
Cryptography
Encrypt
Decrypt
DataSource Functions
ExecuteAction
ExecuteCommand
FillData
FillDataSync
QueryString
Date Functions
AddDays
DateDiff
GetDateFormat
GetDay
GetMonth
GetYear
SystemDate
GetHour, GetMinutes, GetMeridiem
Event Operations
AddError
Excel Operations
ExportToExcel
ExternalForm Operations
Repeater
RepeaterEnableQuickAction
RepeaterGetFormName
RepeaterQuickAction
FileUpload Operations
GetFileName
SetFileName
AppendFile
Form Functions
Clear
InvokeClickAction
RunRule
SetBusy
SetFocus
GetProperty
SetProperty
FormReset
FormUnload
LoadForm
SetFormValue
Session
ClearSession
CloseTab
ClosePopup
QueryString
SetChartType
ExecuteExternalFormLoadRule
SetFormControl
Generic Functions
AppSettings
GetProperty
GUID
InvokeClickAction
IsNull
NullValue
RemoveError
RuleBreak
RuleExit
RunRule
SetBusy
SetFocus
SetProperty
ShowSpellChecker
Grid Operation
GridGetValue
GridRowAdd
GridRowDelete
GridColumnSorting
GridSetColumnHeader
GridSetColVisible
GridSetValue
GridSetCellStyle
GridMax
GridMin
GridRowDetailsGetValues
GridRowDetailsSetStyle
GridRowDetailsSetValues
GridsetRowMode
GridSetRowStyle
GridCopy
List Operations
Trigger Workflow
Math Functions
Abs
Acos
Asin
Atan
Avg
Between
Ceil
Cos
Cosh
Exp
Floor
Max
Min
Log
Log10
Rad
Sin
Sinh
Sqrt
sum
Tan
Tanh
Round
Mail Operations
SendEmail
SendEmailAdvanced in SharePoint
Example of SendEmailAdvanced in SharePoint
SaveAsPDF
Send Email ( Advanced with Example ) in SharePoint
Pop-Up
ClosePopup
Print Operations
PrintPage
String Operations
Contains
FormatNumeric
StringLength
StringReplace
SubString
StringToUpper
StringToLower
IN
StringToCapitalizedWord
StringToSentenceCase
Trim
TrimEnd
TrimStart
IsNull
NullValue
Script Operations
ExecuteJavaScript
InvokeJavaScript
Security Operations
GetListItemPermission
GetListPermission
Session Operations
ClearSession
Session
Site Operations
GetSiteDetails
Statistical Operations
GetCount
Max
Min
SetChartType
Tab operations
CloseTab
RenameTab
Time operations
TimeDiff
UserProfile Variables
Validation Functions
RemoveError
Validation Operations
IsValidUser
ValidateMe
Me.IsValid
Variables
GlobalVariable
Session
Web Address
InvokeWebRequest
OpenUrl
DataSources
DataSource Settings
SharePoint
Aggregate Functions in SharePoint
External SharePoint
MS SQL
MS SQL – Stored Procedure
WebServices
Working With WebService
Collection Controls
Static Data
MS SQL Table/View
MS SQL – Stored Procedure
SharePoint List/Library
External SharePoint List/Library
Dynamic Grid control
Dynamic Grid configuration with SQL database
Aggregate functions
Cut or copy paste Rule items
Security Module
User Management
Initiate AD Sync
Backup/Restore
Download Form
Upload Form
Export Tenant Backup
Import Tenant Backup
Configuration Examples
UserProfile SharePoint WebService
Using JavaScript in AppForms
Send Email functionality
Search Control Join
Using Border Control Theme
Using Regular Expressions
Form with Dynamic Height
Using GUID function
Employee Absence Tracking
Creating Required Tables
Creating the form
Designing the form
Form Properties
Employee Information
Current Year Leave Information
Absence Request Dates
Configure DataSource
Select User Details In Form Load
Select Restricted Date
Configure the Dynamic Grids
Vacation Days Requested
Sick Leave Days Requested
Personal Leave Days Requested
Adding Rules
Validate Vacation date
Validate Sick Leave date
Validate Personal Leave Date
Employee Absence Tracking(single)
Employee Absence Tracking(Single)-configuration with SharePoint List
Form Validation
Example of SendEmailAdvanced in SharePoint
Different Selected Value for PeoplePicker
GridGetFileName and GridSetFileName
Configuration of MetaData Control in SharePoint
Features
Dynamic Grid complex column view
File upload control DownloadFilestream property
How to create a repeating section?
Second Example
Find And Replace option in Search Control
GetControlId function
How to manage Navigation in ClaySys AppForms
Search.Action Function
How to Navigate in ClaySys AppForms using executeJavaScript function
People Picker User Validation inside a Dynamic Grid Control
GridGetFileName and GridSetFileName
GetFormValue
ImageURL Property of the Image Button Control
AppForms Scheduler
Application Monitor
Application Setting Variables
Transaction Log
Mobile version for Enterprise edition
Un-install ClaySys AppForm
Upgrade ClaySys AppForm
Rollback Upgrade ClaySys AppForms:
Working with ComboBox
Activation For Web Application
Image Control & Image Button
Create a new Web Service Data source
Custom Error Description
Maintenance Mode
Page Navigation for Table view control
URL Encode and Decode
Application Setting Variable and Session Variable
Restful Data-Source to support header
Upload Files to Document Library from Dynamic Grid using file Upload control in SharePoint
Document Library in SharePoint
Dynamic grid with RESTful Web-Service
Restful Data-source to support Json format
DataSource Settings
DataSource Settings Navigation
The link to manage DataSource Settings is available in the left navigation.
Select the option ‘DataSource Settings’ under the group ‘Data management’ and click.
Figure 1