Hi everyone,
I’m currently working on a project in Bubble (Free Plan) where we are building a small MRP-like system. At the moment, we are stuck on implementing a CSV import with proper validation (Day 7 of our project plan).
The problem:
We are using the CSV Uploader plugin, but it only reads the file and converts rows into text. It does not validate the data. Because of this, invalid data is being treated as valid.
What we need to validate:
-
Required fields (e.g., empty values should trigger errors)
-
Allowed values (e.g.,
tipo_itemmust be one of: SKU, MATERIAL, COMPONENTE, RETORNABLE) -
Values that must exist in the database (e.g., related records like company or items)
Example issue:
If the CSV contains:
nombre,tipo_item
Producto1,SKU
Producto2,TIPORARO
“TIPORARO” should be flagged as an error, but currently it is not.
Constraint:
We are on the Free Plan, so we cannot use backend workflows to process each row.
What we’ve considered so far:
-
Frontend validation using Repeating Groups (but may not scale well)
-
Using Javascript via Toolbox plugin + Papa Parse
-
Using Airtable as an external validation layer
-
Someone suggested Algolia, but we are unsure if it applies to this use case
Our questions:
-
What is the best approach to validate CSV data in Bubble without backend workflows?
-
Is using Javascript (Toolbox + Papa Parse) the most reliable solution?
-
Has anyone successfully implemented a validation system like this on the Free Plan?
-
Would you recommend using an external tool like Airtable, or keeping everything inside Bubble?
Any guidance, examples, or best practices would be greatly appreciated ![]()
Thanks in advance!
