Clay Icon

Feature Request: Streamline Data Transfer Between Tables

Β·
Β·

hey team a small feature rec -- It would be awesome to have something in between WriteTo Table + Share Template + Download & Import process. It's currently a pain or just takes long times to move a batch of data from Table 1 to Table 2 WHILE cloning all the columns (including it's setup)

  1. 1.

    share template

  2. 2.

    create table

  3. 3.

    Write to Table OR download & import if volume is high

While it's prob a small usage and not everyone needs it on daily basis but thought it's something really good to have if it's something quick to implment

  • Avatar of Daniela D.
    Daniela D.
    Β·
    Β·

    Hey Andideng! Thanks for reaching out. Just to confirm, the current process to move data from one tale to the other is too slow? Currently, your process involves: 1. Creat a share table link 2. Use that to create a duplicate 3. Run write to table or import via csv What would be your ideal setup for this workflow? We'll share that with the product team to evaluate.

  • Avatar of Andi D.
    Andi D.
    Β·
    Β·

    Thanks Daniella! To answer your question, yes! And of course it involves bunch clicks on filtering/matching in the process. By any means nothing crazy just tedious. Ideally, it would be great to add in something in between such as 1. Select rows or columns 2. Right click 3. Push. Done. This could be really helpful for small batch data movement inside of Clay

  • Avatar of Andi D.
    Andi D.
    Β·
    Β·

    Small batch inside of a large table that is

  • Avatar of Daniela D.
    Daniela D.
    Β·
    Β·

    Hey Andideng! Apologies for the delay. Thanks for sharing thisπŸ™πŸ½. To confirm, this would be multi-selecting rows/columns and click on one button to push all the data at once without needing to map each field + being able to multi-select for a small batch of records within a table and right-click to instantly push it to another table?

  • Avatar of Andi D.
    Andi D.
    Β·
    Β·

    Yes Daniela! Kinda like Google Sheet select and right click to copy & paste!

  • Avatar of Bo (.
    Bo (.
    Β·
    Β·

    – Thanks for this! Really appreciate your feedback, so I'm glad you took a moment to share it with us. I'm curious – could you let me know any specific use cases or workflows or challenges, where these updates would be especially helpful for you? I'll relay this to our product owners. Any additional context is welcome, so we can keep your situation in mind as we build out the roadmap.

  • Avatar of Andi D.
    Andi D.
    Β·
    Β·

    Hey Bo, for example, many of my tables contain thousands or even tens of thousands of records. While it's possible to use filtering or conditions to send small batches of tens or hundreds of records to a new table, it's just tedious to do so.

    1. 1.

      Copy template

    2. 2.

      Create table

    3. 3.

      Filter for desired data

    4. 4.

      Write to table

    5. 5.

      Match each desired field (this is probably the most annoying partβ€”I think a simple UI change might fix it, like an option to multi-select)

    6. 6.

      Run and wait for it to load

    If this were in Google Sheets, I could just drag my mouse or enter a formula to select the data, then copy and paste it into a new sheet within three seconds. Minor inconveniences here and there, but might something really easy to implement i guess?

  • Avatar of Anaum K.
    Anaum K.
    Β·
    Β·

    Thank you so much for the feedback! We're always looking to make the product better and this is super helpful for us. We're going to pass this over to our product team so they can better evaluate things and see if/where this might fit into the roadmap as a future improvement.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here.If you still need some help, just reply back here and someone from our team will be in touch!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hi Andi D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: