We have an excel spreadsheet over 6,000 Disco tracks, listed with the fields: Track Name, Artist name, Genre
We need someone to build a web-based form that allows us to internally update the database with an excel spreadsheet (.csv) which will overwrite the previous database.
On the front end, a user must be able to search this database (search as they type), and make selection for the tracks they would like to hear.
The user should then be able to submit these selected choices to us.
they should also be able to choose to filter the tracks by 'genre' and see the tracks listed only that fit that genre.
When the client submits these choice to us, we should receive an email with their submissions. They need to submit their:
name, email address, and Event ID. (all freetext)
When submitted successfully, they should receive a confirmation message.
I have tried using standard form builders, however due to the large number of tracks in the database, traditional forms...