Forum Discussion

StephanieStepha's avatar
StephanieStepha
Qrew Trainee
11 years ago

Automatically create child record when parent record saved

Is it possible to, when my parent record is saved, have a formula that will (if a specific field has been updated), automatically create a child record on my related child table, populated it with the...
Formulas and functions
Relationships
Tables and fields
QBuserQBuser's avatar
QBuserQBuser
Qrew Cadet
8 years ago
Thanks for the info on the app token.

The number of children varies depending on the selection, but a minimum of 5.  The current button I am working on adds 5 records.  Is there something I can add to the URL formula to save the parent record first and then create the children?

Here is my current formula:

var text SetFocus = URLRoot()&"db/"&[_DBID_FOCUS_TASKS]

& "?act=API_EditRecord&rid=1"

& "&_fid_6=" &[Record ID#];

var text RunImport= URLRoot()& "db/"&[_DBID_TREATMENT_BATCHES]& "?a=API_RunImport&ID=10";
var text RefreshRecord= URLRoot()&"db/"&Dbid()&"?a=dr&rid="& ToText([Record ID#]);

$SetFocus
&"&rdr="& URLEncode($RunImport)
&URLEncode("&rdr="& URLEncode($RefreshRecord))