Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Formula help

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#])
App builders
Formulas and functions
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      7 years ago
      Can I not create a code before the formula to save the current record? 
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      7 years ago
      I thought I could add this code in front but it is not working.  

      URLRoot() & "db/" & [_DBID_DEFECTS_NCRS_CARS] & "?a=API_GenAddRecordForm" & URLEncode ([Record ID#])& "&z=" & Rurl() & "&dfid=3"&
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      See my previous responses.  The [Record ID#] does not exists until the record is saved.  If you goal is to automatically create a child when the parent is created, then I suggest using an ACTION.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    If you want to automatically create a child when a parent is created, you can use an Action..