You’re really close based on what I saw in your last video. It’s just a matter of correcting that Lookup column to pull the current balance out of Column H. Then you will have that lookup value to pass back through column H to update your operation balance.
Actually, I am making the update in the Account Balance table.
I know, that’s the point of the ‘Single Value → Whole Row’. You use it to create the link from the Operations table to the Accounts table. Then the Lookup column retrieves the current balance from Column H so you then have a value that you can use in your Set Column action to write the current balance back to the operation balce column through Column H.
Column H is connecting to the one specific row in the accounts table that you want to update, pulls a column value, and then passes it back to another column.
I think rather than trying to make sense of how it works initially, let’s just get it set up and then it should become clear. You have have Column H set up correctly. Now let’s work on the Lookup column and not worry about the action just yet. Just trust me on this.
Okay, I have made the change.
Now set up the action, which will be linked to the Operation table. You can do that through the a tion editor or you can do it directly from the button.
What you will be doing is adding a Set Column action where the Row is Column H.
The drop does not show a column H
Can you show screenshots of both the Column H configuration and the action editor?
With that link, shouldn’t it allow me to see the Account Balance table?
Pretent that Column H is the Account Balance table. It’s like a shortcut, but to one specific row in that table.
If I do a custom screen what table will control that screen?
I’m guessing that the screen that contains the button is not part of the Operations table so it’s not showing you the correct options.
I finally sat down at my computer and created a video demonstrating how to set it up. Sorry, there is other stuff going on in my house right now, so I wasn’t able to record sound at the moment. Hopefully I went slow enough to follow along.
I hope this works. Now to delete rows in the Savings Account I will have to link them the same way? By the way, I did not see the drop-down under “This Item”
Are you saying that you still have a problem, or that this was the problem and isn’t now?
Would you be deleting a single row or multiple rows in the Savings Account table? If its a single row, then yes it would be similar. You just wouldn’t need a lookup column and the action would be a Delete Row action. If you are deleting multiple rows, then you will need to use a multiple relation instead of the single value → whole row.
First, thank you for being so patient with me. I certainly appreciate it. Even if everything does not all work your time has been very valuable.
I have completed the screen I wanted. I am dealing with live data so I am making a copy of the present database so when I test the screen and data is deleted I can replace the live data back into the system.
Is that a good strategy?
I do a lot of work directly in my live app. If it’s new functionality that I can add quickly, I’ll just add it where it belongs. If it’s something that will take me several days to develop, I may add conditional visibility on buttons or screens so only I will see them. As for data, I guess whatever works for you. I usually don’t touch live data unless I have my own rows that are filtered only to me or I use Row Owners.
Yes, that Row Owners I am looking at now myself so I will know what is disclosed and what should not.
1 Like