Hello, I need help. I’ve been trying for hours to achieve the following and I can’t seem to do it.
Objective:
I need an application to display the following: “Found” (in green) or “Not found” (in red) on the same screen depending on the search result for text entered in a form field in the application.
Expected behavior:
- When running the application, enter a variable (e.g., 123) in a form for all visitors.
- That variable must be searched for in a database (e.g., DB1).
- On the next screen after entering the variable (123), I need the following to be displayed: If the variable (123) is found in the database (DB1), display the text “Found” in green; if it is not found, display the text “Not found” in red.
Problem:
- I am unable to set the appropriate logic so that if it is found, “Found” appears, and if it is not found, “Not found” appears.
- Currently, I can only make one of these texts appear arbitrarily depending on the search: “Found” or “Not found,” using the data source filters. The problem is that if I enter an incorrect or non-existent value (in the database where the search is performed), the text field remains empty.
Tests:
- I tried calling two data sources with different filters and searches.
- I filtered the databases and set up different views, establishing different views for the data sources.
- I created
nvalidation formulas with Booleans and variable texts. - I separated the databases.
- I created update and creation events according to the filters.
- etc.
Thank you very much in advance for your help!