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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Ayoub,
When you say it does not work, what are the symptoms of the problem.  What is the error message?
AyoubSalhi's avatar
AyoubSalhi
Qrew Trainee
8 years ago
What I wasn't able to copy is 'foreign keys' of other tables from the "Requisition" table.
per example, I have a "Vendor" table that has a relation with the "Requisition" table containing many lookup fields :
I have another table "Requisition Items" which i'm using a report of it in my requisition form :


I am not able to copy the data of the vendor & Requisition items from "Requisition" table to "PO" table .  Even that I specified the fields in the formula : 
URLRoot() & "db/" & [_DBID_PURCHASE_ORDERS] & "?a=API_GenAddRecordForm&_fid_34=" & URLEncode ([Requisition items])& "&_fid_10=" & URLEncode ([Purchase Authority])& "&_fid_9=" & URLEncode ([Descrition])& "&_fid_11=" & URLEncode ([Contract #])& "&_fid_73=" & URLEncode ([Vendor])& "&_fid_18=" & URLEncode ([Voucher #])& "&_fid_19=" & URLEncode ([Voucher Date])& "&_fid_14=" & URLEncode ([Authorized By])& "&_fid_15=" & URLEncode ([Authorization Date])& "&_fid_12=" & URLEncode ([Requested By])&"&_fid_54=" & URLEncode ([Creation Date])& "&_fid_90=" & URLEncode ([Order #])& "&_fid_53=" & URLEncode ([Vendor])&"&z=" & Rurl()