Get a specific cell if matched another cell in row in baserow

Discuss
, , ,
1

Hello,
I am trying to do the following:

I have a login system. I want:

When a user register in my app , these data will storing in baserow:

user name

code login(unique code for each new user)

device id (after encryption)=unique

date of the first registration(formatted date..not important)

:small_orange_diamond::small_orange_diamond::small_orange_diamond: important :small_orange_diamond:register date​:small_orange_diamond::small_orange_diamond:second date (Clock time in milliseconds after conversion using Clock…)

I want, for example, that the code entered by users has a validity period of 6 months only, after which the user subscription will expire.

I already know the blocks to set the validity period, but my problem is how to get the second date value for a user with a specific code login.

:small_orange_diamond::small_orange_diamond::small_orange_diamond:I want to retrieve only the second date for a user with a given code login.

I do not want to retrieve all values from the table, because some users register at different times.

please Can you help me with the blocks in Baserow?

I tried using filter, but I don’t understand field ids; it seems very confusing and not practical.

A table displaying a user's information including Name (John), Code_login (747), DV_I (partial hash), Date with timestamp (10/15/2025 04:18:54 AM), and Register_date (1760491134093). (Captioned by AI)
A table displaying a user's information including Name (John), Code_login (747), DV_I (partial hash), Date with timestamp (10/15/2025 04:18:54 AM), and Register_date (1760491134093). (Captioned by AI)863×100 12.1 KB

2

the main thing that i can’t understand it .. row Id :slightly_smiling_face::slightly_smiling_face: i don’t know the row Id that should be add in block to use it in filter block :sob::sob:
please help me
i need this feature login period in my app ..
@Still-learning @Baserow

3

Is this airtable? If so you can try FilterByFormula method of calling data after successful login.

No meed of row id

Did you read this?

4

now it’s baserow database

5

To communicate with Baserow, are you using an extension or a Web component?

6

sumit extension

7

With the search function, you can look up the user’s UID, and it will return the entire row.

8

but how to get the results
there is no event (when baserow after searched!!!) :slightly_smiling_face:

9

i think i must use lookup in pairs or get value for key in dictionary.. after got all rows ?

This image shows a visual programming code block that extracts the 'Register_date' value from the first item in a JSON-decoded list of 'results' obtained from a web response. (Captioned by AI)
This image shows a visual programming code block that extracts the 'Register_date' value from the first item in a JSON-decoded list of 'results' obtained from a web response. (Captioned by AI)2326×370 60.2 KB

10

Use a notifier and show me what you get.

1 Like
11

you will get result under the yellow event of When GotAllRows

also by using web block you can try usingthis formula.

https://your-baserow-instance/api/database/rows/table/<table_id>/?filter___name=John, also can add multiple conditions without any extensions you can try..

1 Like
12

done using got all rows
but i have a small mistake

The latest version(sumit extension) calls get columns(we must make a list), while in previous versions, one column was called in each block of Baserow(get column in text)
This means that when I use get columns instead of get each column and then later use is in list thing, it won’t work—while I should be using the if contain text block.

13

thank you

whats you mean by (your baserow insrance)!!
i am really confusing
each extension work with different method

and sumit latest versions doesn’t accept get columns if i set max records above 200
:slightly_smiling_face:

other extensions work even if i set max record to 10000000

14

does baserow get only first 200 records !??

if user will be 201 how i can make this available

15

you mean
my instance baserow: baserow.io if i don’t have a private server

16

with this method we must read baserow reset api documentation
because it is necessary to add field_id (when get value for key) instead of add name of the column ..

A block-based coding snippet that retrieves a value from a dictionary, decodes JSON text, and selects a list item by index, with some parts redacted. (Captioned by AI)
A block-based coding snippet that retrieves a value from a dictionary, decodes JSON text, and selects a list item by index, with some parts redacted. (Captioned by AI)1912×362 48.1 KB

the problem now is he will give me the result of first result (index=1) not a specific result

17

I finally did it and succeeded !

Now you can call me the professional :rofl: :heart_eyes:
without extension

A visual programming interface displaying blocks that process JSON data from a web response, check for a specific login code, and update a label with a registration date if a match is found. (Captioned by AI)
A visual programming interface displaying blocks that process JSON data from a web response, check for a specific login code, and update a label with a registration date if a match is found. (Captioned by AI)1720×796 108 KB

A block-based programming script sets HTTP request headers including Authorization and Content-Type and then sets a URL to call a GET request for data from an API. (Captioned by AI)
A block-based programming script sets HTTP request headers including Authorization and Content-Type and then sets a URL to call a GET request for data from an API. (Captioned by AI)2274×330 56.6 KB

web url:

https://api.baserow.io/api/database/rows/table/(here table id)/?user_field_names=true

and wihtoud direct search

18

That’s great, I’m glad!

Congratulations :partying_face:

and well done for sharing the solution so it can help others too.

1 Like