Updating data table

Hi, I’m totally new to this so I apologise if this is simple! I’ve been asked by my nephew to build an app that lets him upload drawings of dinosaurs, rate them, then save the data.
I’ve managed to use the online tutorials to build a really basic app where you can take the photo and set ratings. Plus I have made a data table.

However, what I can’t do is save the ratings and name into my table.

I have a text box which is the name. Then the star rating boxes.

For simplicity, I want the text box entry to go into the Name column of my table, and the speed rating to go into the Speed column as a score (1 to 10). My app has a button called Save.

Is this at all possible? Thank you

Hi @danielwood19856u1tr3

If you are working with local tables make sure to set it as a ‘Stored Data Source’ if you haven’t. This will remember ensure the device remembers the data each time it is re-opened.

  1. Drop the ‘create a row’ block inside the when ‘save button is clicked’.
  2. Attach text from name label to the corresponding section within create a row block.
  3. Repeat this was rating value.
  4. Create an error label to visualise if any issues go on with the creating a row function.
1 Like

Thank you I will give this a try. Is it something I can prove is working through the design m/test screens?

Are you working with a cloud database E.g. Airtable, or local database?

If it is local you can add a data viewer list (DVL) to a screen. This will show any updates to a database as and when a user adds an entry to the table.

If you are working with a cloud database, you can look online at any new entries

Thank you for this it’s been really helpful.

So I have the DVL as my data source is saved locally. However my table has multiple columns but the DVL only seems to let me show one. Am I doing something wrong?

For clarity, it’s a locally saved table, the data entry has 8 fields, with Name being a unique identifier. It also has a photo, but I’m not too sure where this is saved either.

What would be great is to either have the list of names, where if the user selects the name, below the stats show up with the photo. Or just a list of names, photo, then the stats underneath, and the user just scrolls down the page to see each entry. That’s how the DVL icon looks when selecting the component so I imagine I’m just doing it wrong!

DVLs have layouts to choose from or you can make a custom layout. You probably selected a layout with only one or two values. You also need to map (connect) each value in the layout to a data source column:

1 Like