Hello!
I need to add 1 to 5 or more files under one table. Currently I can only attach one file. Please advise if this is possible.
Thank you!
Adding Several Attached Files
Re: Adding Several Attached Files
Hi jnewtcomp,
you could (should!) create a 1:n relation in your application. This means create a new table which takes the primary key from your current table and another field which holds some uploaded file. This way you can have unlimited files per record.
You also might (I consider this bad database design) add five fields to your table and any of those is an upload field. This will limit the number of possible uploads to 5.
I have written for an application some additional php code which allows the admin to set the number of max uploaded files per record (database design: 1:n relationship). If the admin sets 5, the user can upload 5. Once there are five images and the user uploads a 6th, the oldest uploaded file will be removed, so that again only five files for this record exist. As in my case this is used for documentation the behavior is the one the customer expected. If the max number is changed this will trigger (or not) some more actions. Also, I do show the number in the footer of the details (and if you access the "Bilder" (images) page also in the header: (10 Bilder max. je Container)
and
Olaf
you could (should!) create a 1:n relation in your application. This means create a new table which takes the primary key from your current table and another field which holds some uploaded file. This way you can have unlimited files per record.
You also might (I consider this bad database design) add five fields to your table and any of those is an upload field. This will limit the number of possible uploads to 5.
I have written for an application some additional php code which allows the admin to set the number of max uploaded files per record (database design: 1:n relationship). If the admin sets 5, the user can upload 5. Once there are five images and the user uploads a 6th, the oldest uploaded file will be removed, so that again only five files for this record exist. As in my case this is used for documentation the behavior is the one the customer expected. If the max number is changed this will trigger (or not) some more actions. Also, I do show the number in the footer of the details (and if you access the "Bilder" (images) page also in the header: (10 Bilder max. je Container)
and
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view