Forum Discussion

AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
8 years ago

How can I create a record in a table when I click in a button of another table (with conserving some values)

I have a "Requisition" table, with a button "Make into Purchase Order". Another table is "Purchase Orders" . I would like a button in the Requisition form when clicked, it would creates a PO with the...
APIs and custom code
Ask about Quickbase functionality
Forms
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
You can do it with a formula url button.  Either using the API_AddRecord or API_GenAddRecordForm.

You will have to define the values that you want to copy, but that is pretty straight forward.  An example is what appears in any of your default "add" buttons.


URLRoot() & "db/" & [_DBID_MESSAGES] & "?a=API_GenAddRecordForm&_fid_53=" & URLEncode ([Record ID#])& "&z=" & Rurl()

Where the line:
&_fid_53=" & URLEncode ([Record ID#])& "
Is the information that is being written to the new form.
  • AyoubSalhi's avatar
    AyoubSalhi
    Qrew Trainee
    8 years ago
    I couldn't make it work, I used API_GenAddRecordForm
    URLRoot() & "db/" & [_DBID_PURCHASE_ORDERS] & "?a=API_GenAddRecordForm&_fid_6=" & URLEncode ([Record ID#])& "&_fid_29=" & URLEncode ([Vendor])&  "&z=" & Rurl()
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    I'm not 100% sure, but because the table [DBID_Purchase_Orders] is in a different app, you might have to hard code the dbid (i.e. bm4a6kyi8).

    Is it in the same domain?  i.e www.YOURCOMPANY.quickbase.com
  • AyoubSalhi's avatar
    AyoubSalhi
    Qrew Trainee
    8 years ago
    Yes there are in the same domain, I'm able now to copy some fields, I figured out the 'fid' values was wrong. I'll try to copy the others and see what happens. Thanks