CSV import error -

 

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 .
help1.jpghelp2.jpghelp3.jpghelp4.jpghelp5.jpghelp6.jpg
 
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
0 2 194
2 REPLIES 2

Just an update , I created a export action and downloaded the file and made some changes to the lines and imported the same file using import action, it uploaded the file , it imported all the lines but the lines are all blank expect for the lines which have initial value.  I appreciate your help. thank you.

export 1.jpgexport 2.jpg

Steve
Platinum 5
Platinum 5

This may be related to your use of AppSheet Database. Consider using Google Sheets instead.

Top Labels in this Space