How can I copy a table?

Hi Erica... I'm on the QuickBase Design team.  Can you say a little more about why you want to copy a table within the same app...what are you trying to accomplish?  Also what you would expect to be carried forward when it's copied:  table structure, data, forms, reports, emails?  This will help us in understanding the need and the usage for something like this.  Thanks in advance.

Is the only way is to copy the entire application then, move the table I want duplicated, then delete the copied application? This seems like to much.

Erica: You are correct assuming it is a multiple table application. You copy the application, expel the table then delete the remains of the copied application.

Thanks for your amswer. however I do not like the process to simply copy a table. I think Intuit should change this.

I agree ... it seems like a lot of work to just copy a table within the same application. Also, after I "copied" over my table, I lose all the email notificiations that I have set up and now have to manually go in and re-create. I also have to change some of the field types as they all default back to text boxes.  Any suggestions to make this process less time consuming?

Hi Gideon,

So the database that I created is a monthly tracker for the Journal Entries that are created by my team. The quickbase notifies our manager whenever a JE has been prepared, so that she can go in and approve them.  Once it's approved, a notification is sent out to each of the individual team members so that they can go and upload their JE into Oracle.  If our manager has a comment or wants us to change something, a separate notification is sent to the team member, who then goes and makes the appropriate changes.

I created the database for FY13 and a separate table is set up for each month. Currently, I've been copying one table and changing it so that it's update for the next month end.  What I want to do is find a faster and more convenient way to copy this table (eg. Jan FY13) and rename it to Feb FY13.  i want the new table to have everything in the Jan FY13 table (without any of the file attachements are the check marks in the checkboxes).

Erica... Is there a reason you don't just use a single table and add a date field ( or a FY field and a Month multi-choice text field).  You could then create reports based on FY and month to get just the records for that month and fiscal year without having to copy the table each month.

Gideon

Hello, we have different branches that need to fill in the same table with different information and access levels. It is pretty important to be able to copy tables within same applications.

I need another table with the same fields and then i will add one or two changes.  Would be nice not to have to create all the fields over again.

I have a generic table for all users. I need a specific table which has limited access, but the structure is the same - the data is different. Like Chrystal, it would be nice to copy the structure (even if I keep the data - I can delete that) and use in the same application.