Runway Form uploaded file appears in directory on server but not in assets in ad...

Hi Drew Ok, good, thought I'd made a mistake somewhere in set up. UGC?

On reflection I can see it might be best for form uploaded files to not be available as assets. Intention is for CV upload.

I guess then I need to build a webpage that checks user is logged in as admin and lists files in the bucket directory?

Or is there a more elegant way of allowing access to these files. I do intend, once on live server, to have this bucket outside web root of course.

Is there a way of hiding unused buckets in Assets to avoid user adding files that way? I need to remove an unused bucket too, how can I achieve that? Thanks Keith

Do you mean in the responses listing in Forms admin? If so, no, there are no associated uploaded files shown with submission listings. The file appears in the directory with random number prefixed to name as you'd expect though.

Hi Drew No although I can see the files in the directory there is no link available with the stored responses.

I also don't see all the form output - text, textarea and select all there but radio and checkbox not?

Debug from response listing

SELECT u.*, r.* FROM sqhc_users u, sqhc_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='1984e2e205a5c9196f45b6c5e7b7efcb' LIMIT 1
UPDATE sqhc_users SET userHash='c9bf364b9d143ff2f5bcb2bd60afce0c' WHERE userID='1'
[37] SELECT p.privKey FROM sqhc_user_privileges p
[24] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM sqhc_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[4] SELECT collectionID, collectionKey, collectionEditRoles FROM sqhc_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM sqhc_forms WHERE formID='2' LIMIT 1
[10] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM sqhc_forms_responses WHERE formID=2 AND responseSpam=0 ORDER BY responseCreated DESC LIMIT 0, 10
[16] SELECT FOUND_ROWS() AS `count`SELECT u.*, r.* FROM sqhc_users u, sqhc_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='1984e2e205a5c9196f45b6c5e7b7efcb' LIMIT 1
UPDATE sqhc_users SET userHash='c9bf364b9d143ff2f5bcb2bd60afce0c' WHERE userID='1'
[37] SELECT p.privKey FROM sqhc_user_privileges p
[24] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM sqhc_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[4] SELECT collectionID, collectionKey, collectionEditRoles FROM sqhc_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM sqhc_forms WHERE formID='2' LIMIT 1
[10] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM sqhc_forms_responses WHERE formID=2 AND responseSpam=0 ORDER BY responseCreated DESC LIMIT 0, 10
[16] SELECT FOUND_ROWS() AS `count`

Brilliant, sorry should have spotted that myself! Thanks

Still no uploaded file showing in response listing.

Any other ideas on that issue?

Thanks

Form response listing page debug

SELECT u.*, r.* FROM sqhc_users u, sqhc_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='fd530e300d5132587ff3f884d5039a88' LIMIT 1
UPDATE sqhc_users SET userHash='1511e709f5f18b417cc88be070319d47' WHERE userID='1'
[37] SELECT p.privKey FROM sqhc_user_privileges p
[24] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM sqhc_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[4] SELECT collectionID, collectionKey, collectionEditRoles FROM sqhc_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM sqhc_forms WHERE formID='2' LIMIT 1
[10] SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM sqhc_forms_responses WHERE formID=2 AND responseSpam=0 ORDER BY responseCreated DESC LIMIT 0, 10
[19] SELECT FOUND_ROWS() AS `count`
Queries: 9
Memory: 2.8375

My mistake, as there was a CSV download and the link to detail is not obvious I'd missed it. All good now on this issue thanks for your patience as always.