Disable break line in input widgets

Summary

Hello, as we all know, there are weird requirements from clients and sometimes, we need to make some research to take care of the issue. Well, I was working on a project where we were providing information to an external data base. In this project, we had forms with input widgets with more than 1 line:

The application was online, and was beeing used by multiple users so, they started noticing that some data inserted in those kind of inputs came with weird characters. Our team did some investigation and found that those situations happened when the users typed “enter”.

Solutions

1. Disable the “enter” typing;
2. Replace the “enter” character in the data base.

To disable the typing possibility in an input widget, we added this extended property.

From now on any user could type “enter” whenever he wants, and nothing will happen. After adding the extended property we needed to update the data base and replace the line break with a space. For this, we created a timer.

Firstly, we ran a query to find the line break:

WHERE   {CAR}.[Description] LIKE '%' + CHAR(13) + CHAR(10) + '%'

Secondly, we replaced the attribute with a space (yes, I literally typed an enter):

Replace(GetCars.List.Current.CAR.Description,"
"," ")

With this method, we were able to solve this issue.

More info:

During the research we found some usefull details:

Line feedchar (10), Carriage returnchar(13).

“If you want to generate a line break, it is a good practice to use CR and LF together. CHAR(13) + CHAR(10)”