The app has 3 Screens (Screen1, Screen2 and Screen3).
On the “Screen1” the user clicks on an item on a “List Viewer 1”. The item that was chosen is Updated on the Local DB “choosed” in the the cell in the column1 and rollNum 1.
On the “Screen2” the user clicks on an item on a “List Viewer 2”. The item that was chosen is Updated on the Local DB “choosed” in the the cell in the column2 and rollNum 1.
On the “Screen3” the Label"s text is configured to return a result based on the itens choosed on the Screen1 and Screen2. The result is configured on a Local DB table called “final” (column1 and column2 has a combination of itens chooses on the previous Screens and column3 has the result that based on the itens choosed).
I can’t return the final result simply because I can’t fill out the form of “rowNum”.
Are you connecting to Local DB using the Data Sources method or the component method?
Depending in which one the blocks are different to get the rowNum.
The text of the Label is automatically filled based on a predefined result in the column3 of the following image:
The result is given depending of the itens chooses of the previous Screens (the combination of itens choses in the 2 previous ItemViewer are in the image of the Local DB above).
You can use an and block from the Logic drawer of blocks to combine to if statements.
For these blocks, your first selected value and your second selected value have to match the first two columns of a given row for the app to return the third value as your result.
Well snap! You also accommodated the possibility that no match could be found, while my blocks do not.
@4-1-22-8-4, It looks like Muneer presented a great answer here, so I’m going to mark it as the solution for your original question. If you have further questions about how these blocks work, feel free to follow up with them here!
