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,
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.
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,
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.).
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?
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.
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.
