I am working on a project using bubble app. For this project, I am uploading CSV files. In each file, the headers are changing. Therefore, I want to implement dynamic headers. How could I fetch the headers dynamically?
In a SQL database like bubble’s, one way to set this up is to define a CSV as a list of Key - Values.
So I have 3 data types
Top level - CSV File (Where I store the actual CSV file and other information such as file name, number of rows etc
Mid Level - CSV Row, where I store each CSV row in the file (ignore some of the AI fields, this was for an app I have developed)
Bottom Level - CSV Key Values (Where I store all the CSV Keys and Values that belong to a row)
Let me know if this makes sense. Setting the database up like this means you can store CSV’s with dynamic headers
Connect with me: