Google forms has a native functionality where the user can upload multiple files into a single input field, however, AppSheet only recognize the single (first) file alone, which would cause the issue and reduce the flexibility to use this functionality. This “gab” must be adjusted by improving the functionality I would recomend.
When we use the Google Sheet/Forms add-on (AppSheet event) , the files loaded to the single fields would be returned as “array (list) of URL” to reach out to the files. Can you consider to do the same with this new function? Once we set Google form to allow only one file per File input field, it is fine and stay as we see now. However, the users set the Forms settings to allow the multiple files to single file field, then the table/column generated from the Form turns to be “Enulist” column instead of “File” type column, somthing like
DocId=xxxx , DocId=yyyy, DocId=zzzz
Once we get those list of id path, then we can easily manipulate the list onto the standalized data using AppSheet Loop Action technique.
Then we can stay with the Google Forms full functionality to allow user to upload the multiple files into the single field.
The new AppSheet/Google Form integration is posting new problems to us, i.e. the table is READ-ONLY. For some use cases it would be fine, but most of our use cases, the table must be editable. So our current workaround is to create new BOT and physical table. Once the new form is submitted, the bot is triggered and clone form data to other table by using Add new row to another table action. Then we keep using this cloned data for data manipulation and further app functionalties.
If we could the list (array) of the file path as I suggested, then we can chain Automation (Bot) to split the path to another table to store file path per row for that table.
This is what End users need. It is not a good idea to limit and placed a constrain to ask the user “you can upload only single file per field”