# Cascading (parent/child) filters in forms - how to submit resulting data?

**URL:** <https://community.glideapps.com/t/cascading-parent-child-filters-in-forms-how-to-submit-resulting-data/22156>\
**Category:** Ask for Help\
**Created:** [February 3, 2021, 3:10am UTC](https://community.glideapps.com/t/cascading-parent-child-filters-in-forms-how-to-submit-resulting-data/22156 "2021-02-03T03:10:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rasha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rasha/32/4585_2.png) [@Rasha](https://community.glideapps.com/u/Rasha)\
**Post date:** [February 3, 2021, 3:10am UTC](https://community.glideapps.com/t/cascading-parent-child-filters-in-forms-how-to-submit-resulting-data/22156/1 "2021-02-03T03:10:36Z")

</div>

**Context:** Lab-grown cart. Adding a product to cart is primarily via **button \> actions \> form**.

- Each product is assigned a unique ID.
- A product can have more than one option.
- A combination of options = variant
- Each variant is assigned a separate unique ID.

Variants are added to cart from a parent product’s screen, not their own. Consequently, **the screen columns** accessible in the form don’t reveal the variant’s data. I can’t access the variant’s unique ID.

Example product with 5 variants, 3 options

Variant 2 = A1 / B1 / C1  
Variant 2 = A2 / B1 / C2  
Variant 3 = A2 / B2 / C3  
Variant 4 = A3 / B2 / C1  
Variant 5 = A3 / B2 / C4

3 choice components for A, B, and C preferences.

I **_can_** filter for the variant ID with a 4th choice component but that’s not helpful since I won’t be asking a user to select the resulting variant ID for me. How might one get that value out of the form and into a sheet?

~~filtered inline list~~  
~~user sp columns in forms~~  
~~magic~~  
~~option 1 - option 2 - option 3 template on both ends, then relation~~

what am I missing?
