Solved: Adding a joint table in existing app--How do I con... - Page 2

yumei · 12-22-2022 11:55 AM

I have an app that is running and there's plenty of data in the various tables. Now I have added a new table, a joint table called "MentorStudents". It has two foreign key columns "Ref" to "Mentor" table and "Student" table. I thought that once I have established the relationships, existing data would show up. Of course it didn't (the table is still empty).

How do I get this new table populated with existing data? I googled and found a reference to "restart" the app. But I don't know how to restart it aside from refreshing the columns.

dbaum

I don't think your new table is going to populate automatically. If you have the relationships between Mentors and Students already represented in either or both of those tables, you could likely devise an app action (or just a formula directly in a spreadsheet data source) to perform the initial population of the new table's rows. If those relationships are not already represented in your app's data, you'll need to create the rows manually--again, potentially directly in the data source and not necessarily via the app interface.

@yumei wrote:

a reference to "restart" the app

I don't know what this might be. If you think it will help, try signing out and signing back in to AppSheet

View solution in original post

Adding a joint table in existing app--How do I connect the data?