I’m wondering what’s the easiest way to do some sort of data validation.
By linking another record from another table I can choose more than record which is an issue.
Worst, those columns don’t seem to appear in the database. I’m guessing it’s some kind of metadata.
Adding a foreign key in postgresql, does give me an error if I add a wrong value in nocodb but no UI around helping picking one.
Any suggestions ?
In general, I’m wondering what the main goal of nocodb? Matching the properties and relationships of the underlying database and exposing them to no-code methods or focusing on the web UI/APIs?
<@884788718894981192> Data validations currently rely on underlying datatype supported by database. Any specific validation that you are looking at?
Link to another record - Yes. Information is maintained in NocoDB metadata.
For PG error, please help us with more details. You can raise an issue here (Sign in to GitHub · GitHub)
About NocoDB- currently we are working to provide power & flexibility of database features in the hands of naive spreadsheet users & to make working with database/ api’s seamless for anyone on Internet, even without programming knowledge
very interesting I see, I’ve encountered quite a few PG errors, I’ll note them down and write an issue
ideally we’d like something similar to the single/multi-select button but instead of defining it within nocodb it would be based on another table
So in the case of typical client/order set of table, the user would be able to pick a client from the client table when adding an order. Except that it should show up in SQL query