The ability to setup validation rules for any property in a collection so that only valid data can be saved. Validation options could include minimum and maximum values, particular formats, etc.
+1 for being able to specify that numeric fields should be positive integers
Key for me as I drive a fair bit of functionality off correctly entered user data. Stuff you mentioned inc the ability to set max and min off magic data and that max is always > min.
Originally posted by: fela.hughes@buengo.com
Character maximums and file size limits would be two great ones.
Please also consider a validation for “uniqueness” of something being saved. For context, my use case is people in my app can create a Group. However, right now there is no way to ensure that the name attribute on the Group is unique.
Essentially if we could apply standard filters and formatting/length filters to acceptable form content, that would allow us to validate the data.
Car number only works on TEXT field, needed also on NUMBER field format : i.e year 1984 …as of now one cannot resctrict years “Y” to be between X and Y values along with a warning mesage…
One alternative to building in data validation into the system is allow us to create customized data validation by allowing app designers to trigger an action when “focus” is taken off of an input or dropdown select field.
This action would involve opening a modal to alert the user that their data is not valid for the reason specified by the app designer. The input field would be changed back to empty or the default value.
The key here is that a new set of actions could be added alongside click actions. These would be “unfocus actions” which are triggered whenever a component is taken out of focus, such as when something else (including the background) is clicked.
This would also include the trigger when someone stops typing into a field, such as a search bar.
Regex for validation would be great. For “nocoders”: Regular expression - Wikipedia
karimoo: If the data is sent to Airtable, and then a new output from a formula field is retrieved, that could allow us to do it.
Unfortunately due to the lack of validation I can’t pursue building my app with Adalo, I love your service, but it simple won’t work for me without validation. I need to validate a number of a ship, which has to be unique, to make sure ships aren’t added twice in my database. Really sad when I found out there wasn’t a way to prevent this from happening at the moment
This would make development so much easier!!!
I need verification of Half-angle English numbers.
Currently, if you use lowerCase, you can input Japanese.
The following URL may be of help
100%. I was quite surprised this wasn’t possible without being forced into showing modals or similar.
I was attempting to do date validation (i.e. is the date before today, is the user over 18 etc) and it’s just a pain.
Regex would do at a worse case scenario
100%, please Adalo team consider this, how on earth an application cannot validate easily input data?!
Absolutely must! It’s very important for internal tools and data quality control.