{"id":11684,"date":"2019-03-15T19:15:34","date_gmt":"2019-03-15T19:15:34","guid":{"rendered":"https:\/\/www.directimpactsolutions.com\/?p=11684"},"modified":"2023-05-18T18:44:54","modified_gmt":"2023-05-18T18:44:54","slug":"non-editable-text-selection-for-field-data-in-filemaker","status":"publish","type":"post","link":"https:\/\/www.directimpactsolutions.com\/en\/non-editable-text-selection-for-field-data-in-filemaker\/","title":{"rendered":"Non-Editable Text Selection for field data in FileMaker"},"content":{"rendered":"<h3 class=\"wp-block-heading\">How to protect field data from being edited, while still allowing the fields to be selected for copy \/ paste functionality.<\/h3><p>One of the features that makes FileMaker so easy to use for field data entry is that there\u2019s typically very low friction between the user and the data. Specifically, fields on a FileMaker layout are usually just open and ready for editing. This makes it simple to just dive in and fill field data, but the flip side of this low-friction environment is that critical data can sometimes be edited by mistake. As soon as the\u00a0<a href=\"https:\/\/directimpactsolutions.com\/en\/record-locking-you-cannot-use-this-record-until-filemaker-user-is-finished\">user moves off the record<\/a>\u00a0to \u201ccommit\u201d the changes, your data is changed permanently.<\/p><p>FileMaker offers several methods to protect field data from being edited; The most common (and simple) is just unchecking the option for field entry in Browse Mode in the inspector:<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker.png\" alt=\"non-editable text selection for field data in FileMaker\" class=\"wp-image-11704\" width=\"400\" height=\"256\"\/><\/figure><p>Another common method is through the use of merge text on a layout. A third popular method to protect field data from being edited on a layout is by using a\u00a0<a href=\"https:\/\/directimpactsolutions.com\/en\/invisible-formatting-for-button-bars\">calculated button bar segment<\/a>. This works very well, and has the added benefit of enabling you to dynamically change and format the field data.<\/p><p>But what if you want to select the data, copy it, and paste it elsewhere, but still protect it from being edited? This a familiar problem \u2014 users want to copy an entire address block, or an email address, or whatever, and paste it into an email or a document, but are unable to select the text.<\/p><p>There are three ways of making field data selectable, but not editable:<\/p><ol class=\"wp-block-list\"><li>Create a privilege set to prevent editing of the data<\/li>\n\n<li>Create a calculated field that displays the data<\/li>\n\n<li>Use HTML-formatted data in a webviewer to display the data<\/li><\/ol><h3 class=\"wp-block-heading\">Privileges<\/h3><p>If you set up a privilege set in FileMaker\u2019s \u201cmanage security\u201d settings, and then apply it to user accounts, you can effectively prevent users from editing field data under various circumstances. If, for example, you were to create a calculation (at the field level) that says a field data can only be edited when a \u201cLocked\u201d boolean field is unchecked, then the user can select that field on a layout, but will be unable to edit the data unless that boolean field has been unchecked. The advantage here is that you can control the editing of data by user privileges, and so some users may be able to edit, while others may not. The downside is that it can become complicated to edit the user privileges at the field level, particularly if you have a large number of fields to deal with.<\/p><h3 class=\"wp-block-heading\">Calculation Fields<\/h3><p>Setting up specific fields to replicate the data in editable fields will enable you to place any number of these fields on a layout and allow them to be selected without any ability to edit the data. Period. It\u2019s easy to set up (you just take a field called \u201cName\u201d, for example, and create a new calculation field called \u201ccName\u201d that simply calculates the \u201cName\u201d field), and it requires no special privilege setups. However, the downside here is that you have to add new fields to your system. For just a few, this may be fine, but it\u2019s not necessarily practical to duplicate many fields as calculated fields, just to allow for\u00a0copying and pasting. On the other hand, you can do things like calculate an entire address block including spaces, carriage returns, and formatting all in a single calculation field and display that:<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_2.png\" alt=\"\" class=\"wp-image-11706\" width=\"495\" height=\"368\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_2.png 554w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_2-300x223.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure><p>The above calculations display a nice, neat, formatted name and address block:<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_3.png\" alt=\"\" class=\"wp-image-11708\" width=\"262\" height=\"152\"\/><\/figure><h3 class=\"wp-block-heading\">HTML in a Webviewer<\/h3><p>This method works quite nicely, although it requires some knowledge of and comfort with coding HTML. It involves using HTML inside of a <a href=\"https:\/\/fmhelp.filemaker.com\/help\/16\/fmp\/en\/index.html#page\/FMP_Help\/web-viewers.html\" target=\"_blank\" rel=\"noreferrer noopener\">webviewer<\/a> to display data from fields, formatted as needed. Instead of putting some fields on a layout to display address data, you instead put a webviewer in that block, formatted to show the data as a small web page:<\/p><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"433\" height=\"345\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_4.png\" alt=\"\" class=\"wp-image-11710\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_4.png 433w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_4-300x239.png 300w\" sizes=\"auto, (max-width: 433px) 100vw, 433px\" \/><\/figure><p>If you\u2019re comfortable building HTML pages, then this is a good way to go, although&nbsp;<a href=\"https:\/\/directimpactsolutions.com\/en\/displaying-filemaker-data-in-web-viewers\/\">data in webviewers can load more slowly than native FileMaker<\/a>&nbsp;layouts. There are also some formatting settings that need to be adjusted for a Webviewer object so that it seamlessly matches your layout. Specifically, you\u2019ll want to turn off the progress bar and status messages, plus you may want to remove any fill colors and outlines from the object style.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_5.png\" alt=\"\" class=\"wp-image-11712\" width=\"426\" height=\"145\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_5.png 405w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-in-FileMaker_5-300x102.png 300w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/><\/figure><p>As with any development platform, there are many ways to \u201cskin a cat\u201d, but sometimes it may be difficult to figure out which way is the right way. Hopefully, you\u2019ve gained some new \u201ccat-skinning\u201d tricks from this!<\/p><p>Please don\u2019t actually skin a cat. It\u2019s just a figure of speech.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\" style=\"margin-top:var(--wp--preset--spacing--70);margin-bottom:var(--wp--preset--spacing--70)\"\/><p class=\"has-small-font-size\"><em>*This article was originally written for AppWorks, which has since joined Direct Impact Solutions. This article is intended for informative purposes only. To the best of our knowledge, this information is accurate as of the date of publication.<\/em><\/p>","protected":false},"excerpt":{"rendered":"<p>How to protect field data from being edited, while still allowing the fields to be selected for copy \/ paste functionality. One of the features that makes FileMaker so easy to use for field data entry is that there\u2019s typically very low friction between the user and the data. Specifically, fields on a FileMaker layout &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.directimpactsolutions.com\/en\/non-editable-text-selection-for-field-data-in-filemaker\/\"> <span class=\"screen-reader-text\">Non-Editable Text Selection for field data in FileMaker<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":23,"featured_media":11806,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","footnotes":""},"categories":[29],"tags":[39],"class_list":["post-11684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-low-code","tag-filemaker"],"uagb_featured_image_src":{"full":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection.jpg",1732,1491,false],"thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-150x150.jpg",150,150,true],"medium":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-300x258.jpg",300,258,true],"medium_large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-768x661.jpg",768,661,true],"large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-1024x882.jpg",1024,882,true],"1536x1536":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-1536x1322.jpg",1536,1322,true],"2048x2048":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection.jpg",1732,1491,false],"woocommerce_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-600x517.jpg",600,517,true],"woocommerce_gallery_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/Non-Editable-Text-Selection-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"David Weiner","author_link":"https:\/\/www.directimpactsolutions.com\/en\/author\/david-weiner\/"},"uagb_comment_info":0,"uagb_excerpt":"How to protect field data from being edited, while still allowing the fields to be selected for copy \/ paste functionality. One of the features that makes FileMaker so easy to use for field data entry is that there\u2019s typically very low friction between the user and the data. Specifically, fields on a FileMaker layout&hellip;","_links":{"self":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/comments?post=11684"}],"version-history":[{"count":6,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11684\/revisions"}],"predecessor-version":[{"id":21022,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/11684\/revisions\/21022"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media\/11806"}],"wp:attachment":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media?parent=11684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/categories?post=11684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/tags?post=11684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}