Skip to main content
romihache
VIP ⭐️⭐️⭐️⭐️⭐️
June 23, 2022
New Idea

Ability to set input restrictions in different field types

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

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
VIP ⭐️⭐️⭐️⭐️⭐️
August 21, 2023

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

Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member
alizee
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 
The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
jordan_cook
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
romihacheAuthor
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

Continuous improvement is better than delayed perfection
dayn.johnson
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.”

Staff CS Content & Comms Manager, 2x Gainsight CS Ops Product Council Member
romihache
romihacheAuthor
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? 

Continuous improvement is better than delayed perfection
dayn.johnson
VIP ⭐️⭐️⭐️⭐️⭐️
May 5, 2025

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

That’d be so, so nice.

Staff CS Content & Comms Manager, 2x Gainsight CS Ops Product Council Member
alizee
VIP ⭐️⭐️⭐️⭐️⭐️
May 12, 2025

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

The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
revathimenon
Gainsight Community Lead
October 9, 2025
The following idea has been merged into this idea:

All the votes have been transferred into this idea.
Where focus goes, energy flows.