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()