Discussions

Expand all | Collapse all

Move attachments from one table to another

  • 1.  Move attachments from one table to another

    Posted 02-21-2019 14:41
    I am working on an app that has multiple documents tables, (accounts documents, job documents, company documents). I am wanting to consolidate them into one documents table. How can you move attachments from one table to the next?


  • 2.  RE: Move attachments from one table to another

    Posted 02-21-2019 14:43
    There is not an easy way to do this.  How many documents are there?


  • 3.  RE: Move attachments from one table to another

    Posted 02-21-2019 14:46
    around 1200


  • 4.  RE: Move attachments from one table to another

    Posted 02-21-2019 14:50
    There are around 7000 documents in all the tables combined, but i need to move 1200 of them. Im wanting to move them to the table that currently has the most. 


  • 5.  RE: Move attachments from one table to another

    Posted 02-21-2019 14:58
    One option is to contract with Juiced Technologies for a 1 time project and maybe do them all, as most of their cost will be for the setup and not the actual processing.


  • 6.  RE: Move attachments from one table to another

    Posted 02-22-2019 00:42
    Thanks Mark!

    Apryl we do have a add-on that will move the files form 1 table to another.
    Demo app here:  https://juicedtech.quickbase.com/db/bmzi5qjk7

    This shows how we can move a single file from 1 table to the other but we can do this in bulk based on a report in the source table.

    As Mark mentioned yes we can do this one time, contact me if you are interested