I have created a database with two tables: one for timesheets and another for projects. I have set up a reference from the Project Name column in the timesheets table to the Project Name column in the projects table. Previously, when I only had the timesheets table, I was able to easily upload a CSV file to update it. However, after adding the projects table and setting up the reference, I am encountering an error message: 'Invalid request provided to AppSheet database' when trying to upload a CSV file to the timesheets table.
I am new to Appsheet and I am not a technical person. Trying to create a Timesheet entry for projects. My idea is to enter hours in the timesheet and then add employee table . so I am trying to have a CSV upload for monthly timesheet data .
Can you please guide me on how to import a CSV file to update the timesheets table, considering the columns that are now referenced to the projects table? Thank you, I appreciate your help