0

Possible to duplicate table AND data?

I can duplicate a table. no prob. the problem is, I'm duplicating it because I want to create a new table with the data. (of course I could create all sorts of rules, but right now, I"m too new to this and just have to move forward with the project.)

I can export data. OK> so here's the problem...I'm on a Mac and have Numbers so numbers wants to automatically open the .csv. so then I lose the formating, the most important part, so when I import it, MANY of the fields are not available???

ANybody else find a workaround?

1 reply

null
    • Simon.1
    • 3 yrs ago
    • Reported - view

    First question is do you need to duplicate the data, or just add a link to it?
    If you do need to you can write a loop which you put in a button and add this code:

    for i in select 'Table you want to copy' do

    let a:= i.Field1

    let b:= i.Field2

    let c:= i.Field3

    let j:= create ’Table where you want the data to go’;

    j.Field1:=a

    j.Field2:=b

    j.Field3:=c

    end

    Alternatively, you can select all the data in Table view, and use copy and paste to paste into the new table.

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 1Replies
  • 479Views