🤔 How to?: Use Actions to update to a different glide table? (w/ pics)

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.

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.

Still searching Glide on Youtube and the community form.

Would love the help. Thanks!

-Jamie

I’m not sure I understand your flow here. Why do you need to delete the rows? What are you trying to calculate?

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.

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

I’m still not sure why you need to add rows. Is the main goal comparing the same columns from different rows?

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

:point_up_2: 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.

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.

Here’s a video explaining what the goal is.

Here’s a quick setup using a helper table, data grid and single value columns for the “clear all” function.

1 Like

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!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.