{"id":6,"date":"2015-09-24T04:07:00","date_gmt":"2015-09-24T09:07:00","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2015\/09\/data-edit-options-for-your-database\/"},"modified":"2015-10-26T10:06:46","modified_gmt":"2015-10-26T15:06:46","slug":"data-edit-options-for-your-database","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/","title":{"rendered":"Data editing options to improve productivity"},"content":{"rendered":"<p>While working with a web-based database you usually use edit forms to modify record values. The Edit form is an obvious and simple way to change your data, but it\u2019s not always flexible enough. For example, you may encounter difficulties if the form is too long, so it\u2019s hard to find a field you need. Moreover, while using an edit form you can\u2019t change multiple records at a time. Therefore we recommend some additional features that can streamline data editing process.<\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif\" alt=\"2,1\" width=\"400\" height=\"232\" class=\"alignnone size-full wp-image-240\" \/><\/a><\/p>\n<p><b>Edit on a record preview form<\/b><\/p>\n<p>The easiest way to edit fields in a record is modifying values directly on a View form. When you double-click on a value displayed on the <a href=\"http:\/\/www.teamdesk.net\/help\/7.aspx\">View form<\/a>, the field will be switched to the edit mode. As a result, you can modify only those fields you need at the current moment. Then you can save or discard these changes. Please notice that a preview form obeys to the adjusted <a href=\"http:\/\/www.teamdesk.net\/help\/7.2.aspx\">Form Behavior<\/a>. It means that only if a column is editable according to the form behavior settings, a user is allowed to edit that column. <\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/22.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/22.jpg\" alt=\"2,2\" width=\"500\" height=\"126\" class=\"alignnone size-full wp-image-242\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/22.jpg 500w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/22-300x76.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><b>Inline edit<\/b><\/p>\n<p><a href=\"http:\/\/www.teamdesk.net\/help\/5.8.aspx\">Inline Edit<\/a> feature allows making changes in multiple fields within a single record directly in a table view without using a record edit form. You can activate an Inline Edit feature in \u201ctable view\u201d settings. We recommend to apply this option to Details Views. For instance, if you need to add or change multiple invoice items related to an invoice, then an Inline Edit feature should be activated in the Related Items details view. <\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/23.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/23.jpg\" alt=\"2,3\" width=\"500\" height=\"317\" class=\"alignnone size-full wp-image-243\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/23.jpg 500w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/23-300x190.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>The feature also complies with the form behavior settings like the preview form.<\/p>\n<p><b>Custom buttons<\/b><\/p>\n<p><a href=\"http:\/\/www.teamdesk.net\/help\/11.1.aspx\">Custom buttons<\/a> is a useful tool for data editing. For example, a Preview page (or a Table view) button allows specifying which fields you may need to edit, so they can be displayed for updating. For example, if you need to change the Payments Info fields in a client profile, you should specify these fields in the Preview page button (or a Table view button) settings. Furthermore, you have to make sure that the Payment Info column\/columns are editable according to the adjusted form behavior.<\/p>\n<p>To update column values in multiple records, the Multi-record custom button could be helpful as it allows specifying records and modifying values in selected records at once. <\/p>\n<p><a href=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/24.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/24.jpg\" alt=\"2,4\" width=\"500\" height=\"114\" class=\"alignnone size-full wp-image-244\" srcset=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/24.jpg 500w, https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/24-300x68.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p>You may also add assignments to any custom button. Each assignment updates a specified column value when a custom button is pressed. For example, you manage customer orders. When an order is complete, you click on the \u201cComplete\u201d custom button and the Status column values are set to \u201cComplete\u201d for selected rows.<\/p>\n<p>Moreover, custom buttons can trigger actions such as \u201crecord update\u201d, \u201crecord create\u201d or \u201cemail alert\u201d. The action may include assignments. Depending on the action, you can edit record values, create new records or send email alerts.<\/p>\n<p>Using some of the above-mentioned features would make data-editing process handier. <a href=\"http:\/\/www.teamdesk.net\/help\/11.2.aspx\">Validation rules<\/a> always validate values prior to submission; therefore only records comprising valid data can be saved.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While working with a web-based database you usually use edit forms to modify record values. The Edit form is an obvious and simple way to change your data, but it\u2019s not always flexible enough. For example, you may encounter difficulties if the form is too long, so it\u2019s hard to find a field you need. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6","post","type-post","status-publish","format-standard","hentry","category-tips-tricks"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data editing options to improve productivity - TeamDesk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data editing options to improve productivity - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"While working with a web-based database you usually use edit forms to modify record values. The Edit form is an obvious and simple way to change your data, but it\u2019s not always flexible enough. For example, you may encounter difficulties if the form is too long, so it\u2019s hard to find a field you need. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-24T09:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-10-26T15:06:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif\" \/>\n<meta name=\"author\" content=\"Mila\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mila\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/\"},\"author\":{\"name\":\"Mila\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"headline\":\"Data editing options to improve productivity\",\"datePublished\":\"2015-09-24T09:07:00+00:00\",\"dateModified\":\"2015-10-26T15:06:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/\"},\"wordCount\":511,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/21.gif\",\"articleSection\":[\"Tips &amp; Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/\",\"name\":\"Data editing options to improve productivity - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/21.gif\",\"datePublished\":\"2015-09-24T09:07:00+00:00\",\"dateModified\":\"2015-10-26T15:06:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/21.gif\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/21.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-edit-options-for-your-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data editing options to improve productivity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\",\"name\":\"Mila\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"caption\":\"Mila\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/mila\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data editing options to improve productivity - TeamDesk Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/","og_locale":"en_US","og_type":"article","og_title":"Data editing options to improve productivity - TeamDesk Blog","og_description":"While working with a web-based database you usually use edit forms to modify record values. The Edit form is an obvious and simple way to change your data, but it\u2019s not always flexible enough. For example, you may encounter difficulties if the form is too long, so it\u2019s hard to find a field you need. [&hellip;]","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/","og_site_name":"TeamDesk Blog","article_published_time":"2015-09-24T09:07:00+00:00","article_modified_time":"2015-10-26T15:06:46+00:00","og_image":[{"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif","type":"","width":"","height":""}],"author":"Mila","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mila","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/"},"author":{"name":"Mila","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"headline":"Data editing options to improve productivity","datePublished":"2015-09-24T09:07:00+00:00","dateModified":"2015-10-26T15:06:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/"},"wordCount":511,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif","articleSection":["Tips &amp; Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/","name":"Data editing options to improve productivity - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif","datePublished":"2015-09-24T09:07:00+00:00","dateModified":"2015-10-26T15:06:46+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2015\/09\/21.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-edit-options-for-your-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Data editing options to improve productivity"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e","name":"Mila","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","caption":"Mila"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/mila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=6"}],"version-history":[{"count":2,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/6\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/6\/revisions\/245"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}