Scrambled data when adding data to Google Sheet

Whenever I duplicate a sheet in the platform it scrambles the data and does not go into the correct cell columns.
image

Project data I am duplicating:

Result duplicate:
image

It does not set the correct values in the right cells. I’ve looked at the row creation and it values are correct in the action flow but not when the action completes. Why is my data getting scambled.

This happends for duplicating the rows or when I add data in the connected Google Sheet.

Looks like the components are pointing to the wrong columns.

When you say that you duplicate a sheet, what does that mean? Are you duplicating an app along with the underlying data? Are you changing a data source? I’m not clear on what you are doing when you say you duplicate a sheet.

I created a douplicate of an existing row. The components are not pointing to the wrong columns.

Can you show how everything is configured in your action flow?

Row for row it is the same.



So I assume it’s just a button with that Add Row action? Nothing is immediately jumping out to me. I’m curious what would happen if you deleted and recreated the button/action, but before going that far, a couple things I would try first would be to duplicate the button. If that new button does the same thing, try creating a new one with a new action that only fills a few columns to start.

When you duplicated the row did it have any Unique-IDs or Row-IDs in it? Cause chances are they may be pointing to the wrong/no data. Some of the data that is showing definitely looks like a Unique-ID/Row-ID. Plus it is showing the same UID which may be the underlying issue - it can’t find the relation or points to a random/wrong relation.

Good luck!

image

What you are seeing here is the USER ID getting placed set as their First Name.
The USER ID should not be placed in the first name field.

How did you create the initial duplicate of the table?
It sounds like Glide thinks the Name column is the RowID column.
I would be inclined to do the following:

  • Delete that column in the Google Sheet
  • Sync the change with Glide
  • Add a RowID column from within Glide
  • Add a new Name column from within Glide.
  • Reconfigure the action and try again.
1 Like