I am building a new project where users will enter details about book titles and submit them for approval. The official list of titles lives in another database with a decent API and also contains some reference numbers and dates about the title that is required for the approval.
Purely in the sense of end user engagement what would be the best way to manage this?
Pull all titles and reference details into a holding table and let the user link to the record with look ups pulling in the details. This will consume about half of the available records in the Base.
Let the users free type the Title then have a script check the API for a match on the title, if only one match update the record, if multiple have the user pick the correct one.
Have an app that lets the user search the API and add the selected record.
The latter two probably involve the user navigating away from the record (expanded view) to find a titile.