I’d like to save several sets of 5 digit coupon codes into my Bubble app’s database. Type = Coupon Field = Coupon code (number) A page on my site would have an input field (integer) and a submit button. The workflow of the submit button would navigate the user to another page on the site only if…

Yes, you could have two workflows for you Submit button, one that only fires when the coupon matches.

Two workflows makes sense. I’m getting stuck on the workflow that would query the database for the coupon codes. What action do I use to query for a matching coupon code? I’m assuming one of the actions under the “data (things)” section, but none of them seem like the obvious choice. Create, make c…

Ah…I see. Bubble has a Search element. :slightly_smiling:

Yes :slightly_smiling: You could look at doing a Search and then a …contains on the Action.

The AutoComplete dropdown functionality is kind of getting in my way. I don’t want it to auto-suggest anything unless there is a complete match. So if the coupon code is ABC123, then the user would have to type in the full ABC123 before getting an auto suggestion to select. I set up an equals to c…

I have added another way of doing it, so a condition on the input (not autocomplete). The button isn’t clickable until you enter a valid voucher.

Very cool Nigel. Thank you. Right now it seems to be case sensitive. If I type in ABC123 the button becomes clickable, but if I type in abc123 the button does not become clickable. Is there a way to set it so that it’s not case sensitive?

It is bit hacky, but I have amended so that it searches for both upper case and lower case matches.

Thanks @NigelG ! That did the trick. :slightly_smiling: Is this kind of work around necessary because Bubble’s search functionality is always case sensitive by default?

Ah, well, no, it seems :slightly_smiling: The search that we did on the “send data” didn’t need this. But the condition does. Which is odd ! Maybe one to ask @emmanuel ? Case matching is different across a condition and a workflow action.

Query a list of coupon codes

fayewatson August 23, 2016, 6:40am 15

@supernaturally, @pnodseth found a great workaround for that:

Topic		Replies	Views
How to use cuopons list? Need help	2	187	December 25, 2023
How to Run a workflow if the Value user entered exist within the database? Questions	9	445	January 27, 2024
Problem searching for a value in my database Database	5	402	May 30, 2023
Why oh why am I unable to search the DB case insensitive? Database	40	15043	January 19, 2024
Contains filter only searches for words Need help	36	14488	November 25, 2019

Query a list of coupon codes

Related topics