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 yo...
APIs and custom code
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
    ------------------------------
    • DanielMarcos's avatar
      DanielMarcos
      Qrew Member
      5 years ago
      Can the GenCopyRecord work on this approach like?

      var text url = URLRoot() & "db/" &[_my_target_table] & "?a=GenCopyRecord&fid_978=1001" & "&_fid_7=" &[Id];

      groupID = 1001
      fid_978 is the field from source table where groupID = 1001
      fid_7 is the field from target table (where the data will be added)


      ------------------------------
      Daniel Marcos
      ------------------------------
      • StevenShweky's avatar
        StevenShweky
        Qrew Trainee
        5 years ago
        GenCopyRecord will just put up an add record form for the user which some fields filled in.

        I could work with you on a one one one basis to get it working but it's too involved for me to post a complete solution on this forum, if you don't have a background is using APIs in URL formula buttons.

        ------------------------------
        Steven Shweky
        ------------------------------