I need to have a web form created that will allow me to collect data from a user, submit it to a database and have buttons that will allow me to email using fields from the database.
The easiest way I can describe what I'm looking to do is the attached screenshot. On the left is just the rough database that I have so far - in a access sharepoint web app. On the right is a rough template of an email to be generated.
When I click one of the buttons at the bottom of the database, I want it to generate one of these emails to a new template.
I don't mind doing some of the work myself, so all I need is one of the buttons programmed and I can duplicate the work on the others.
Currently I have the database created in a custom web app for MS Access 2016 and it is on sharepoint. I have also experimented with infopath and sharepoint lists but have not been able to do what I'm looking for.