Converting document attachment field to multiple field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have an existing document attachment field which obviously allows to attach only one file.  Now there is a need to have an option to attach multiple documents.  I can add one or more attachment fields but if somehow I could convert the exist field to multiple document option that would be great.  If this requires me to create a separate table and link to this table, then how to transfer existing files to the table.  Also, can an existing document table  be used which is attached to a different table?   
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
Can you tell me what the total size of the file attachments is on that table?  You can find that out by going to setting for the app, and then app management and then show app statistics.  I'm trying to see if the total size of all the file attachments for the whole app exceeds 75 MB.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks mark.  I have just started the app, so only a handful of files are there. If I had uploaded these, I could easily re load these but these were done by users.  It is currently 24 MB.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
If there are just a handful of files, then I suggest open them up one by one and dump them on your desktop or a folder and then when you make your child table, then manually reload them. 

But If there is less than 75 MB in the whole app (not just that table), then you can copy the app with file attachments. Then absorb that table into the same app.  That is something that you can do in App management.  (then discard the copied app).



Then delete all the fields on that absorbed table except the ones directly related to the file attachment, in fact it may be all fields to delete except that one file.  That table is now your file attachment table.  Make a copy of the field [record ID#]  and call it [Related Project]  (or whatever the Parent table will be.

Then make a relationship to the Parent table based on that field.


If there are like a couple of dozen file attachments, it will be quicker for you to do these manually, unless you just want to learn about "Absorbing" tables from one app to another.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks Mark.  Very kind of you to provide detailed response.  At this point, I have created one more field.  If things get out of hand, then I might just create a new table and be done with this.  Copying the app will be rather inappropriate as it is in production.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
... well its just that it gets hard and hard to move across the documents as more get added.

Copying an app is no big deal, just set the users to have no access on the copy of app.  Then absorb the table from the copied app to the production app.