Can you add records to a table (import) using a file that was attached to a record as a source?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Answered
This is a toy example.

First table is called Attached Files
Second table is called Main Data


I want a user to create a new record in the Attached Files table. That record will have a file attachment field. I want them to upload a csv file to that field and save the record.


Is it possible via webhooks or quickbase actions to take the contents of the csv file and automatically upload it to the Main Data table?
Photo of Cameron Hughes

Cameron Hughes

  • 130 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
So you mean that the CSV would have say 10 rows and you want 10 records created in the main table.

If that is the case, why not just import the CSV directly to the main table.
Photo of Cameron Hughes

Cameron Hughes

  • 130 Points 100 badge 2x thumb
Yeah that's what I want. Basically the users of this app will have  to import 3 or 4 files to 3 or 4 different tables and i'm concerned that if they do it out of order incorrect emails will get generated.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,036 Points 50k badge 2x thumb
The only native solution I can think of is to set up a Connected CSV Sync table and upload the CSV files to one of the three cloud sources or an internal SFTP path.  Then they will upload each hour.  But then the downside is that the Quick Base table keeps growing.
Photo of Cameron Hughes

Cameron Hughes

  • 130 Points 100 badge 2x thumb
okay thats what i thought too. Thanks so much.