How to move all data from "type" to "type"?

Need help
1

How to move data precisely like what the photo illustrates? Thank you

Note* I copied Type “Daily Report”, paste it and change the name to “Daily Report(old)”. The fields are all identical.

What I am trying to do: “Daily Report” is my primary data, and I want to remove old data away but keeping it in some storage. Therefore the system will not need to search and filter the enormous list of data.

Capture
Capture990×656 55.4 KB

2

You can use the action Data (Things) > Copy a list of things

3

Hello Louis,

Can you help me understand how it work? I manage to setup “copy a list of things” but how to paste?

4

After copying the list of things, assuming you want to create new records n the ‘old’ table, you can ‘Schedule API workflow on a list’ … on the list you just copied. You will need to be on a paid Bubble plan for this though.

1 Like
5

Your copy should be the one you use as primary. By copying the data type, you would not have copied data, so the new type has no records. Rename the original as Old.

6

Thanks Louis, I will give it a try!

7

Romanmg,

I am slightly confused by your suggestion :sweat_smile:
I presume you meant that I right click, copy the data type and paste it. Therefore I will not have the “data” in it?
But I do not understand the part where I have to rename the original as old.
Thanks a lot for your input as well!

8

Hey @ben.nes,

Whenever it comes to iterating over a list of things, for one reason or another, it’s always worth giving API Workflows a look. You can come up with a set of instructions that should occur for a given number of times, which should help you accomplish most goals like what you’re going for here. You can access API Workflows through your page selector, just make sure you enable API Workflows through Settings > API > This app exposes a Workflow API.

Here’s the general thought process behind bulk processing data:

  1. Create a new API Workflow
  2. Set a parameter that is of the type that you’re looking to iterate over
  3. Set all the actions that you’d like to complete in that workflow
  4. Go to the table matching the parameter you created in the Data tab
  5. Click on the Bulk button and select the new API Workflow you created

In your case, you’d probably want your parameter to be of the ‘Daily Report’ type, have an action in the API Workflow that ‘Creates a new thing’ of the ‘Daily Report (Old)’ type and have the things’ fields align. :slightly_smiling_face:

9

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