Why Glide's Row ID Syncs to Google Sheets but other columns dont?

Ask for Help
1

Hi!
i’m trying to sync a lookup column to my google sheet but as u know only basic columns sync. Is there a way around to add: in my case, my ‘lot number’ which comes from a lookup column from another screen?
example: in my data editor:
page 1: column ‘lot’
page 2: lookup column (page 1, column ‘lot’)

google sheet: i need to see the ‘lot’ number appear in page 2

thanks

2

Computed columns don’t sync because they don’t hold values. Computed values are not stored in the table. They are computed directly on the user’s device as needed.

If you want them to sync, you will need to add basic columns and add set column actions that will populate those basic columns with the computed values from computed columns.

RowID on the other hand is not a computed column. It’s still a basic column, but it just happens to be filled automatically by Glide.

2 Likes
3

any tutorial available online? thx

4

Nothing specifically that I know of. It’s just a matter of finding the best place in your app’s flow to add a Set Column action that takes the computed values and writes them to basic columns. Maybe On Submit of a form for example or a second action in a workflow after an add row action. Really just depends on how your app is set up and how your rows are added or updated.

1 Like
5

thank u for ur help.

1 Like