Jump to content
  • 0
Sign in to follow this  
joneslovescaspio

Copy contents of Column

Question

4 answers to this question

Recommended Posts

  • 0
Just now, joneslovescaspio said:

I need to copy the contents of one column in my table into another newly created column. It is on the same table. Is that possible?

Hello,

As of now, I don't think there's a standard feature that will let you to actually to this. However,  you can actually try and export this table (ideal if it is the same) and rename the column into your another newly created column and then re-import the data.

I hope this works.

Share this post


Link to post
Share on other sites
  • 0
Just now, OppaShinJoonYoung said:

Hello,

As of now, I don't think there's a standard feature that will let you to actually to this. However,  you can actually try and export this table (ideal if it is the same) and rename the column into your another newly created column and then re-import the data.

I hope this works.

That's a good idea. Thanks haha

Share this post


Link to post
Share on other sites
  • 0

Hi @joneslovescaspio,

I think you can do this using one of the newest function of Caspio, which is the TASK, it is similar to Triggered action but you can run this on demand.

When this task below is run/executed it will copy all the records of the' Value1_Table1' field in my 'New_table_1' table to my 'Vale2' field in my New_Table_2 Table.

image.thumb.png.e94279aaebd2a3405701bb858276b3f0.png

If you want to avoid copying the same records all over again, you will need to Join your two tables using their common field (foreign key). Then add a where clause to exclude records from table1 where its value was already copied/existing in your table 2.

For more details about TASK, you can check this Article

 

image.thumb.png.0292ba7beec5c2189e5ce7eaefaabd02.png

 

I hope this helps

Regards,

TsiBiRu

Share this post


Link to post
Share on other sites
  • 0

You can actually use a Formula Field to do that. Create a column and set the Data Type to formula. Then choose the field that you want to copy from the picker when editing the Formula. 

After that click on Save. This will allow you to copy the records from the other field. Change the data type of the Formula Field to Text(255)  then to the desired data type. 

image.png.9f30f286df9aa6d9d2c876b6124f1762.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...