I am creating an app in which while checking out, users can generate a unique code that, when shared with another user provides both of them a discount. I have figured out how to create a code and store it in the database etc, here’s where I am stuck.
Whenever a person types in a code and clicks the button add code, I need the logic to check if it is available in the database and return true/false which will send a dialog. The code is stored in a page variable named disc_code. I know the Lookup command and this as well (IS_IN_ARRAY(VALUES(data.find_order),pageVars.disc_code) but am unable to implement it.
I know this is very basic, but I am an interior designer, not a developer even though thanks to Appgyver and the amazing community I have created an app that exceeds all my expectations.