I have seen multiple posts and videos related to capture/upload/(db update/insert) of a single (camera) image for a single record/row, but have not seen any discussion of approach where multiple (unknown quantity) of camera images must be captured and uploaded... and linked to a single record.
An analogous project/challenge may be described as follows: Car collector has entered basic identifying info for each vehicle into a table 'vehicles'. For each vehicle, collector wishes to use his phone to walk around the vehicle, taking camera captures along the way of any feature/s deemed of interest. This would continue to the vehicle interior, again taking a number (where number is unknown) of camera captures, where all need to be uploaded and linked to the vehicle record.
My goal is to implement this inflicting minimum burden on the user. Ideally, user will be free to click the "Take Photo" button, with each image then automatically being captured and uploaded to remote DB, allowing for a subsequent "Take Photo" click until perhaps click a button "Done".
The DB is MySQL, if that matters, running on on-prem Alpha Server. I have a UX currently built which captures the image and displays it in an onscreen Static Text box. But I see no easy (e.g. Action Javascript) method available to upload and link. I do not store to local (device) storage... I suspect that would be wasteful and also perhaps create greater user burden. Would I best capture the image in this fashion and then somehow implement some XBasic (AJAX)? function to move it to server DB? Just not sure which way/path to investigate here.
Looking for any ideas how to best approach this.
An analogous project/challenge may be described as follows: Car collector has entered basic identifying info for each vehicle into a table 'vehicles'. For each vehicle, collector wishes to use his phone to walk around the vehicle, taking camera captures along the way of any feature/s deemed of interest. This would continue to the vehicle interior, again taking a number (where number is unknown) of camera captures, where all need to be uploaded and linked to the vehicle record.
My goal is to implement this inflicting minimum burden on the user. Ideally, user will be free to click the "Take Photo" button, with each image then automatically being captured and uploaded to remote DB, allowing for a subsequent "Take Photo" click until perhaps click a button "Done".
The DB is MySQL, if that matters, running on on-prem Alpha Server. I have a UX currently built which captures the image and displays it in an onscreen Static Text box. But I see no easy (e.g. Action Javascript) method available to upload and link. I do not store to local (device) storage... I suspect that would be wasteful and also perhaps create greater user burden. Would I best capture the image in this fashion and then somehow implement some XBasic (AJAX)? function to move it to server DB? Just not sure which way/path to investigate here.
Looking for any ideas how to best approach this.
Comment