Get particular row information via particular text from airtable column

Questions about Thunkable
21

You will need to apply a technique rather than a specific function or block.

When you get the records in the green block, it starts with records, then there is a list of objects which represents the rows in the table and each object start with a property called id. This property has the record unique number to refer to it later.

So you will need to create another list and add the id to that list whenever you add a record in your list that you show to the user.

image
image402×132 11.1 KB

The main block includes to fill up both lists

image
image861×533 60 KB

When selecting any item from the List Viewer you will need to use the green block index to get the row ID.

image
image802×212 16.8 KB

Hope that makes it clear.

1 Like
22

Its Very clear and it worked…

Thank you so much for your patience and detailed explanation as always.

1 Like
23

Hello. I don’t think there is my solution at the top. Maybe I did not say it clear enough.
Suppose we have such a column

PROFESSIONS
aerospace engineer
construction engineer
mechanical engineer
naval engineer
mechanical
construction worker
mechanical metal worker

and I want to extract the records which contain mechanical. How should I set up filterbyformula?

1 Like
24

I’m glad you found it helpful.

1 Like
25

The filterByFormula runs exact search and therefore you get back only what exactly matching the text you provide.

You can try the FIND method in the filterByFormula to achieve what you want.

Try something like this: filterByFormula=(FIND("mechanical",{PROFESSIONS}))

You might need to adjust the text to be acceptable to Airtable expected format to have it working.

2 Likes
26

Thanks muneer, I’ll try later and update you

27

thanks muneer, it works great. Perfect syntax!

1 Like
28

I’m glad it worked for you.

29

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.