[BASE] Create Document Carousel Form From A Directory

[WingleReid]

I am looking to have a form that displays a group of videos (or images) from a single directory with fields to add data about that video (or image).

The “next” button should skip to the next video, and add new information for that file which is recorded in a table.

The path of the file should be entered into a field in the record (automatically) so when you go “back” to data already entered, the form would display the file in question (via the link stored in a text field, not embedded in the database) and that information can be added to / updated.

Is this asking too much?

In short:

1. New entries are based on files in a folder
2. Old entries are based on links to those files in the folder

[frofa]

Yes, this is fairly straightforward to do using a form’s PICTURE CONTROL which links to another ‘path’ TEXT field to store the relative path to your image files. Keep all your images in a local directory with your database file/s. Double-clicking on the PICTURE (IMAGE) CONTROL box should open up a file picker-window for you to locate the appropriate images which will then automatically record its file-path to the linked ‘path’ text field. NOTE: The local directory with the images must not be moved else the file-paths will change (you should keep it in the same directory as the database file.) I doubt the PICTURE CONTROL handles video playback, though. See HERE for more info.

[WingleReid]

Thanks - this gets me part way (ie, selecting an image, and displaying) but I’m not seeing the path to “clicking next” to go to the next image, rather than opening up the select image dialogue again…

[frofa]

Not quite sure what you are getting at here. I presume the ‘next’ image is the next entry in your database, so you would be able to use a the ‘next record’ control in a navigation bar in your form (or perhaps a dedicated NEXT record BUTTON). If you wanted some other sort order you might need to build an additional ‘order’ column into your database.

[WingleReid]

No - the NEXT should be the next file in a FOLDER that I can then ADD info to the datbase. (For that matter, 1st should be the 1st file in a folder…)

[WingleReid]

Though thinking this through… perhaps a script that scans all the “new” files in a directory and adds the to the DB first, then we open the DB and go to town… Mmmmm thinking is fun.