Aurobinda Super Contributor.
Super Contributor.
137 views

Customize field type

Hi All,

We are on 9.32, there are certain fields where the fields must be restricted by the data type/validation. For example:, project title field should not contain double qoutes ("), URL fields should contain URLs, etc..

Would you please let us know, if there is any option to restrict.

0 Likes
2 Replies
silviocri Contributor.
Contributor.

Re: Customize field type

Hi,

I suggest a SQL request rule, triggered on field change or before save, doing a SQL replace to remove the not expected characters

Regards, Silvio

0 Likes
Aurobinda Super Contributor.
Super Contributor.

Re: Customize field type

Hi silviocri,

Thanks for you reply. We did try this. Considering the below scenario, we did not go ahead.

Once the proposal title is saved, then only the SQL rule can validate the name / title from backend. Considering the user changing the proposal name just before closing (after it's closed project will be created), in that case this will not be able to validate. We also thought of adding this condition, so that if it fails it should comeback to the previous step. But, if this is being validated from the begining while entering the proposal title itself and on every page load or field change from HP side, then we need not to handle this scenario externally.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.