Forum Discussion

TroyBippert's avatar
TroyBippert
Qrew Trainee
6 years ago

Change multiple field type from text to file attachment?

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?
  • 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.
  • That option was not there at the time of creation.  Does it make a difference that I created from a CSV format?
  • Right. So since you cannot upload File Attachments by CSV, it makes sense. That it was not offered, so you are right.
  • 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?
  • 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.