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?
Best answer by Troy Tessalone
View original