Loading a Junction Table in AppSheet Database from existing data in Excel / Google Sheets

[xaviergm]

Hi!

I am building a database for a running project where I have (among other tables) a table with people and a table with applications. I want to create a junction table in between in order to have many-to-many relationships (a person can be a contact for multiple applications and applications can have multiple contacts).

I created the junction table as containing the references to the persons and the applications tables plus a contact type column. i have the data to fill it in ready in a spreadsheet but I am unable to paste the data directly into the table from the editor.

Is there a way to load it from the spreadsheet in an automated way?

Thanks in advance!