# Troubles with Edit Form

**URL:** <https://community.glideapps.com/t/troubles-with-edit-form/60389>\
**Category:** Ask for Help\
**Created:** [April 11, 2023, 4:46am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389 "2023-04-11T04:46:30Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 11, 2023, 4:46am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/1 "2023-04-11T04:46:31Z")

</div>

I am having a few problems with the edit form:

1. I want to use a choice component in the edit form to allow users to change the status of their order. The status column is a single select field. I applied filters to it to only show certain options. However, in the glideapp, the field now shows up as a text field (with the A icon) and displays only the first option for users to choose (when it should be showing three options). This was working before, so I don’t know what happened.

2. I set containers to only show under certain conditions. However, when I test the glideapp, I can see the containers when I shouldn’t and I only see some fields in those containers (other fields in those containers are missing).

3. I made a text and set it to show only under certain conditions but it is showing regardless.

Are these glitches or am I doing something wrong?

I am using airtable as my data source.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 11, 2023, 5:09am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/2 "2023-04-11T05:09:10Z")

</div>

For 2 & 3, can you show a screenshot of your filter conditions please?

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 11, 2023, 3:05pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/3 "2023-04-11T15:05:37Z")

</div>

![Container filter conditions](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f987901dac77bbbbb9014756fa507ac546c4baf.png)

Here is an image of the filter conditions for one of the containers. The conditions are the same for all the containers - essentially, I only want them to show if the user’s order status isn’t Picked Up or No Showed, as that would mean that their order is past and can no longer be changed.

I suspect the problem may have to do with the fact that glideapp seems to be treating single select fields in airtable as text fields, so having the same root cause as problem #1.

As for problem #3, nevermind! It’s working now 🙂 Maybe it takes glideapp a few hours to reflect changes correctly? I have noticed that.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 11, 2023, 3:09pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/4 "2023-04-11T15:09:31Z")

</div>

> [@fishtree](#):
>
> I suspect the problem may have to do with the fact that glideapp seems to be treating single select fields in airtable as text fields, so having the same root cause as problem #1.

Yes, you may be right.

Okay, I’m going to pass on this one as I’m not an AirTable user, so I’m not familiar with how it interacts with Glide.

@Robert_Petitto might be able to help you with this one.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 11, 2023, 3:34pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/5 "2023-04-11T15:34:28Z")

</div>

> [@fishtree](#):
>
> ![Container filter conditions](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f987901dac77bbbbb9014756fa507ac546c4baf.png)

This isn’t correct logic for your filter. The way you have it configured, if the status is ‘Picked Up’, it still fits the filter that the status is not ‘No Showed’. Likewise, if the status is ‘No Showed’, it still fits the filter that the status is not ‘Picked Up’. You need to change it from an OR to an AND because you want to filter statuses that are Not ‘Picked Up’ AND Not ‘No Showed’ When you use an OR like that any status is going to fit no matter what.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 11, 2023, 3:53pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/6 "2023-04-11T15:53:40Z")

</div>

> [@Jeff\_Hager](#):
>
> This isn’t correct logic for your filter.

duh 🤦‍♂️

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 11, 2023, 4:15pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/7 "2023-04-11T16:15:30Z")

</div>

haha yes, of course. and it works now, thank you!

but problem #1 still stands. how to fix this?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 11, 2023, 4:55pm UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/8 "2023-04-11T16:55:42Z")

</div>

Can you share some screenshots of what you are describing? I’m having trouble picturing it in my head.

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 12, 2023, 12:51am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/9 "2023-04-12T00:51:37Z")

</div>

![Choice component settings](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea6effe0bf2bae3a7e4ff78d82ff8369f6c06105.png)  
here’s a picture of the glide screen, showing the choice component in question.

as you see, in the preview window, glide shows only “pre-order” as an option, although there should be two other options shown with it (“postpone” and “assign”).

in the edit form settings, you can see that the Status field is shown as a text formatted field, yet it is actually a single select field in the airtable database.

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 12, 2023, 12:52am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/10 "2023-04-12T00:52:29Z")

</div>

![Choice component filter data](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc0e879f32292b73c8eff12a2cc69c1bf990b17b.png)  
here’s the filter data settings for the choice component.

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 12, 2023, 12:54am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/11 "2023-04-12T00:54:24Z")

</div>

![Status airtable field](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c10cccbf61d298671a63617bb53a3c04c1156e7f.png)  
and here’s the status field settings in airtable.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 12, 2023, 1:45am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/12 "2023-04-12T01:45:31Z")

</div>

Ugg, I’m not an expert on how these things work with Airtable. Normally I would have a separate table that lists all of the status options in separate rows. That separate table would be the source table for the choice component, and then your choice component would write the value to your form destination table. That logic makes sense to me.

But it seems that Airtable lets you have different column types that serve dual purposes. In this case, it contains the list of options as well as holds the value of the selected choice. If I’m understanding correctly, you are trying to use the same column as both your source and your destination, and that doesn’t play well with glide.

This is similar to Linked Records that hold the value for a relation as well as serve as the relation. Glide has some workarounds in place to handle these types of Airtable columns but I’d say it’s not standard procedure to set things up like this.

I think in your case, you can get away with it as long as you create a separate table with all of your choices, and then use that as your choice component source.

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 13, 2023, 2:22am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/13 "2023-04-13T02:22:17Z")

</div>

ok, i did as you suggested and your method works, thanks jeff 😃

i have another question re the edit form though: how do i display values in the edit form that is taken from the same table but which i don’t want users to be able to edit?

i used the “values from screen” components, but am only given a few fields as options (and never the fields i want to display) and they aren’t visible on the layout screen.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 13, 2023, 2:40am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/14 "2023-04-13T02:40:10Z")

</div>

> [@fishtree](#):
>
> i have another question re the edit form though: how do i display values in the edit form that is taken from the same table but which i don’t want users to be able to edit?

You should be able to add any type of text component to your edit screen, and select which ever column values you want from the attached row.

---

<div class="post-metadata">

**Author:** ![fishtree](https://avatars.discourse-cdn.com/v4/letter/f/c0e974/32.png) [@fishtree](https://community.glideapps.com/u/fishtree)\
**Post date:** [April 13, 2023, 3:36am UTC](https://community.glideapps.com/t/troubles-with-edit-form/60389/15 "2023-04-13T03:36:54Z")

</div>

great, thank you!
