- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 07:20 AM
We have a custom table that extends the Task table. We then have a Record Producer which maps inputs to the fields of the underlying custom table. Most of the fields are Variables mapped to Fields we created right in our custom table, but we are also mapping to the Description and Short Description fields found in the Task table.
For all of our custom table fields, we limited the entries on the Record Producer by entering in values like "max_length=200" in the Variable Attributes field of these Variables. That works fine for all of our Custom fields. However, it does not seem to apply to the Short Description field (and research indicated that it might not work against native fields in underlying base tables). OK, but if you look at the Short Description field in the underlying Task table, the size of that field is 200 characters! And when the user is filling out the field which is mapped to this Short Description field on my Record Producer, they can enter more than 200 characters!
How can I limit this entry field on my Record Producer so it does not exceed the maximum field size of 200 characters? I imagine I could probably create a Catalog Client Scripts to run after field entry, but that is an "after the fact" thing, and won't prevent them from initially trying to enter more than 200. I would love it to work like the other Variables, where it just doesn't allow you to type any more characters after the max limit. Is there any way to do this with these type of fields from the base tables?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 07:43 AM
Hello @jmiskey ,
This is the known issue, see the ServiceNow Support Article Below. And try business Rule as suggested it may resolve your issue. Or you can create Catalog client script on the record producer inself to restrict users from adding characters more than 200.
Kindly mark my answer as Correct and helpful based on the Impact.
Regards,
Siddhesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 07:43 AM
Hello @jmiskey ,
This is the known issue, see the ServiceNow Support Article Below. And try business Rule as suggested it may resolve your issue. Or you can create Catalog client script on the record producer inself to restrict users from adding characters more than 200.
Kindly mark my answer as Correct and helpful based on the Impact.
Regards,
Siddhesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 07:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 08:19 AM
Thanks. Yeah, that just seems to reinforce the workaround I mentioned in my original post (limit "after-the-fact" via Catalog Client Script). I was really looking for/hoping a preventative that doesn't allow them to enter any characters past the maximum size, like the "max_length" Variable Attribute does with the other Variables, but it appears that it may not be an option.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 08:25 AM - edited 12-15-2023 08:25 AM
Yes, as per my knowledge unfortunately I don't think there is a way to restrict character how we wanted