Nested Dynamic Lists

I'm trying to add the ability to attach a category and sub-category to a record. These lists of values need to be dynamic, so I am making use of the Choice (dynamic) field type. The category popup populates just fine, but I'm not sure what my query should be for sub-category. To clarify, category and sub-category are related tables; I associated sub-categories with their parent category creating a hierarchy. Any suggestions on what my sub-category query should look like? From what I understand, it basically needs to query the sub-category table where its category (reference) equals the current record's category name. Thanks for any help with this.

1 reply

    • Kevin
    • 3 yrs ago
    • Reported - view

    OK, after some trial and error, I got something working. For others that may need to do this, here's the code I'm using:

    let cat := text(Category);
    select Subcategory where Category = cat

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 350Views