Hi, I still can't figure out the correct order of the blocks

Discuss
1

Hi, I still can’t figure out the correct order of the blocks. I keep getting an error. Can someone tell me what I’m doing wrong and how to fix it? Needless to say, there are two tables in BaseRow, comparing each other with the ID to bring data from both tables and combine them.

image

blocks (1)
blocks (1)1112×804 51 KB

blocks
blocks1114×906 53.9 KB

2

in dat0s variable remove replace block to selete list item in intex1

3

I put it there just for the sake of it, but no matter how many times I take it out the problem is the same.

4

image
image431×582 25.5 KB

image
image560×130 1.87 KB

5

u can’t get it.
I say
use datos2 variable to selete list item (value ) in index1 block
do not use it directly

6

image
image390×559 23.9 KB

image
image592×130 1.73 KB

it’s always the same mistake

7

image
image547×128 1.82 KB

image
image429×561 24.5 KB

No matter the position, I put it in any position, it always returns a similar error.

8

This is the data I receive from baserow, from both tables

WhatsApp Image 2025-06-18 at 23.40.06
WhatsApp Image 2025-06-18 at 23.40.061080×599 80.3 KB

9

When baserow got values, catch it on any global variables and share it here so we can an put end mark to this else it will go on with same suggestions and reporting same error

10

Thanks for responding, don’t you want me to send you the aia privately and check when you have time?

11

WhatsApp Image 2025-06-18 at 23.40.06
WhatsApp Image 2025-06-18 at 23.40.061080×599 80.3 KB

12

would u plz clear that what do u really want to do by this data

13

I have 1 db with 2 tables in 1 data is loaded such as ID, Name, Price, Stock, Image (of the product). In the other table the same ID is loaded but fields such as NAME and PHONE are added. I want to compare the ID of both tables, and extract from table 1 only the image, and from table 2 the NAME AND PHONE .. and display it in a cardview, with an image on the left, on the right ID, Name and phone. It’s something like a reservation. I clarify that the cardview is working and I have already designed it, I also have the data from both tables that come from baserow. just as seen in the image.,

1 Like
14

try this suggestion may help u

for each userItem in UsersList:
    userSplit = split userItem by ">"
    userID = select item 1 of userSplit
    userName = select item 2
    userPhone = select item 3

    for each productItem in ProductsList:
        productSplit = split productItem by ">"
        productID = select item 1
        productImage = select item 5

        if userID = productID:
            create CardView
                set image = productImage
                set label = "ID: " + userID + "\nName: " + userName + "\nPhone: " + userPhone

:puzzle_piece: Kodular Blocks Logic (Pseudo-code):

  1. Loop through each item in Table 2 (users):
  • Split the string by “>”
    • id_user = split(item, ">") → select item 1
    • name = select item 2
    • phone = select item 3
  1. Loop through each item in Table 1 (products):
  • Split this too by “>”
    • id_product = select item 1
    • image = select item 5
  1. Compare IDs:
  • If id_user = id_product
    • Now you have a match.
  1. Use Dynamic Components or CardView extension:
  • Set image (left side): from image
  • Set label text (right side): "ID: " + id_user + "\nName: " + name + "\nPhone: " + phone
15

I left you a private message