Hey folks. Looking to do a quick proof of concept and could use some advice, assistance, mentoring.
I want to use a form as a trigger to verify identity and look a balance for that user and provide it to them.
For the form I need to collect:
Company name (dropdown box)
First name
Last name
Employee#
I need to query a sql database to verify the user is in the database.
If they are then I need to find their balance and display it for them to see.
Ideally this will look somewhat professional so I’m guessing Google forms is out since they have their text at the bottom.
Anyone willing to guide me in the right direction? Am I trying to recreate the wheel and this has already been done and I don’t know about it? Many thanks in advance.