Skip to main content
New Idea

Ability to set input restrictions in different field types

Related products:CS Data Management & Integrations
  • June 23, 2022
  • 9 replies
  • 230 views

romihache
Forum|alt.badge.img+9

Hi! I would like to have a feature similar to the “data validation” one in Excel/Sheets, where you can choose beforehand either to reject the input completely or show a warning. 

I will explain with some use cases: 
 

  • An Id number that has to have 8 digits
  • A date field that can’t be set in the future
  • A string that follows this schema: a letter, 7 numbers, and another letter: X0000000X.

We can set controls afterwards, like rules and CTAs asking them to update it properly, but it would be much more efficient to avoid the problem altogether by avoiding human error.

Thank you,

 

9 replies

sarahmiracle
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • August 21, 2023

Great idea. I can think of so many ways we could use this!


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • October 5, 2023

I would need to also add:

  • “Field cannot contain” and then setting the list of strings it cannot contain, i.e. @gmail.com 

jordan_cook
Forum|alt.badge.img+3
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • January 30, 2024

Simply put, we would love to have “validation rules/logic” in place in Gainsight. This would allow admins to create a simple logic statement that either tests true or false. When applied to a field, it would enforce this logic, and require the input data to match before being allowed to save a record.

Salesforce had done a great job of creating this feature already


romihache
Forum|alt.badge.img+9
  • Author
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 2, 2025

I have another case to use as an example:
Users need to select a value from 1 to 5 via a “dropdown”. However, to enable real-time average calculations across multiple fields with this identical structure for display in C360 (using an advanced formula), the input cannot be a standard dropdown because the values are stored as strings, so the field is an integer.

There's no built-in mechanism to prevent user input errors


dayn.johnson
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 5, 2025

That feeling when you already voted.

However… new comment. Would love to have something that refused to accept strings in all caps.

Not a good look to say: “Hi BOB, hope you’re doing well.”

Similarly, to have something for strings that says “can’t all be lowercase.”


romihache
Forum|alt.badge.img+9
  • Author
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 5, 2025

That feeling when you already voted.

However… new comment. Would love to have something that refused to accept strings in all caps.

Not a good look to say: “Hi BOB, hope you’re doing well.”

Similarly, to have something for strings that says “can’t all be lowercase.”

100% yes! 
And sweet sweet tooltips (hopefully, auto-created from the field restrictions themselves and not by manually updating any C360 where those fields exist), to guide the end users. A gal/pal/person can dream, right? 


dayn.johnson
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 5, 2025

Ahhh, yes ​@romihache – tooltips and Gainsight user PX. 🙏

That’d be so, so nice.


alizee
Forum|alt.badge.img+13
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • May 12, 2025

Also: an integer field can only have values comprised between 0 and 5. 


revathimenon
Forum|alt.badge.img+8
  • Gainsight Community Manager
  • October 9, 2025
The following idea has been merged into this idea:

All the votes have been transferred into this idea.