[FYI] Removing HTML tags to data inputs using RICH text editor using JavaScript

[Wikiwi]

I found another solution in removing HTML tags in the data saved in Rich text editor. This is more if an alternative to this solution. Specially for those who doesn't have access to Triggered action.

1. First you would need another field in your table that will store the plain text version of the actual input.
2. Put that field in your Submission form and add a HEADER and FOOTER in your DataPage.
3. Go the the FOOTER of your DataPage and disable the HTML editor in the Advanced tab.
4. Paste the code below in your footer:

 

<script type="text/javascript">

//This will hide the field for the "plain" text
var non_formatted_txt = document.querySelector("#InsertRecordFIELDNAME_2");
non_formatted_txt.style.display = "none";

document.addEventListener('BeforeFormSubmit', function(event) {

//This will replace all the HTML tags with blank
var input = document.querySelector("#InsertRecordFIELDNAME_1").value.replace(/<\/?[^>]+(>|$)/g, "");

non_formatted_txt.value = input;
});
</script>

NOTE: replace FIELDNAME_2 with the actual fieldname of your field for the "plain" text and replace FIELDNAME_1 with the actual field name of the rich text editor field.

Sample input :

   

Actual table value:

Non formatted value:

 

 

[roattw]

This is great, thanks!  If you wanted to do this for 2 fields, would you just put a comma between the fieldname references?:

 

<script type="text/javascript">

//This will hide the field for the "plain" text
var non_formatted_txt = document.querySelector("#InsertRecordFIELDNAME1_html, InsertRecordFIELDNAME2_html");
non_formatted_txt.style.display = "none";

document.addEventListener('BeforeFormSubmit', function(event) {

//This will replace all the HTML tags with blank
var input = document.querySelector("#InsertRecordFIELDNAME1_text,InsertRecordFIELDNAME2_text").value.replace(/<\/?[^>]+(>|$)/g, "");

non_formatted_txt.value = input;
});
</script>

 

[PotatoMato]

Hi @roattw, you will need to use the queryselectorAll and have a separate "var" if you want to use 2 or more fields,

 

<script type="text/javascript">

// This will hide the fields for the "plain" text
var non_formatted_txt = document.querySelectorAll("#InsertRecordFIELDNAME1_html, #InsertRecordFIELDNAME2_html");

non_formatted_txt.forEach(function(element) {
  element.style.display = "none";
});

document.addEventListener('BeforeFormSubmit', function(event) {

  // This will replace all the HTML tags with blank for each field
  var input1 = document.querySelector("#InsertRecordFIELDNAME3_text").value.replace(/<\/?[^>]+(>|$)/g, "");
  var input2 = document.querySelector("#InsertRecordFIELDNAME4_text").value.replace(/<\/?[^>]+(>|$)/g, "");

  non_formatted_txt[0].value = input1;
  non_formatted_txt[1].value = input2;
});

</script>

 

-Potato