# 🤔 How to?: Use Actions to update to a different glide table? (w/ pics) **URL:** \ **Category:** Ask for Help\ **Created:** [April 16, 2024, 1:08am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609 "2024-04-16T01:08:36Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [April 16, 2024, 1:08am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/1 "2024-04-16T01:08:36Z")
Hello. In the vCalc table we have 3 values we’d like temporarily stored so the user can compare numbers. It needs to happen only twice and they’d like the rows deleted after. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2ecb2364ecbeaa220f11b7a1995f5fd5dfdf4061.png) ex: Input (from vcalc table)-\> click [Hold button] → add column to other table to review. Repeat once more, if needed → [Clear button] to reset screen. So far, I can see the information in the Helper table but I can’t get it to add the second row and show it. (Is there a way to delete the two rows with an action while leaving one blank row with a row id? ) I’ve tried a couple things already: 1. Set column values (which, of course, doesn’t add the rows or clear them) 2. I created an Action from the vCalc table to add a row to the PDT Table. But it still just overwrites. 3. From the User table, I created a Single value column to the PDT table. Then I updated the Action to use the single value to clear the table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d1bb2dfce277c9fbc0ff8bb3f4afaa16fa35af8d.jpeg) Still searching Glide on Youtube and the community form. Would love the help. Thanks! -Jamie ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 16, 2024, 11:07pm UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/2 "2024-04-16T23:07:26Z")
I’m not sure I understand your flow here. Why do you need to delete the rows? What are you trying to calculate? ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [April 17, 2024, 12:15am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/3 "2024-04-17T00:15:21Z")
This is essentially a calculator. In the first image I posted before there are values in the grid with the blue square marked calculate. Those are: Collateral, credit and Profit amount. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2ecb2364ecbeaa220f11b7a1995f5fd5dfdf4061.png) We need to be able to somehow store the numbers temporarily while adding more to evaluate against (no more than 2 or 3 rows). The stored data isn’t needed permanently, just long enough to make a quick assessment. My thinking was: Add the “stored” information (yellow grid) to a table and display it. . since the stored information is not needed later, I didn’t see the need to keep unneeded rows. Am I approaching that the wrong way? What I’m trying now is: 1. An Action on the Hold button that adds the row to a table 2. Reset the two main column values in the blue sqaure: (cr) Premium and Take Profit 3. The user can delete the rows manually until I can figure out a work around. Of course, so far most of the delete buttons removes everything on screen until I hit “new row” in the data tab, since there’s nothing in the field. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d622292c1898111e9c25548d8eee78a17ecd9ae1.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 17, 2024, 11:38pm UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/4 "2024-04-17T23:38:16Z")
I’m still not sure why you need to add rows. Is the main goal comparing the same columns from different rows? ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [April 18, 2024, 5:23am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/5 "2024-04-18T05:23:56Z")
Let me ask this: Based on what you see on the grid, what is the best way to capture those pieces of data to compare them? Ex: they need to in put the numbers and have it show up temporarily. Doing that about three times with different numbers. It would look like this in the grid: Collateral. Credit. Take Profit % 1. .20 60 2. .22. 60 3. .21. 60 👆 the only reason I’m deleting the rows is because the information isn’t needed afterwards. It’s just a temporary calculation. If there’s a way to calculate AND display The input in real time then clear it out without deleting rows I’d love to know how to do that. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 18, 2024, 5:30am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/6 "2024-04-18T05:30:08Z")
> [@JamieErvin](#): > > Based on what you see on the grid, what is the best way to capture those pieces of data to compare them? > > Ex: they need to in put the numbers and have it show up temporarily. Doing that about three times with different numbers. I’d use a 3 row helper table with a series of User Specific columns. Then I’d use data editor logic to target specific rows and the ParentID reset method to “clear” the values. I realise that probably doesn’t make a whole lot of sense to you. If I can find some time later, I’ll make an example for you. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [April 18, 2024, 1:03pm UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/7 "2024-04-18T13:03:26Z")
Here’s a video explaining what the goal is. > **[Holdiing values/ Deleting the Rows](https://app.screencast.com/ZMIvWKr4pE8b1)** > > World's leading screen capture + recorder from Snagit + Screencast by Techsmith. Capture, edit and share professional-quality content seamlessly. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 18, 2024, 11:56pm UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/8 "2024-04-18T23:56:05Z")
> **[Calculator - Data Grid example](https://docs.lowcode.agency/recordings/wN4Mix4IePv27YvDrGeD)** > > Summary: > The video explains a data calculation process involving input values, product columns, and user-specific data. > > Chapters: > 00:00 Introduction and Setting up Cells > 00:36 Working with Rows in the Calculator Table > 01:06 Clearing Data... Here’s a quick setup using a helper table, data grid and single value columns for the “clear all” function. ---
**Author:** ![JamieErvin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamieervin/32/57900_2.png) [@JamieErvin](https://community.glideapps.com/u/JamieErvin)\ **Post date:** [April 20, 2024, 6:05am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/9 "2024-04-20T06:05:35Z")
THANK YOU, ThinhDinh!! I appreciate you taking the time to make the video. I’ve implemented your solution on a couple of screens and they all work. You’ve helped me reach a milestone in the process. Much appreciated! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 27, 2024, 6:06am UTC](https://community.glideapps.com/t/how-to-use-actions-to-update-to-a-different-glide-table-w-pics/72609/10 "2024-04-27T06:06:24Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.