Really easy. Whats the simplest way for a User to add new data to an existing table?

This is an easy one.

Whats the simplest way for a User to add new data to an existing table?

I am trying to generate a fittness growth chart.

Tables,
Table of Athletes
Growth Table for each athlete

Fitness coach or client (athlete) clicks on their profile. Updates with new fitness level.

End of each month, a report is produced show a graph of data.

Thoughts?

To add new rows the normal method is with a Form Screen.

1 Like

Humm, nope.


That’s a Form Container, which is different from a Form Screen. But no matter, either will do - as long as they are configured correctly.

When you add a Form Container, you need to choose which table it will add a row to. By default, it will choose the first table in your list - which in your case appears to be the Players table. So quite possibly it’s trying to add rows to the Players table. You can check that by clicking on “Form Container” in the components panel on the left, then check the Target Table at the top right.

Also, that relation in your first screen shot makes no sense. Relations work by matching values. In your case, you are trying to match nothing to a name in the Players table. That will never work. What you need to do is configure your Form to write a PlayerID or Player Name to the Fitness Growth table, then you can use that value to create the relation.

And also also :wink:
… assuming that you want to log the date/time of each submission, you don’t need the date picker in the form. Instead you can pass the current date/time as a “hidden” column value with the form.

2 Likes

Ok, thank you so much Darren for all of your help and assistance here. You are amazing and a credit to the Glide community.

I think I have worked it out. Will try a few variations and lock in the best one. My next project is a voting App…

1 Like