# Issue with the API Data

**URL:** <https://community.glideapps.com/t/issue-with-the-api-data/71059>\
**Category:** Ask for Help\
**Created:** [February 22, 2024, 1:58pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059 "2024-02-22T13:58:04Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 22, 2024, 1:58pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/1 "2024-02-22T13:58:04Z")

</div>

We have connected Airtable with Glide and are updating all data into Airtable using the API, as you already know. My issue is that we have not given edit column access for the VS Calendar Table throughout the app.

However, some columns are being updated with incorrect values through the API.

This seems impossible, as users only have view access to the columns. I will share a screenshot of the bug. In the screenshot, it appears that we edited two columns via the API, but in reality, no one edited them from our end. This has a significant impact on our side.

Could you please investigate and provide a clear reason for the issue, along with a resolution?

 ![Screenshot 2024-02-17 at 1.07.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/3/b3c9164a7c2346d33d9a10ca381bb37b6f6aa60f.png)

---

<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:** [February 22, 2024, 2:03pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/2 "2024-02-22T14:03:52Z")

</div>

Do you have editing enabled on any Glide screens that use that table?

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 22, 2024, 2:06pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/3 "2024-02-22T14:06:39Z")

</div>

No

---

<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:** [February 22, 2024, 2:13pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/4 "2024-02-22T14:13:37Z")

</div>

I don’t use Airtable, so I’m not sure, but my initial thought is that something isn’t configured correctly in your app.

What I would do is open the table in the Glide Data Editor, select the column, and choose Find All Uses. Then trace through everywhere that column is used and see if you find a spot in the app where that column value is unintentionally being changed.

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 22, 2024, 2:25pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/5 "2024-02-22T14:25:15Z")

</div>

Thank you so much for your response. Will try it on my app.

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 22, 2024, 2:40pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/6 "2024-02-22T14:40:24Z")

</div>

![Screenshot 2024-02-22 at 8.01.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/2/3282dd46827eff5b06375d186889e14db45f307b.png)

You are right. It showing that given write access. How to make it as readable?

---

<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:** [February 22, 2024, 2:48pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/7 "2024-02-22T14:48:00Z")

</div>

Something in your Kanban is overwriting that value. Check to see how the Kanban is configured.

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 22, 2024, 2:54pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/8 "2024-02-22T14:54:34Z")

</div>

Okay

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 27, 2024, 8:08am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/9 "2024-02-27T08:08:58Z")

</div>

I reviewed the Kanban Configuration, and I observed that when I modify any other field in the table, it only displays read access; however, when using the Event Status, it shows write access. I would like to understand if this behavior is expected in the Kanban View. How can we address and rectify this issue?

---

<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:** [February 28, 2024, 12:02am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/10 "2024-02-28T00:02:10Z")

</div>

What field are you mapping your “Event Status” to the Kanban component configuration?

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 28, 2024, 5:43am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/11 "2024-02-28T05:43:26Z")

</div>

The field type is a Single Select from the Airtable database.

---

<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:** [February 28, 2024, 6:25am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/12 "2024-02-28T06:25:17Z")

</div>

I think the question, which configuration setting in the Kanban is using the Event Status. What is linked to that column to cause it to change?

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 28, 2024, 6:50am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/13 "2024-02-28T06:50:13Z")

</div>

I have attached a screenshot for your reference. We have configured two fields, ‘Event Status’ and ‘Volunteer Orientation date 1.’ The data is grouped based on these fields.

 ![Screenshot 2024-02-28 at 12.19.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/2051bef0c38c60adae7a253e275a9b6bac36fa2b.png)

 ![Screenshot 2024-02-28 at 12.15.06 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0659e2f55c850d9aa9d83566edc030ff9983894.png)  
 ![Screenshot 2024-02-28 at 12.15.21 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/464ef602f359992c57f15f139d4b780e82dab085.png)

---

<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:** [February 28, 2024, 12:41pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/14 "2024-02-28T12:41:37Z")

</div>

When you drag a card from one group to another, does that not change the event status? I assume it would.

---

<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:** [February 29, 2024, 12:14am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/15 "2024-02-29T00:14:02Z")

</div>

Also why do you have both “Group by” and “Custom groups” setup? I thought it should only be one or the other.

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 29, 2024, 7:11am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/16 "2024-02-29T07:11:51Z")

</div>

Yes it is changing

> [@Jeff\_Hager](#):
>
> When you drag a card from one group to another, does that not change the event status? I assume it would.

Yes, it is changing. Is there any possibility to disable that action?

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [February 29, 2024, 7:24am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/17 "2024-02-29T07:24:04Z")

</div>

I don’t need to group all values in the Event Status field. That’s why I am using a custom group to add my needed option to that field.

---

<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:** [February 29, 2024, 1:12pm UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/19 "2024-02-29T13:12:47Z")

</div>

> [@lavanyamuthu876](#):
>
> Is there any possibility to disable that action?

If you don’t want to allow a user to move the cards, then I recommend creating a template column that duplicates the Event Status column. This will create a computed column that cannot be changed by the user. Point the Group By setting to the template column.

---

<div class="post-metadata">

**Author:** ![lavanyamuthu876](https://avatars.discourse-cdn.com/v4/letter/l/b5a626/32.png) [@lavanyamuthu876](https://community.glideapps.com/u/lavanyamuthu876)\
**Post date:** [March 5, 2024, 9:51am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/20 "2024-03-05T09:51:25Z")

</div>

Hey, this works. Thank you so much for the solution!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 12, 2024, 9:51am UTC](https://community.glideapps.com/t/issue-with-the-api-data/71059/21 "2024-03-12T09:51:43Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
