Solution to your project based on my expertise:
- Create an AppSheet web app to allow users to input Student and Father IDs.
- Integrate Google Sheets to search for the IDs in the Students sheet and fetch the necessary data.
- Display student details such as Name, ID, Father Name, School, Coupon Code, and Coupon Value.
- Provide a link to the online store for each Coupon Code.
- Build a user-friendly, single-page app that is publicly accessible.
Hi, Junaid here, Software Engineer, I can help you with this project.
From your requirements, I've got the idea that you are looking for an app to search student data based on Father and Student IDs and display relevant information in an accessible way.
I have a few questions to get more clarity:
- Will the app need any specific validation for the input IDs?
- Do you have a preferred format for the display of results, or should it be a simple table format?
- Are there any specific requirements for the online store link, such as pre-configured URLs for coupons?
Let's have a quick chat or call, to discuss things in detail.