Field validation

Technical Help
1

Does baserow provide a way to set validations for fields? Can I make the single text field reject certain content?

2

Not at the moment, but I could see how this would be valuable. I have an idea of how it’d work in my mind, but can you describe your use case (preferably with multiple field types) to make sure we’re aligned?

We’d have to take into consideration validation for various field types, not just single line text, for example.

Once we do that, we can create an issue on GitLab and then get it on the roadmap. :motorway:

3

This issue does exist already actually, take a look and ensure it describes your use case accurately (and if not, feel free to comment on GitLab as well): Field value constraints (#647) · Issues · Bram Wiepjes / baserow · GitLab

4

This will be helpful for many scenarios . Here is some examples that I can think of

  1. Contact management: When managing contact information in Baserow, field validation can help ensure that phone numbers, email addresses, and postal codes are entered correctly and consistently. This can help prevent errors when trying to reach out to clients or customers.
  2. Inventory management: When managing inventory data in Baserow, field validation can help ensure that product codes, SKU numbers, and other identifying information is entered accurately. This can help prevent mistakes when tracking inventory levels, fulfilling orders, or managing returns.
  3. Financial tracking: When using Baserow to track financial data such as expenses, revenue, and budget information, field validation can help ensure that data is entered correctly and consistently. This can help prevent errors when making financial decisions or reporting financial information to stakeholders.
  4. Project management: When managing project data in Baserow, field validation can help ensure that data such as task names, deadlines, and budgets are entered correctly and consistently. This can help prevent errors when tracking progress, assigning tasks, or reporting project updates to stakeholders.
  5. Event management: When managing event data in Baserow, field validation can help ensure that dates, times, and locations are entered correctly and consistently. This can help prevent errors when scheduling events, sending invitations, or managing logistics.

Also, if we can have conditional fields that work based on existing field validations applied to other existing fields, that would be even more fantastic

here are some scenarios where that will be helpful

  1. Address management: When managing address information in Baserow, applying a condition on another field based on the validation of one field can help ensure that the data entered is accurate and consistent. For example, if a field is validated to accept only valid postal codes for a specific country, a condition can be applied to ensure that the related field for the city and state/province is also populated based on the selected postal code.
  2. Product management: When managing product information in Baserow, applying a condition on another field based on the validation of one field can help ensure that the data entered is accurate and consistent. For example, if a field is validated to accept only a specific category of products, a condition can be applied to ensure that the related field for the manufacturer or supplier is also restricted to only those that provide that specific category of products.
  3. Order management: When managing order information in Baserow, applying a condition on another field based on the validation of one field can help ensure that the data entered is accurate and consistent. For example, if a field is validated to accept only valid credit card numbers, a condition can be applied to ensure that the related field for the expiration date is also validated to ensure that it is in the correct format.
  4. Employee management: When managing employee information in Baserow, applying a condition on another field based on the validation of one field can help ensure that the data entered is accurate and consistent. For example, if a field is validated to accept only valid employee IDs, a condition can be applied to ensure that the related field for the employee’s name and department is also populated based on the selected employee ID.
  5. Event management: When managing event information in Baserow, applying a condition on another field based on the validation of one field can help ensure that the data entered is accurate and consistent. For example, if a field is validated to accept only valid dates, a condition can be applied to ensure that the related field for the start and end times of the event is also validated to ensure that they are in the correct format.

Hope that helps

3 Likes
5

Sounds great Hiram. I’m glad that we’re going in a great direction

1 Like