I based an app on Google Sheets. The already present columns were showed up in Glide. Great!
But then I started adding columns in Glide. Some show up in Google Sheets, some not?
What’s the criteria? I’d really like to see some columns (Math, Excel Formula) I added in the Google Sheet.
Sure, any “computed” columns won’t carry over the computation to Google Sheets. But at least the values could be synced, I thought.
No, only non-computed columns will appear and sync in the Google Sheet.
I’ve never really thought about it too much, but I guess this is probably a side effect of having all computed columns evaluated client side.
1 Like
I’ve never really thought about it too much, but I guess this is probably a side effect of having all computed columns evaluated client side.
Hm… that would mean the value are nowhere except during execution on a client.
Advantage: No persistent storage needed for them.
Disadvantage: They need to be recalculated over and over again.
Anyway: Any suggestion for how to get at them for producing reports? Or even seeing them in a Google Sheet?
The biggest advantage is an app that responds instantly instead of waiting for for data to sync back and forth between the glide servers and the google servers.
If you can add a set column action as part of your flow, then you can take this computed values and write them to basic columns in your data.
1 Like
One workaround is to use a set column value and copy your computed value to a basic column… that should make it available in Sheets.
Edit: what Jeff said
3 Likes
If you can add a set column action as part of your flow, then you can take this computed values and write them to basic columns in your data.
You mean I create a “Manual Sync” action for a table and call that after adding/editing a record?
For a column A_calc I would add a column A_sync to the table and the action would copy the A_calc value to the A_sync column?
But how to intercept the default how a record gets stored when submitting a new record or changing an existing one?
Yes, that’s the basic idea.
Add forms and Edit forms have an On Submit action. When a form is submitted, you can execute other actions, such as a Set Column action.
2 Likes
Sorry for asking, but where do I find the submit action for the add and edit forms?
I have a screen for my table. But I don’t see separated screens for add/edit. But when I click on “add” or click a record for editing, I sure see different screens which can be layouted separately.
Where do they exist?
Or would I need to set up form screens for adding and editing manually and manually link them to the add/edit actions of a screen bound to a table?
It’s in the right hand configuration panel when you are inside the form.
This is what I see when I in the edit form of the screen “Aktivitäten”:
Maybe you’re using the older version of Glide with pages?
That’s not an Edit Form.
I suggest taking a look at this documentation.
It looks like you are showing a tab screen or a detail screen, but not a form screen.
1 Like
It looks like you are showing a tab screen or a detail screen, but not a form screen.
Sure, not a dedicated form screen. I used used what was provided automatically.
Thx for the link. Will study that…