Move attachments from one table to another

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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?
Photo of Apryl Stoldt

Apryl Stoldt

  • 292 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
There is not an easy way to do this.  How many documents are there?
Photo of Apryl Stoldt

Apryl Stoldt

  • 292 Points 250 badge 2x thumb
around 1200
Photo of Apryl Stoldt

Apryl Stoldt

  • 292 Points 250 badge 2x thumb
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. 
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.
Photo of Keith

Keith, Champion

  • 1,148 Points 1k badge 2x thumb
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