Issue with the API Data

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?

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

No

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.

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

1 Like

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

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

Okay

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?

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

1 Like

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

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?

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.


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

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

1 Like

Yes it is changing

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

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.

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.

2 Likes

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

1 Like

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