Discussions

Expand all | Collapse all

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

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

    Posted 05-30-2018 21:36
    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?


  • 2.  RE: Can you add records to a table (import) using a file that was attached to a record as a source?

    Posted 05-30-2018 21:39
    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.


  • 3.  RE: Can you add records to a table (import) using a file that was attached to a record as a source?

    Posted 05-30-2018 21:46
    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.


  • 4.  RE: Can you add records to a table (import) using a file that was attached to a record as a source?

    Posted 05-30-2018 21:50
    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.


  • 5.  RE: Can you add records to a table (import) using a file that was attached to a record as a source?

    Posted 05-30-2018 21:52
    okay thats what i thought too. Thanks so much.