Error (bug) in Google Calendar Table - can not pass value to ROW ID column inside add new row action

[Koichi_Tsuji]

@Adam-google @Arthur_Rallu

Error (bug) in Google Calendar Table - can not pass value to ROW ID column inside add new row action

Please see the screenshot below.

The table is coming from “Google Calendar” and there is ROW ID column which is key and made both editable and show is ON.

However, when I try to add new row to this table, ROW ID is not available so we are not able to pass values to ROW ID column as we want, as ROW ID is not available from the pickers list.

I think this is a perfect bug, could you have a look into it?

I ve check the stand alone action and action inside the BOT. Both actions are the same, ROW ID column is NOT available.

@Jose_Arteaga

[Jose_Arteaga]

Hello @Koichi_Tsuji,

I found this video that I think it might be useful with all sort of actions on google calendar.

Let me know please.

[Koichi_Tsuji]

@Jose_Arteaga

It does not make sense to my case.

What we need is to make “Row ID” editable, in other words , we can pass any values as we need arbitrary. Hope you would understand what I mean.

[Koichi_Tsuji]

@Jose_Arteaga

If you check with your app and in your circumstances where you make Row ID column “Editable”, actually it is not editable. This is definitely a bug.

What I m saying here is to report a obvious bug.

[イルカのえっちゃん]

Here is a similar report.

Google Calendar: Not able to set Row ID in action

When we use Google Calendar as a data source, we can add new entries with AppSheet via the following actions: Add LINKTOFORM() Add a new row to another table using values from this row But there seems to be a bug in the “Add a new row to another table using values from this row” action. We cannot select the [Row ID] column to set it’s value. [Fabian_Weller_0-1672655109086.png] This may be intended, because the Google Calendar Event ID has some requirements as stated here. Show More We c…

I also believe this phenomenon is a bug.

[Fabian_Weller]

@Koichi_Tsuji As you can see I’ve reported this issue back in Jan 2023. Case ID: 0-0263000033386

This was the last communication I’ve received:

Jul 10, 2025
We have checked with our specialist team and we have found that this is a very niche case of power use of AppSheet and our Product team prioritized this as extremely low. Such a situation is neither common nor is it used in every day cases. So we have continued to keep it that way. We recommend the you to not to try and customize the “Row ID” when working with Google Calendar as datasource in an “Add a row to another table” action. Hope you understands our limitations.

Jul 14, 2025
Hi AppSheet team,
thank you so much for taking time. OK I understand. But I’m not the only one who wants this as you can see in this community post.
Also: Why can we set the Row ID in a LINKTOFORM() action but not in a “Add a new row to another table using values from this row” action?
In both ways we should be able or not.
Fabian

Jul 14, 2025
We completely understand your concern and are committed to resolving this issue as quickly as possible. We have forwarded the information you provided to our specialist team.
We will keep you updated as soon as we receive their response.

After that there was silence.

[Koichi_Tsuji]

@Fabian_Weller @イルカのえっちゃん

Thank you for sharing valuable info. My request might have been repetition.

Very much sad our request and serious voices have been ignored by Google for years and years, and no action taken…. It is likely their stance/behavior against the valuable customers continues, as they seems to listen to the internal (or large enterprise customer) only, and not pay attention to the voice from the community. No hope to their approach to the customers.

[Koichi_Tsuji]

I dont know when Google teams would understand their support service for AppSheet is gaining ZERO TRUST from the customers. It is likely they won’t understand forever.