Forum Discussion

DanielMarcos's avatar
DanielMarcos
Qrew Member
5 years ago

Copy Group using http action or API

Hello,

Are there any ways to copy group of records from one table to another using API or http action?
In example I will copy 1 or more records with same group ID to a different table.

Thank you in advance.

------------------------------
Daniel Marcos
------------------------------
APIs and custom code

7 Replies

Sort By
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    I think your best option for this would be to use Pipelines to build a process to copy the records, rather than trying to build it in a button. To copy records from one table to another, you first have to query the table for those records and then either loop through each one, creating it's copy in the destination table OR format them as an Array/CSV and import them in bulk. If you're not familiar with the Quickbase API, Pipelines will make this much easier for you.

    If you need this to work on a trigger, you can still create a button that will check a checkbox and use the change to that checkbox as your trigger in Pipelines.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      An approach is to have a single record in a control table to hold the focus group.  The single record  will be Record ID# = 1 and you can relate that to all records in your data set.

      You would build a saved Table to table copy which would restrict the import to records of he correct group ID.

      Then make a URL formula button which will

      1. Set the focus group ID
      2. Run API_RunImport
      3. Land the user somewhere on a record or a report.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • DanielMarcos's avatar
        DanielMarcos
        Qrew Member
        5 years ago
        Hello,

        Can you provide more example?

        ------------------------------
        Daniel Marcos
        ------------------------------