I’m creating an English learning app in Adalo, and using Airtable table. In the English dialogue table, I have fields like Topic Name, Sentence, and Order.
What I want is:
When the user clicks on a topic, only the dialogue lines (sentences) connected to that topic should be shown on the next screen.
But right now, Adalo shows lines from all topics together. I tried using filters and query parameters, but it doesn’t work correctly.
I will send screenshots to explain my setup.
Please help me figure out how to filter the dialogue lines by topic.
Thank you for your previous response and for providing the helpful resource links. I carefully read through all the recommended pages and followed the instructions regarding the filter by formula setup.
I also attempted to apply the filter formula in my app (screenshot attached), but unfortunately, the result is not working as expected. I believe I may be doing something incorrectly in the formula or passing the parameter, but I’m not sure exactly where the issue is. Maybe when I write the formula I fill it with wrong field name from Airtable table.
Could you please assist me further in setting up the correct filter by formula for my use case?
@ogtay your filterByFormula essentially means that you’d like to return those records from Dialogs table, for which the value of the field “Dialogue Topics” match the magic text expression which is taken from Dialogue lines property (I am assuming this property from current record but I may be wrong).
Given that you store strings like “Shopping”, “Parties”, … in Dialogue Topics, and store questions in text in Dialogue lines, such filter will never return anything relevant as the conditions won’t match.
If you’d like to show all questions for, say, “Parties” dialog, the filter could look like
({Dialogue Topics} = “Parties”)
without any magic text. If you’d like to use magic text, then you need to have a collection of topics somewhere and use current topic record as a source for the filter (instead of typing Parties you put a magic text, e.g., of current topic - > name).
As a side note - using Airtable together with Adalo requires some level of knowledge and experience, because you will have to learn Airtable’s syntax for API querying and also you must understand Adalo’s limitations when used with Airtable.
I am not quite sure why did you decide to follow this path, I would recommend watching some tutorials on youtube on the subject.
