Using Data List Viewer

I am attempting to design a Football Stats app for in-game use while on the radio. I want to have the app create a table I can see on the next Screen that shows a player’s number, how many catches they have, and the total yards that player has (#85 - 5 catches for 50 yards). This list would need to be viewed at halftime and the end of the game and updated throughout. I have a screen that tacks all the basic team stats. If you view my app you will see on Screen 1 the QB#, YDS WR# that then has a completion Button. It would need to Use the WR# Text, YDS Text, and add one to the catches when that button is clicked. Basically, I need lots of help and I have little explanation but I can show you via my app if I know how to share it via this question. Try this link to view, Thank you I am really frustrated. Thunkable

What is your specific question? Are you just wanting to know how to add one to a variable value when a button is clicked? It helps if you’re specific about the difficulty you’re having.

Thank you for helping. When a play happens the player has a number and will gain or loose yards. When that happens I need the list view to either create that line of data or update the existing one by the players number. When a pass is thrown, The QB# is entered along with the Yardage gained and the WR# that made the catch. The WR# that made the catch would need his data line catches plus one and the yardage gained. The QB# will have a total yards as well and a completion. This should all happen and then be able to see the list on the Halftime and End of Game Screen. I hope that explains it. That is also part of my frustration. Not explaining it to well and failing misserably.

I get the overall idea for the app. One problem is that you’re asking about too much at once. It’s easiest to help you if you narrow your question to one step you’re trying to complete.

I have updated my app a bit attempting to show what I am trying to do. I hope. I have it broken into 4 pieces now I hope. Here is screenshot of what I am trying to do. It will be offline so I will need to store data locally. I am using a Local DB I believe. I will need a way to show that data at some points well. Basically I need the table to create a players number row if they do not exist and update it if it does. Thank you for attempting to help.

You might find my response and this whole topic to be useful in terms of setting up an if/else block:

Does this appear to be heading in the right direction? I feel like it is time to give up and move on. Thank you

You said earlier:

It looks promising to me… does it work as you expect it to? If not, you might try checking for the number of rows in the database to equal zero (0) instead of the list of values being empty. Typically, I would search the database to see if the WRText’s Text already exists in the Player value column. If not, create a row. If so, update that row.

One problem I see if that you’re trying to use the WRText’s Text as the row id. That will fail. It needs to be an integer or you can store the green row id value each time you create a row. But I would probably skip that and – like I said above – search for the Player value and use the row # where you find it as the row id in the update value blocks.

Not sure. I need to start that part over. I did something and the whole thing blew up and I have to trace out what I screwed up. Thank you.

I am not sure how close I am progressing but here is a screenshot of what I have and what it did. It makes the list start but does not give any number other than the first one I enter and as you can see it is not doing the math.

One thing I noticed right away is that you have two different event blocks for when CompletionButton is clicked. That’s generally not a great idea because it’s hard to keep track of what happens when. In your case, you’re setting the PassYrds’s Text to “” (empty string) whether or not the PassYrds’s Text = “”. So no matter what, as soon as you click that button, it’s going to empty out that label. But then you’re trying to use that same value (PassYrds’s Text) for the Yards value in your create row block. So it’s just going to add nothing every time. The same goes for the update value block. That might be the cause of the “NaN” value you’re getting (Not A Number).

That is correct. If I bump that button and there are not yards entered, it makes no entry. I put everything into one button, but it does not work. I will continue to work on it for a bit and see what I can come up with. Thank you

I am getting closer. How can get the data from the table to show up a certain way in a line with some labels. For example the players number is 5. So it should read across #5 1 Recs for 5 Yards.

I also need to understand how to update a row and add to what is already in it. I feel better as if I am getting closer to my goals… Thank you


If you want a different layout for your Data Viewer List, then you’ll need to create a custom layout. You can update individual cells with the [update value] block or you can delete the existing row and create a new one to replace the entire row at once.

I have watched some videos and tried a number of things. My latest effort has come up with this. All of the videos are switching screens. I would prefer not to do that and just have it happen in the background until I need to view it. I have also tried to find the custom layout for data list viewer with no luck. Always wants a picture.

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