How to move one table with all the views to another base?

[Xing]

Hi, dear all talent folks,
I’m a new user on Airtable. I’ve been using this wonderful new invented app in the past weeks.

I recently found a question that literally I’m able to move one table with only one view to another base, simply using the cmd+c/cmd+v, but I’d have to adjust some filed, for instance, that the formula field cannot be pasted.

I’m wondering if there is any way that can realize these following functions;
1). Can I move one table to another base with all the review which depends on this table? For instance, I have a table A with 5 different views (2 Grid views, 1 Kanban, 1 Calendar, 1 Gallery).
2). Is there any way that I can copy/past all the field from what it is, for instance, the completed migration from the formula, the current way that I’ve told is impossible to move the entire filed, for instance, that the Formula will be auto-revised as a “short line text” field

I also tried export/import the table, also the same issue.

Please advice…
Thank you.

[Xing]

Hi, dear all talent folks,
I’m a new user on Airtable. I’ve been using this wonderful new invented app in the past weeks.

I recently found a question that literally I’m able to move one table with only one view to another base, simply using the cmd+c/cmd+v, but I’d have to adjust some filed, for instance, that the formula field cannot be pasted.

I’m wondering if there is any way that can realize these following functions;
1). Can I move one table to another base with all the review which depends on this table? For instance, I have a table A with 5 different views (2 Grid views, 1 Kanban, 1 Calendar, 1 Gallery).
2). Is there any way that I can copy/past all the field from what it is, for instance, the completed migration from the formula, the current way that I’ve told is impossible to move the entire filed, for instance that the Formula will be auto-revised as a “short line text” field

I also tried export/import the table, also the same issue.

Please advice…
Thank you.

[Elias_Gomez_Sai]

I think you can’t, all that work should be done manually: copy data (as you have done), and recreating Views and Filters.

Anyway, can you give us more context on your use case and the reasons to do that?

[Xing]

Hi Elias,
I edited my post, could you please have a look?

hi other folks, any advice helps. thanks

[M_k]

Hi Xing

I am not sure if this helps, but you can duplicate a base with views. You would open the base that you would like to duplicate, then select the name of the base at the top of the screen. A dialogue box opens, and near the bottom of the box, you can chose:

Duplicate base

It will open up two options:

Copy all records (this will also duplicate Views, too)

Create an empty base (this should create a base with the headers only)

Then it will ask you to:

Choose a workspace:

Example Bases (this is for personal use)

Or

New Team (I believe this is if you want other people to work on your base, but you have to pay)

Once you do this, check near the bottom of the page with all the templates and where all your bases are, and you should find the duplicated base there.

I noticed in the same dialogue box were you can duplicate a base, you can duplicate a table, but it only duplicates the table within the base. I don’t know if you could duplicate a table outside of a base. Maybe someone else can answer that question.

I also have found that this link can give you an overall view to how Airtable works:

Airtable - Support

Guide to the basic field types

Unlike a spreadsheet, Airtable fields (columns) have specific "types" that allow you to store rich content in each record. For example, a table can contain records (rows) with attachments...

These links might be helpful, too:

Airtable - Support

Let's make a base, Part 1: Tables, records, and fields

Now that you know a little bit about Airtable's capabilities, let's try making a base from scratch to fit a specific use case. Suppose you're the owner of a minor league sportsball franchise. Ticke...

Airtable - Support

Airtable for mobile: Fields overview

A field is the base equivalent of a spreadsheet column. Each field holds a particular category of information related to the record (row) in which it exists—for example, if you had records for each...

I hope this information will be helpful. If you need help, just repost that you need more help.

MK

[Xing]

hi dear @M_k, thank you.
but I’m still wondering how can I only remove one table from base A (have 8 tables) to base B. Not to duplicate the entire base, just migrating a table to another base.

[M_k]

Hi Xing

I managed to find a post addressing this issue in Airtable.

The actual ability to move a table is not yet available, it has been requested many times as a feature request, but there a work-around, to achieve the same result.

Here is a link to another post in Airtable to do this. It it post #2, but the rest of the post is interesting too:

Can you move a table to a different base? Ask the community

There’s no way to directly move a table to another base. But you can always copy a table to another base. There are a couple ways to do this. Export the table as a CSV, and then create new table in the target base via CSV upload Select the entire table (ctrl / cmd + A) and copy it (ctrl / cmd + C), then paste it (ctrl / cmd + V) into a new table in the target base In both instances, however, you will have to re-create the Field Types for certain types of fields, such as Formulas, Linked…

I hope this is helpful.

MK

P.S. Click on the blue link, halfway down the post, to get clearer instructions.

[Xing]

thanks for the reply, I tried the way you replied me, but it will potentially lose the formula, and titles, right?

[Jeremy_Oglesby]

Yes, you will lose formulas (not titles). There is no way to do this without losing formulas. You can always then go back and copy paste your formulas back into your new base.