# Insert table in a form with dynamic choice component columns?

**URL:** <https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869>\
**Category:** Ask for Help\
**Created:** [July 13, 2023, 2:54pm UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869 "2023-07-13T14:54:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fer\_Ele](https://avatars.discourse-cdn.com/v4/letter/f/f1d935/32.png) [@Fer\_Ele](https://community.glideapps.com/u/Fer_Ele)\
**Post date:** [July 13, 2023, 2:54pm UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869/1 "2023-07-13T14:54:47Z")

</div>

Can I insert a table with choice component columns, within a form, to enter information?

It is a form to place an order, and following a header with text entries for the client information, I want to insert a table to enter the product order information, that would be like this:

Columns: Category / Brand / Model / Quantity  
With a “+” button or similar to add rows when needed for ordering more products.  
And the first 3 columns would be choice components, where I would like to apply a dynamic choice component filter, so that the choices shown in each column depend on the choice made on the previous one.  
Is that possible?

In addition to this, is it possible that when submitting the form, the information is written to the corresponding google sheet, in this way: as many rows as products entered, repeating the information on the form that is general (like order number, client, mail, etc)

Thank you!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 14, 2023, 1:03pm UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869/2 "2023-07-14T13:03:46Z")

</div>

I think to achieve what you want on the front end, you should use a custom form.

> [@How do I create a custom form?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using [User Specific Columns](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

In your helper table, create a column to hold a user-specific “unique ID” column.

On entry to the custom form screen, you would have a combo action like this:

If unique ID is empty, set a unique ID value to the column, and then show the details screen for the custom form.

If unique ID is not empty, then show the details screen only.

On the form screen, you would have a collection action/form button to allow users to add rows to an “Order Rows” table: Category / Brand / Model / Quantity

Once the user wants to submit the order, you would write the Unique ID above to an “Order” table: Order Unique ID / Timestamp etc

and then clear the unique ID to prepare for the next order.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 14, 2023, 1:05pm UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869/3 "2023-07-14T13:05:18Z")

</div>

> [@Fer\_Ele](#):
>
> In addition to this, is it possible that when submitting the form, the information is written to the corresponding google sheet, in this way: as many rows as products entered, repeating the information on the form that is general (like order number, client, mail, etc)

With my setup above, you would only store the client’s info on the order table. To me it’s a cleaner setup, and you can use relations/lookups to bring the info to the Order Rows table.

---

<div class="post-metadata">

**Author:** ![Fer\_Ele](https://avatars.discourse-cdn.com/v4/letter/f/f1d935/32.png) [@Fer\_Ele](https://community.glideapps.com/u/Fer_Ele)\
**Post date:** [July 14, 2023, 9:31pm UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869/4 "2023-07-14T21:31:20Z")

</div>

Many thanks Thinh for your response! I´m trying it out but it´s taking a while because I´m new to Glide.  
I have not been able to set the custom form layout format to what I was looking for. I would like to achieve something like this:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee1dce9394b9b4fbf60130f8fdee26f193356dca.png)

But I don´t find how to insert an entry “table”, so that the user can entry the info like that, in a horizontal logic, with the first 3 columns being choice component columns , where the choices available for the second and third column depend on the combination of the previous columns choices entered.

If there is no way to do so, can you show me how to show the form like this:

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca2567d772e1949a93da3dbceaf05ebe388194e7.png)

So that the form shows a first container with those choice component entries, and when you click the + button or something like that, it shows a second container for entering the same components and so on, until completing the info for each of the different products the order may have.

Many thanks in advance!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 15, 2023, 4:02am UTC](https://community.glideapps.com/t/insert-table-in-a-form-with-dynamic-choice-component-columns/63869/5 "2023-07-15T04:02:26Z")

</div>

> [@Fer\_Ele](#):
>
> But I don´t find how to insert an entry “table”, so that the user can entry the info like that, in a horizontal logic, with the first 3 columns being choice component columns , where the choices available for the second and third column depend on the combination of the previous columns choices entered.

At the moment that is not what is supported. You can use a collection pointing to the “Order Rows” table like the image you show, and have the title bar action be a form to submit rows, with the “Unique ID” of the order being part of it.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/ca2567d772e1949a93da3dbceaf05ebe388194e7.png)

Filter the collection by “Unique ID” (the column in the Order Rows table) is this screen’s “Unique ID”.
