<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Arial Narrow",sans-serif;
color:#1F497D;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello Mapbender Community,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I'm configuring a form in Mapbender Digitizer where I need to present additional information in a read-only format. Some fields are numeric IDs from one table that reference labels in another table. The 'type: text' option is not sufficient
for these because they lack the descriptive labels necessary for user understanding.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve used a 'type: select' field with an SQL statement to combine IDs and labels, but I need to ensure that these fields are non-editable. CSS properties (pointer-events: none, opacity: 0.5) were employed to make fields appear disabled,
but they can be easily overridden in a browser's developer mode. (Example: <span style="color:black">
<a href="https://ibb.co/mG2GdWg">https://ibb.co/mG2GdWg</a></span> - hier I als changed on CSS-Editor for aesthetic reasons: select { appearance: none; -webkit-appearance: none; -moz-appearance: none;} )<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(A) Is there an option similar to „mandatory: true“ but something like „editable: false“ for the types input, date, select, textArea and checkbox?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(B) Is there a way to execute an SQL statement in a 'type: text' field similarly to a 'type: select' field, to present the information securely in a non-editable manner?<o:p></o:p></p>
<p class="MsoNormal">Example of current use in a select field:<o:p></o:p></p>
<p class="MsoNormal">- type: select<o:p></o:p></p>
<p class="MsoNormal"> title: 'ID – Label (Table A) ' <o:p></o:p></p>
<p class="MsoNormal"> name: tableA_id<o:p></o:p></p>
<p class="MsoNormal"> connection: connectionName<o:p></o:p></p>
<p class="MsoNormal"> sql: 'SELECT id || '' - '' || label, id AS key from tableA order by id asc;'<o:p></o:p></p>
<p class="MsoNormal"> css: { pointer-events: none, opacity: 0.5 }<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">(C) Additionally, I've considered utilizing the onBeforeUpdate event to lock certain fields from being edited. Is there a way to enforce non-editability for specific fields in the backend upon update, to prevent changes even if the front-end
CSS is bypassed?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any insights or suggestions on how to securely implement this would be greatly appreciated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best,<o:p></o:p></p>
<p class="MsoNormal">Danilo de Lima<o:p></o:p></p>
</div>
<p style="margin:0;font-size:11px;font-family:'Arial Narrow', sans-serif;color:black;">
Datenschutzhinweis: Bitte beachten Sie die Information zur Verarbeitung personenbezogener Daten in E-Mail-Eingängen der Stadt Pulheim gemäß Art. 13 DS-GVO, abrufbar unter folgendem Link: <u><a href="https://www.pulheim.de/email-dsgvo" target="_blank" style="color: windowtext; font-size: 11px;font-family: 'Arial Narrow', sans-serif;">Datenverarbeitung
I E-Mail</a></u></p>
</body>
</html>