Hi Chelsea/Jeff,
we have a file attachment sweep add-on that will do exactly what you are looking for. It can sweep the file from a record in one table and either update a record in another table or add a new record into the table. It will also either move into the other table or just copy it if you want it in 2 places.
You can demo it here:
https://juicedtech.quickbase.com/db/bmzi5qjk7When a new record is added, the sweep process can:
- Sweep the file and DELETE it from the record
- Sweep the file and KEEP the original file on the record
Additionally it can be scheduled to run daily/weekly/monthly to sweep records controlled by a Quick Base report.
Keith
