Skip to main content
Question

Formula help

  • April 5, 2018
  • 0 replies
  • 39 views

I am attempting to create a new record in another table and prefill the parent table.  It works on existing records.  For example I created a test record and when I click my button (formula shown below) then it creates the parent record as it is supposed to.  When I click new record on the child and go through the steps, click on the button, it says the record does not exist.  


Formula:
URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_AddRecord&_fid_345=" & URLEncode ([Record ID#])& 

"&_fid_365=" & URLEncode ([BU-Plant])& 
"&_fid_347=" & URLEncode ([Related Point of Origin])& 
"&_fid_350=" & URLEncode ([Related Point of Discovery])& 
"&_fid_305=" & URLEncode ([Defect Category])& 
"&_fid_110=" & URLEncode ([Related Defect Code])& 
"&_fid_29=" & URLEncode ([Quantity Inspected])& 
"&_fid_30=" & URLEncode ([Defect Quantity])& 
"&_fid_31=" & URLEncode ([Unit of Measurement])& 
"&_fid_32=" & URLEncode ([Disposition])& 
"&_fid_291=" & URLEncode ([Disposition Comments])& 
"&_fid_356=" & URLEncode ([Related Part Location Name])&
"&_fid_24=" & URLEncode ([Defect Description])&

"&z=" & Rurl()& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])
This topic has been closed for replies.

The record ID# of the record that you are sitting in will not exists until the record is saved. Hence that button will create an orphan child record as the child will not be connected to the parent

If you want to automatically create a child when a parent is created, you can use an Action..