I’m missing the content of a couple of cells in my Google Sheet: [image] The cells are empty. But in the Glide table (mirroring the Google Sheet) they contain data: [image] But there is a detail: The values in the Glide table are set during an submit activity of type “Set column values”: [image…

Don’t use onSubmit with a form to set column values. Instead, pass the values with the form.

Hm… I don’t understand. Here’s a simplified example: A user enters into form field A the value 1. The form field maps to column A in a Google Sheet. A math field M increments the value entered in A. M does not appear in the Google Sheet. The calculated value in M also needs to be in the Google Sh…

Your experience is a common one :slight_smile: The issue is that every now and then the Set Column Values will fire before the new row has been created, and so there is nothing to update. And it fails. It might work 99% of the time, but you can almost guarantee that it will fail every now and then.…

A 99% solution unfortunately won’t cut it for me :slightly_smiling_face: So I’ll try the custom form. Thanks for the illumination of these Glide quirks!

Sorry, have to ask one more question before I set out to rework the whole data entry: For what should I use a custom screen? I have a table called “Activities”. I want to add and edit data in that table. Should I create a custom screen and then bind it to “Activities”, put a collection on it and …

[image] How do I create a custom form? FAQ I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as …

Thanks for the link. I remember having seen that app before. But now it seems to have more relevance :wink: Still, though, I’m struggling with understanding it. It’s an application of a certain technique - but it does not really explain what’s going on/why that’s working. But let me try to reverse …

Yeah, that’s more or less it. One key point is that you build your Custom Form on a details screen, not on a form screen. A good way to set it up is to create a Single Value → First → Whole Row column in your User Profiles table that points to your single row Helper Table. Then anytime you need to …

If it’s just 1 form (details screen) how to distinguish between adding a row and editing a row? Add a “mode” column in the data entry helper table? An updated concept app would be great - but even simpler than the current one. And with some sort of documentation :wink: I’m happy to help with that.

[image] Ralf_Westphal: Add a “mode” column in the data entry helper table? Yes, that’s exactly how I’ve done it. When navigating to a custom form, you can set up a custom action that first sets the mode through the single value row in the user profile. Then navigate to the detail screen for…

Column not syncing to Google Sheet

Ask for Help

Jeff_Hager October 3, 2023, 2:27pm 7

Topic		Replies	Views
Glide not updating/syncing with Google Sheet Report a Bug	1	246	August 15, 2022
Once again: Set Column Values with ITE/Lookup/Math values during On Submit Action Ask for Help	27	1454	September 12, 2021
Syncing columns between Glide and Google Sheets Ask for Help	11	668	July 17, 2023
Set Columns Action Ask for Help actions	11	2295	March 8, 2021
Automatic Calculation Ask for Help	6	202	May 29, 2024

Column not syncing to Google Sheet

Related topics