# Help Lists in Airtable **URL:** \ **Category:** Get Help\ **Created:** [July 22, 2020, 5:46pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679 "2020-07-22T17:46:22Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 22, 2020, 5:46pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/1 "2020-07-22T17:46:22Z")
I am migrating the Adalo database to Airtable, and I am having difficulty managing linked lists. I have to manage Categories and Subcategories, I can’t show only the subcategories associated with your category. For each category I display all the subcategories !? ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/edd8d9876e684cd4a2ac7ca338b7909be53b6ef4.png) Where am I doing wrong? ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 22, 2020, 7:42pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/2 "2020-07-22T19:42:30Z")
will be easier to figure out the right move… if you join a capture of your Screen Tip \*have you tried adding a 2nd filter - just below the 1rst one ? - specify just the subcategory criterias in this one. …if this is what you re trying to achieve… 🤷‍♂️ ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 23, 2020, 8:55am UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/3 "2020-07-23T08:55:54Z")
Thanks @bibipac for the reply. I have two simple linked tables: category and subcategory. Each subcategory is associated with a category. Category ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/e/e846ced5204d3b83965940c1fa49c8cf44973481.png) SubCategory ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/1db53009889d52a07486662e088eac2f74cfa62f.png) I would like to show the records like this: Category 1 subcategory 1 Category 2 Subcatgory 2 etc… I set the filter like this: ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/d27dbcbacb90d359757d0248f1ad737b065c47e6.png) what I get in output is this: ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/c/c54dc928d479357594dd8bdf661ac668f3e88bcd.png) It is as if the filter has not been read. ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 23, 2020, 1:48pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/4 "2020-07-23T13:48:45Z")
Sorry @Ben, @jeremy, @ashley, @karimoo, @bibipac I ask for your help because I don’t understand if the problem is the filter set or an Adalo bug in recovering data from Airtable. I tried in various ways: if the value of the category associated with the subcategory is entered manually, the filter works but from the magic text it does not work, that is, it extracts all the records for each category. Would you please anyone who can help me understand where the error is in this view? Thank you ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 23, 2020, 1:50pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/5 "2020-07-23T13:50:24Z")
Would set up of : “Maximum value” (in sorting) to 1, …solve the issue ? ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 23, 2020, 1:54pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/6 "2020-07-23T13:54:37Z")
Extracting 1 record (maxRecords = 1) does not resolve issue. ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 23, 2020, 2:11pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/7 "2020-07-23T14:11:55Z")
Did you set it to 1 … for Category, …or Subcategory ? ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 23, 2020, 2:22pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/8 "2020-07-23T14:22:57Z")
If I set maxRecords = 1 on the categories: it extracts a single category and below shows all the sub categories (even those not associated). If I set maxRecords = 1 on subcategories, it extracts only one subcategory but is not associated with its own category. If you have a list (“list 2”) inside another (“List 1”) with data from Airtable, how do you filter the data of list 2 based on the key of List 1? How do you set the “filterByFormula” field? ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 23, 2020, 2:56pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/9 "2020-07-23T14:56:31Z")
Not at my pc right now, though… I think you only need to display the subcat list - then within the subcat frame, add an empty field, (using +)than grab the cat name through a custom formula…like “category.name”…and it only - smartly ,😋 lookup -and -add this name beside each subcat.name… (or above, depending where you place the field) ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 23, 2020, 3:16pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/10 "2020-07-23T15:16:37Z")
I tried this workaround, but the result is that for each sub-category you repeat the name of the category … does not seem very smart… 😉 ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 23, 2020, 8:32pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/11 "2020-07-23T20:32:13Z")
hmm, yes that is the target, but you are saying its still not displaying the result as your wanted scheme below ? (…with the extra MaxRecord =1) 😳 > [@stffnc1974](#): > > I would like to show the records like this: > > Category 1 - subcategory 1 > Category 2 - Subcatgory 2 ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 23, 2020, 9:21pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/12 "2020-07-23T21:21:04Z")
Ok, i m back to Station 🙃 So, this is what i can get… 1/ choose to add a new “LIST” (not just a Field Imput) for Subcat Name. (within the MAIN cat frame) 2/ maybe you did not chose the “current Subcat” …so as to get ONLY the 1 to 1 Corresponding Subcat Value. 3 / do NOT use MaxRec 1… My bad… 🙊 👍 ![Capture du 2020-07-23 11-10-10](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/bfb0f3dd75aadefe835bc836355abd5ee91b206e.png) ![Capture du 2020-07-23 11-11-28](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/725a05c70ec0b882a7d2375af072c9708aedbe50.png) ![Capture du 2020-07-23 11-11-51](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/f/f4e9da577e939912455f7a019375c4fa40d430dc.png) ![Capture du 2020-07-23 11-12-18](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/8/8d415f2ec34d87b9591a1a417ea6e0c62d086f37.png) ![Capture du 2020-07-23 11-14-05](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/1/142529472536a1e42df7f0136d3f325c99f00552.png) ![Capture du 2020-07-23 11-14-34](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/dcb0bc4b0858efdf3500e9c524df8cb41cb54daa.png) I have just heard today that React Nativ relies a lot on Nested component… so that is the way to think of when doing that kind of stuff **Maybe you d want to support this component REQUEST for a practical compact Data Display** 😍 [Compact GRID 2x2 to 5x5](https://ideas.adalo.com/component-requests/p/square-22-up-to-55-grid-table-component) ---
**Author:** ![stffnc1974](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@stffnc1974](https://forum.adalo.com/u/stffnc1974)\ **Post date:** [July 24, 2020, 4:58pm UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/13 "2020-07-24T16:58:27Z")
Hi @bibipac, thank you for your availability but I don’t solve the question. Adalo-Airtable … filterByFormula doesn’t work for me. If I use the Adalo db there are no problems in obtaining nested lists, but with Airtable it is impossible. Do you use Airtable? Do the “filterByFormula” parameters work with magic text? Not me! What is surprising is that none of Adalo employees give support in these cases … especially considering paying customers. With these bugs Adalo is unfortunately limiting. ---
**Author:** ![bibipac](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bibipac/32/786_2.png) [@bibipac](https://forum.adalo.com/u/bibipac)\ **Post date:** [July 25, 2020, 2:54am UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/14 "2020-07-25T02:54:01Z")
yep, bummer…I try to get as much juice out of Adalo as possible, so no, I am not a big fan o relying on 1,2 or more providers…for the same reason/problem you are dealing with - though I totally understand you re stuck because both providers do not link perfectly. (On the other hand does Adalo really have the culprit or maybe its a problem out of Zapier…or worse its an incompatibility for both teams are using different standards…so who’s going to do the first step ?.. 😬) …as you mention; quite some time can go before its solved by someone. If this is crucial to you, than option 1/ you try to find a workaround…2/ you test another Provider with which the same process could bring better reliable results… …I would try option 1 first and if you don’t come out with s/t in a month…then you know what’s the next step. 😶 Tuff non-coder world ! 😬 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [August 4, 2020, 2:54am UTC](https://forum.adalo.com/t/help-lists-in-airtable/2679/15 "2020-08-04T02:54:01Z")
Closed on August 4, 2020, 2:54am UTC This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.