🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES!

Project Showcase
61

Are you talking about the template method above? It won’t have any issues I believe.

1 Like
62

It will be fine. All calculated glide columns, including templates and relations, are calculated on each individual device. That functionality doesn’t happen on the Glide servers, so it will be a unique experience for each user.

2 Likes
63

Those are good news!

3 Likes
64

I cant wait until we are able to clear entire columns with the exception of their headers. That would make for some amazing options.

1 Like
65

What’s your use case?

66

To clear entire columns except top row

1 Like
67

So Imagine you had a contest and u used rows because u had multiple people. Contest ends now your manually clearing columns
Or a game when its game over
Or maybe a daily routine
the lists go on and on

68

With my fantasy app I do this every week, across multiple sheets.
But I have it scripted. Would be rather neat to be able to do this from within Glide.
One less reason to rely on scripts.

1 Like
69

Yeah, I would like Glide to be able to do it but for now it’s scripts…

70

hi there sir,
i have a ‘subtotal’ column in sheet-1 and want to show it on a ‘form’ which is made from sheet-2. How to do?

71

You’d need to bring it into sheet 2 somehow using a relation/lookup.

72

can you please tell how to make relation?

73

@sam1

74

Generally speaking, you need to find or create a column of matching/linking values in each sheet. This is not necessarily the column that has the data that you want to bring over.

Then, in sheet 2, create a relation column in the Glide Data Editor in which you’ll select the two column that “match”. Then create a lookup column that brings the column of data that you need to access into the second sheet.

1 Like
75

I learned a trick from @Darren_Murphy — I now put a template column in every sheet: tp-link —> with the value

link

No actual use of the template column, bar forcing in the string.

Then I name my re-columns usually just connect tp-link columns together.

1 Like
76

I’ve done this before. Helpful for making generalized relations between sheets!

77

every table?
I think you might be getting a bit carried away with this one… :joy:

3 Likes
78

almost every table!

1 Like
79

:clap: :clap:

2 Likes
80

Been such a long time. Welcome back. Hope all things good and well @Glider