Copy pasting structured data faster

Need help
1

I have a google doc with a few hundred questions in the format below. Each question is on a separate page.

QUESTION:
Which of the following is NOT a type of economic activity?

OPTION 1:
Profession

OPTION 2:
Employment

OPTION 3:
Hobby 

OPTION 4:
Business

I have created an input form page in bubble to input this data into database. However, for every question I have to paste each item (QUESTION, OPTION 1, 2, 3, 4) in its respective input field in the form and then SAVE the data into the database and repeat this process for next question.

Please do note that there are other input fields on the form which I have to fill manually for each question.

Is it possible to do this repetitive and structured task faster?

One way I can think is have another input box in the form where I will paste one entire question every time and then have a workflow which will identify specific items and paste them into their respective input boxes and then I can save it into DB. However, I don’t know whether this is possible to do in Bubble.

Any help and advice would be appreciated?

2

I would try map this to a CSV where possible to speed things up.

You can have one CSV for Questions with options (1-4) and then another for other input types. [Just to make things easier]

Then just upload these using the CSV upload tool and run the appropriate workflows.

ChatGPT can help you convert the document into a CSV file in minutes.

3

Thanks for your reply. I have two Data Types Question and Answer and they reference each other. How can I handle that if I can upload only one CSV at a time.

4

Create a datatype called CSV_Record, then once you upload them all, run a workflow on all these records and set up the database correctly as you wish. (:

You can delete the records as you move through them or mark them as imported with a field.

5

Okay. This seems possible. Let me check it out.

1 Like
6

This topic was automatically closed after 70 days. New replies are no longer allowed.