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 belo...
Forum Discussion
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
- Can I not create a code before the formula to save the current record?
- 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"& - 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.
- Yes I read this. I do not need it to always create a parent record. thanks anyways.
- Then you will need to only show that button only in Edit or View mode so that the [Record ID#] field is populated.
- okay that is helpful. Thanks.
- One more thing. Is there a way to add the record but stay in edit mode.
When I click this button:
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#])
It adds, but i need it to add then edit. - In the your last line here
"&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])
The a=dr means
action equals to Display Record. (not the new ACTIONs, but the action that you want the URL to do).
if you make that a=er
than means action equals edit record.
so just change the dr to er.
