Can someone help me doing the following:
I have a data type called “Offers” , it has 2 fields “Value” and “Discount”
There are 3 entries in the Offer table:
- I created an “input form” and a result element “text element”
- What I’m trying to do is: when a user types a number in the “input form” I need to do a lookup in the “Offer Value” entries and check if the input value equals any of the Offer’s value then return the Offer’s Discount details , if there is no match show “No available offer”
If a user types 1 in the input field the result should show 10%
If a user types 4 in the input field the result should show “No available offer”
I’m relatively new to Bubble and I went through all video and trainings and searched the forum but couldn’t find a solution for this one.