I may be overthinking this but here is the short version of what I am trying to accomplish:
I want people to be able to open up a form, it prompt them for a number, it then looks that number up from a lookup table (google sheets) and then displays a corresponding response from the table back to the user.
Long version:
I am building a system to record and track gift card sales for my small business. My thought right now is pretty simple: the employee will open up a google form, and record the sale of the gift card there. The form will track the gift card number, and opening balance. There will be a seperate form to record a sale using the gift card. The form will calculate the balance and keep track that way.
What I am struggling with is finding a way for the employee to be able to lookup the balance of a card and have it displayed back to them immediately. I know I could have it send an email with the balance or something like that but I am really trying to avoid that.
Also to add we maintain our own wordpress site so if needed we could integrate it there somehow.
Any thoughts?