Change multiple field type from text to file attachment?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have multiple field types that need to be changed from text to file attachment.  When I created the table I did not have the option for file attachment, after the table is created, then file attachment shows up as an option.  How can I change multiple field types at once?
Photo of Troy Bippert

Troy Bippert

  • 110 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
It does not make sense that you could not have created file attachment fields types when you first created the fields.  That option must have been there at the time.

At this point you will need to change the field types one by one for each field or delete them and make then as new fields.
Photo of Troy Bippert

Troy Bippert

  • 110 Points 100 badge 2x thumb
That option was not there at the time of creation.  Does it make a difference that I created from a CSV format?
Photo of Troy Bippert

Troy Bippert

  • 110 Points 100 badge 2x thumb

Right. So since you cannot upload File Attachments by CSV, it makes sense. That it was not offered, so you are right.
Photo of Troy Bippert

Troy Bippert

  • 110 Points 100 badge 2x thumb
Of the 193 fields that I have, about 80% of them need to be file attachment.  Is there a faster way to create the table and set the fields as file attachment, faster than individually setting each field after creation?
I don’t know much about the purpose of your App but can I ask why you feel the need to have 100+ file attachment fields?

Perhaps what you really need is a child table where you can add separate records for these different file attachments.

There are add on tools available to allow the multi file upload from a computer or upload multiple pictures from my phone all in one click. Would that serve your purpose?
If you still feel the need for all those file attachment fields, I see that there is an API

https://help.quickbase.com/api-guide/...
Photo of Troy Bippert

Troy Bippert

  • 110 Points 100 badge 2x thumb
I am utilizing the mobile app to create a record of a completed project and upload pictures from the location to provide proof of completion.  Then output the completed form as a report to send to the customer.
Man o man. I would install the military file upload from Juiced It works well off of a phone yo upload multiple pics in a multi select mode.

https://www.juicedtech.com/file-attac...
Sorry. I meant to say multi file upload.