Get Airtable Column based on condition of another column and apply to list viewer

Hi All,

I have an Airtable spreadsheet that stores a users email address and other data they have submitted like an “Issue Title” - Users may have multiple submissions, meaning multiple “Issue Titles” per email address

I would like to be able to retrieve the multiple “Issue Titles” from the Airtable spreadsheet and place them in a list viewer if the users email address they used to login is equal to the email addresses found in the Airtable column?

I haven’t got any blocks that haven’t gotten me close, so apologies for not attaching,

Could anyone please assist?

Hi Jacob111,

I correctly understand that the data structure is this:

email1 | message1
email1 | message2
email2 | message1
email1 | message3
email2 | message2
email1 | message4

and you need to display in the application a list of all the messages of the selected email address?

Example 1

First, AirTable gets all the records and then we filter by the name of the address in the loop and display the resulting selection in the List Viewer.

Example 2

First from AirTable we get all the records and then send them to the Web Viewer where we process the sample using javascript and output it as an html-list or table in Web Viewer.

The general solution of this problem can be as follows.

1 Like

Thanks actech, is there any other way without using custom json and just using a listviewer?

Without JSON you can do without, then everything will become more complicated. The AirTable.GetAllRows method returns objects and you will need to manually convert them to text format, and then create a list from them and load it into the List Viewer.

In my example, we got _item - a list of JSON strings. From this list, you can create your own list - in the loop, go through all the entries and add them to the List Viewer.

Hello, I’m having problems with something similar:

I have an Airtable spreadsheet with five columns of stored data, in the previous page one “value” of a list view is selected, now I need to search in the airtable all rows (in column 5) that have this value written.
Next I’d like to display a List View of the items written in column 4 of these rows, but I have no idea how to do it,

Can someone help me please? :frowning:


See an example of working on the scrAirTable screen from the project (do not use “remix” but open the project on the device, go to the AirTable screen, select items from the list.).

1 Like

Hi @actech,

Can you help me with something similar?
So I have a list L2 (taken from Column 1 of Airtable) from which I select an item.

This Item is also the names of Columns in same Airtable and is set in an app Variable Level2Item

I am trying to display the column based on selection of L2. But its not working.

I think logic is OK since the list gets displayed when I hard-code the column name. Its not being able to understand the column name using Level2Item. What can I do?

So, in hard coding, you use a literal and everything works, but when you use a variable, it doesn’t work.

What value do you set hard and what is the value of the variable in Level3Label.Text?

1 Like

Hi @actech,

I hard-coded any of the column names from the table like “DOUBLE LEG”, “SINGLE LEG” etc and it worked.

So the Level3Label is getting the name properly.

However, the same Level2Item is not being able to retrieve that column. Not sure why.

Value of “error” block?

I haven’t set it to anything. What do you suggest I set it to?

Many purple blocks have a green “error” block. Always check its contents, and now tell me what is in this block - empty, error, or something else? Output it to Label

I can view your project, but to do this, I need a message personally for me, which will have a public link to your project (I can’t view private projects) and access fields to AirTable. If you don’t want to give me this information, I’m afraid I can’t help you any more, but I can advise you to do step-by-step debugging.

Hi @actech,

So after i printed error output to a label, it came as blank but the block started working as needed. Not sure what changed but that will do for now. Thanks for the help.