:heart_eyes: Not only can you use the new “Set Column” action to edit a value within your sheet via button press, but now you can manipulate values in OTHER SHEETS as long as there’s a relation! [Screen Shot 2020-11-12 at 8.41.52 PM] This is SUPER powerful. In my demonstration below, I take an in…

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?

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

can you please tell how to make relation?

@sam1 [Introduction to Relations | Glide Tutorial] [image] Glide • Quickstart Publish your first app in under 5 minutes

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”.…

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.

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

[image] Mark_Turrell: I learned a trick from @Darren_Murphy — I now put a template column in every sheet: tp-link —> with the value every table? I think you might be getting a bit carried away with this one… :joy:

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

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

Project Showcase

Lucas_Pires September 10, 2021, 11:24am 88

You can follow this thread

Topic		Replies	Views
Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations Feature Requests	55	3504	July 21, 2025
How to clear whole column? Ask for Help actions	61	4889	November 3, 2023
Reset Multiple Rows At Once Project Showcase	47	7598	November 22, 2023
New Row in Spreadsheet for Every User Ask for Help	52	3588	September 26, 2020
Set columns - Clear value action doesn't work the same way everywhere Report a Bug	18	1548	February 4, 2021

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

Related topics