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.

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 450Views