Developer Function

08.14.2024

## Overview As a low-code development tool, Pleisanter offers various add-on development methods such as "[API](https://pleasanter.org/en/manual/api)", "[Script](/en/manual/table-management-script)", "[Server Script](/en/manual/table-management-server-script)", and "「Extended SQL」". Screens can be created in a non-programming manner, and business logic can be implemented in code to shorten the construction period. ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-script">Table Management: Script</a>08.13.2024 up</li> <li><a href="/en/manual/table-management-server-script">Table Management: Server Script</a>08.13.2024 up</li></ul></article> <ul><li><a href="/en/manual/api">Developer Function: API</a>08.14.2024 up</li> <li><a href="/en/manual/api-key">Developer Function: API: Create an API Key</a>08.14.2024 up</li> <li><a href="/en/manual/api-record-get">Developer Function: API: Table Operation: Retrieve Single Record</a>08.14.2024 up</li> <li><a href="/en/manual/api-record-get-multi">Developer Function: API: Table Operation: Retrieve Multiple Records</a>08.14.2024 up</li> <li><a href="/en/manual/api-record-delete">Developer Function: API: Table Operation: Delete Record</a>08.14.2024 up</li> <li><a href="/en/manual/api-table-bulk-delete">Developer Function: API: Table Operation: Bulk Delete Record</a>08.14.2024 up</li> <li><a href="/en/manual/api-attachment-get">Developer Function: API: Table Operation: Retrieve Attachments</a>10.01.2024 up</li> <li><a href="/en/manual/api-export">Developer Function: API: Table Operation: Export Table</a>08.14.2024 up</li> <li><a href="/en/manual/api-import">Developer Function: API: Table Operation: Import Record</a>08.14.2024 up</li> <li><a href="/en/manual/api-group-import">Developer Function: API: Group Operation: Import</a>08.14.2024 up</li> <li><a href="/en/manual/api-group-create">Developer Function: API: Group Operation: Create Group</a>08.14.2024 up</li> <li><a href="/en/manual/api-group-delete">Developer Function: API: Group Operation: Delete Group</a>08.14.2024 up</li> <li><a href="/en/manual/api-group-get">Developer Function: API: Group Operation: Get Group</a>10.01.2024 up</li> <li><a href="/en/manual/api-site-copy">Developer Function: API: Site Operation: Copy Site</a>08.14.2024 up</li> <li><a href="/en/manual/api-site-create">Developer Function: API: Site Operation: Create Site</a>08.14.2024 up</li> <li><a href="/en/manual/api-site-get">Developer Function: API: Site Operation: Retrieve Site</a>08.14.2024 up</li> <li><a href="/en/manual/api-site-update">Developer Function: API: Site Operation: Update Site</a>08.14.2024 up</li> <li><a href="/en/manual/api-synchronize-summaries">Developer Function: API: Site Operation: Summary Sync</a>08.14.2024 up</li> <li><a href="/en/manual/api-rebuild-search-indexes">Developer Function: API: Site Operation: Search Index Rebuild</a>08.14.2024 up</li> <li><a href="/en/manual/api-mail">Developer Function: API: Email: Send Email</a>10.08.2024 up</li> <li><a href="/en/manual/api-user-import">Developer Function: API: User Operation: Import</a>08.14.2024 up</li> <li><a href="/en/manual/api-user-create">Developer Function: API: User Operation: Create User</a>08.14.2024 up</li> <li><a href="/en/manual/api-user-delete">Developer Function: API: User Operation: Delete User</a>08.14.2024 up</li> <li><a href="/en/manual/api-user-get-all">Developer Function: API: User Operation: Retrieve User (All)</a>08.14.2024 up</li> <li><a href="/en/manual/api-user-get">Developer Function: API: User Operation: Retrieve User (Select)</a>08.14.2024 up</li> <li><a href="/en/manual/api-user-update">Developer Function: API: User Operation: Update User</a>08.14.2024 up</li> <li><a href="/en/manual/api-dept-import">Developer Function: API: Department Operation: Import</a>08.14.2024 up</li> <li><a href="/en/manual/api-dept-get">Developer Function: API: Department Operation: Retrieve Department</a>08.14.2024 up</li> <li><a href="/en/manual/api-dept-create">Developer Function: API: Deparment Operation: Create Deparment</a>08.14.2024 up</li> <li><a href="/en/manual/api-dept-delete">Developer Function: API: Department Operation: Delete Department</a>10.01.2024 up</li> <li><a href="/en/manual/api-dept-update">Developer Function: API: Department Operation: Update Department</a>10.01.2024 up</li></ul></article> <ul><li><a href="/en/manual/script">Developer Function: Script</a>08.14.2024 up</li> <li><a href="/en/manual/script-action">Developer Function: Script: $p.action</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-create">Developer Function: Script: $p.apiCreate</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-delete">Developer Function: Script: $p.apiDelete</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-get">Developer Function: Script: $p.apiGet</a>10.04.2024 up</li> <li><a href="/en/manual/script-api-get-site">Developer Function: Script: $p.apiGetSite</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-groups-delete">Developer Function: Script: $p.apiGroupsDelete</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-groups-get">Developer Function: Script: $p.apiGroupsGet</a>10.04.2024 up</li> <li><a href="/en/manual/script-api-groups-update">Developer Function: Script: $p.apiGroupsUpdate</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-send-mail">Developer Function: Script: $p.apiSendMail</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-update">Developer Function: Script: $p.apiUpdate</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-update-site">Developer Function: Script: $p.apiUpdateSite</a>10.04.2024 up</li> <li><a href="/en/manual/script-api-upsert">Developer Function: Script: $p.apiUpsert</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-url">Developer Function: Script: $p.apiUrl</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-users-delete">Developer Function: Script: $p.apiUsersDelete</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-users-get">Developer Function: Script: $p.apiUsersGet</a>08.14.2024 up</li> <li><a href="/en/manual/script-api-users-update">Developer Function: Script: $p.apiUsersUpdate</a>10.04.2024 up</li> <li><a href="/en/manual/script-clear-message">Developer Function: Script: $p.clearMessage</a>08.14.2024 up</li> <li><a href="/en/manual/script-controller">Developer Function: Script: $p.controller</a>08.14.2024 up</li> <li><a href="/en/manual/script-dept-id">Developer Function: Script: $p.deptId</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-after-send">Developer Function: Script: $p.events.after_send</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-after-set">Developer Function: Script: $p.events.after_set</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-after-validate">Developer Function: Script: $p.events.after_validate</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-before-send">Developer Function: Script: $p.events.before_send</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-before-set">Developer Function: Script: $p.events.before_set</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-before-validate">Developer Function: Script: $p.events.before_validate</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-analy-load">Developer Function: Script: $p.events.on_analy_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-burndown-load">Developer Function: Script: $p.events.on_burndown_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-calendar-load">Developer Function: Script: $p.events.on_calendar_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-crosstab-load">Developer Function: Script: $p.events.on_crosstab_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-editor-load">Developer Function: Script: $p.events.on_editor_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-gantt-load">Developer Function: Script: $p.events.on_gantt_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-grid-load">Developer Function: Script: $p.events.on_grid_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-kamban-load">Developer Function: Script: $p.events.on_kanban_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-events-on-timeseries-load">Developer Function: Script: $p.events.on_timeseries_load</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-column-name">Developer Function: Script: $p.getColumnName</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-control">Developer Function: Script: $p.getControl</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-field">Developer Function: Script: $p.getField</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-grid-cell">Developer Function: Script: $p.getGridCell</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-column-index">Developer Function: Script: $p.getGridColumnIndex</a>08.14.2024 up</li> <li><a href="/en/manual/script-get-grid-row">Developer Function: Script: $p.getGridRow</a>08.14.2024 up</li> <li><a href="/en/manual/script-id">Developer Function: Scripts: $p.id</a>08.14.2024 up</li> <li><a href="/en/manual/script-login-id">Developer Function: Script: $p.loginId</a>08.14.2024 up</li> <li><a href="/en/manual/script-on">Developer Function: Script: $p.on</a>08.14.2024 up</li> <li><a href="/en/manual/script-responsive">Developer Function: Script: $p.responsive</a>08.14.2024 up</li> <li><a href="/en/manual/script-selected-ids">Developer Function: Script: $p.selectedIds</a>08.14.2024 up</li> <li><a href="/en/manual/script-set">Developer Function: Script: $p.set</a>08.14.2024 up</li> <li><a href="/en/manual/script-set-message">Developer Function: Script: $p.setMessage</a>08.14.2024 up</li> <li><a href="/en/manual/script-set-id">Developer Function: Script: $p.siteId</a>08.14.2024 up</li> <li><a href="/en/manual/script-table-name">Developer Function: Script: $p.tableName</a>08.14.2024 up</li> <li><a href="/en/manual/script-user-id">Developer Function: Script: $p.userId</a>08.14.2024 up</li> <li><a href="/en/manual/script-user-name">Developer Function: Script: $p.userName</a>08.14.2024 up</li></ul></article> <ul><li><a href="/en/manual/server-script">Developer Function: Server Script</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-debug">Developer Function: Server Script: Debug</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-conditions">Developer Function: Server Script: Condition</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-shared">Developer Function: Server Script: Share Code</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-include">Developer Function: Server Script: Include</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-context-add-message">Developer Function: Server Script: context.AddMessage</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-context-add-response">Developer Function: Server Script: context.AddResponse</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-context-error">Developer Function: Server Script: context.Error</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-context-forms">Developer Function: Server Script: context.Forms</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-context-query-strings">Developer Function: Server Script: context.QueryStrings</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-context-redirect">Developer Function: Server Script: context.Redirect</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-context-response-set">Developer Function: Server Script: context.ResponseSet</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-context-user-data">Developer Function: Server Script: context.UserData</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-site-settings">Developer Function: Server Script: siteSettings</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-site-settings-sections">Developer Function: Server Script: siteSettings.Sections</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-site-settings-site-id">Developer Function: Server Script: siteSettings.SiteId</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-view">Developer Function: Server Script: view</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-view-add-column-placeholder">Developer Function: Server Script: view.AddColumnPlaceholder</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-view-always-get-columns">Developer Function: Server Script: view.AlwaysGetColumns</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-view-clear-filters">Developer Function: Server Script: view.ClearFilters</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-view-filters">Developer Function: Server Script: view.Filters</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-view-filters-cleared">Developer Function: Server Script: view.FiltersCleared</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-view-id">Developer Function: Server Script: view.Id</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-view-search-types">Developer Function: Server Script: view.SearchTypes</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-grid">Developer Function: Server Script: grid</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-grid-selected-ids">Developer Function: Server Script: grid.SelectedIds</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-columns">Developer Function: Server Script: columns</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-columns-add-choice-hash">Developer Function: Server Script: columns.AddChoiceHash</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-columns-clear-choice-hash">Developer Function: Server Script: columns.ClearChoiceHash</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-elements">Developer Function: Server Script: elements</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-elements-display-type">Developer Function: Server Script: elements.DisplayType</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-elements-label-text">Developer Function: Server Script: elements.LabelText</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-utilities">Developer Function: Server Scripts: utilities</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-utilities-today">Developer Function: Server Script: utilities.Today</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-utilities-inrange">Developer Function: Server Script: utilities.InRange</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items">Developer Function: Server Scripts: items</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-items-average">Developer Function: Server Script: items.Average</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-bulk-delete">Developer Function: Server Script: items.BulkDelete</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-count">Developer Function: Server Script: items.Count</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-create">Developer Function: Server Script: items.Create</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-delete">Developer Function: Server Script: items.Delete</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-get">Developer Function: Server Script: items.Get</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-get-site">Developer Function: Server Script: items.GetSite</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-get-site-by-group-name">Developer Function: Server Script: items.GetSiteByGroupName</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-get-site-by-name">Developer Function: Server Script: items.GetSiteByName</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-get-site-by-title">Developer Function: Server Script: items.GetSiteByTitle</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-max">Developer Function: Server Script: items.Max</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-items-new">Developer Function: Server Scripts: items.New</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-items-new-result">Developer Function: Server Script: items.NewResult</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-items-update">Developer Function: Server Script: items.Update</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-api-model">Developer Function: Server Script: apiModel</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-api-model-create">Developer Function: Server Script: apiModel.Create</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-api-model-delete">Developer Function: Server Script: apiModel.Delete</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-api-model-update">Developer Function: Server Script: apiModel.Update</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-users">Developer Function: Server Script: users</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-user">Developer Function: Server Script: user</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-depts">Developer Function: Server Script: depts</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-dept">Developer Function: Server Script: dept</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-dept-get-members">Developer Function: Server Script: dept.GetMembers</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-groups">Developer Function: Server Script: groups</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-group">Developer Function: Server Script: group</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-group-get-members">Developer Function: Server Script: group.GetMembers</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-group-contains-dept">Developer Function: Server Script: group.ContainsDept</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-groups-update">Developer Function: Server Script: groups.Update</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-group-member">Developer Function: Server Script: groupMember</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-notifications">Developer Function: Server Script: notifications</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-notifications-get">Developer Function: Server Script: notifications.Get</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-notifications-new">Developer Function: Server Script: notifications.New</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-notification">Developer Function: Server Script: notification</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-notification-send">Developer Function: Server Script: notification.Send</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-hidden">Developer Function: Server Script: hidden</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-hidden-add">Developer Function: Server Script: hidden.Add</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-http-client">Developer Function: Server Script: httpClient</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-http-client-get">Developer Function: Server Script: httpClient.Get</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-http-client-post">Developer Function: Server Script: httpClient.Post</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-http-client-put">Developer Function: Server Script: httpClient.Put</a>10.04.2024 up</li> <li><a href="/en/manual/server-script-http-client-delete">Developer Function: Server Script: httpClient.Delete</a>08.14.2024 up</li> <li><a href="/en/manual/server-script-responses-reload">Developer Function: Server Script: responses.Reload</a>08.14.2024 up</li></ul></article> <ul><li><a href="/en/manual/extended-html">Developer Function: Extensions: Enhanced HTML</a>08.14.2024 up</li> <li><a href="/en/manual/extended-sql-api">Developer Function: Extensions: Extended SQL: Executing Extended SQL from the API</a>11.26.2024 up</li> <li><a href="/en/manual/extended-script">Developer Function: Extensions: Extended Script</a>08.14.2024 up</li> <li><a href="/en/manual/extended-style">Developer Function: Extensions: Extended Style</a>08.14.2024 up</li> <li><a href="/en/manual/extended-fields">Developer Function: Extensions: Extended Field</a>10.01.2024 up</li> <li><a href="/en/manual/extended-column">Developer Function: Extension: Extended Item</a>08.14.2024 up</li></ul></article> <ul><li><a href="/en/manual/api-item">Developer Function: JSON Data Layout: Item</a>08.14.2024 up</li> <li><a href="/en/manual/api-group">Developer Function: JSON Data Layout: Group</a>10.01.2024 up</li> <li><a href="/en/manual/api-user">Developer Function: JSON Data Layout: User</a>10.01.2024 up</li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />