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?
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.
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.
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?
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.
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.
Hey, this works. Thank you so much for the solution!
