Forum Discussion

samvedi's avatar
samvedi
Qrew Trainee
7 months ago
Solved

Add child record through parent form and redirect back to parent form in edit mode

Hi, Is there a way I can add child record(s) when adding a parent record through a single form? I am trying to collect general info in the parent form and then have the ability to click a button to ...
Forms
  • MikeTamoush's avatar
    MikeTamoush
    7 months ago

    Sorry, Mark is right, I forgot a very important part. It needs to be a formula rich text. Also, you need to have data-replaceRid=true and SaveBeforeNavigating in the button code as shown below. 

    Try changing your field to a formula rich text and using this code:

    var text RID = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");

    var text RedirectNoRecordID=URLRoot()&"db/"&Dbid()&"?a=er&rid="; // REDIRECT TO THE FORM IN EDIT

    var text url = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=API_AddRecord&apptoken=xxxxxx"
    & "&_fid_48=" & $RID
    & "&_fid_39=" & [Data Source 2] 
    & "&_fid_25=" & [Brief description of data]
    & "&_fid_42=" & [Approx # Interfaces]
    & "&_fid_37=" & [Data Classification]
    & "&_fid_41=" & [Record ID#]; //why is field 41 here? what is field 48 then? This is incorrect but we can only set one field to $RID, so pick the related field.

    "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #1ba802; border-radius: 5px; color: #ffffff; display: inline-block; padding: 4px 6px;  text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 12px \"href='"
    & $url
    & "&rdr=" & URLEncode($RedirectNoRecordID) & $RID
    & "'>Button Words here</a>"

    //You can use any rich text button code, but you must include the data-replaceRID=true.

     

vyb's avatar
vyb
Qrew Member
6 months ago

Hi, I am working with Sam on this and while this helped us resolve the issue, now I want to add multiple data sources under the same parent record by clicking the button just once, is this possible?

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 months ago

Can you post your current code which is working?

  • vyb's avatar
    vyb
    Qrew Member
    6 months ago

    Sure, here is the current code -

    var text RID = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");

    var text RedirectNoRecordID=URLRoot()&"db/"&Dbid()&"?a=er&rid="; // REDIRECT TO THE FORM IN EDIT

    var text url = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=API_AddRecord&apptoken=d4y5wt4betuct5khdpyxbvqp7p6"
    & "&_fid_48=" & $RID
    & "&_fid_39=" & [Data Source 2]
    & "&_fid_25=" & [Brief description of data] 
    & "&_fid_42=" & [Approx # Interfaces]
    & "&_fid_44=" & [Project Name];

    "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #783c7c; border-radius: 5px; color: #ffffff; display: inline-block; padding: 4px 6px;text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 12px \"href='"
    & $url
    & "&rdr=" & URLEncode($RedirectNoRecordID) & $RID
    & "'>Add Data Source</a>"

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 months ago

      OK, so you want to be on the Parent potentially in Add Mode) and click a button and add two children.  try rhis code.  You will need to adjust URLTwoNoRecordID

      var text RID = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");

      var text RedirectNoRecordID=URLRoot()&"db/"&Dbid()&"?a=er&rid="; // REDIRECT TO THE FORM IN EDIT

      var text URLOne = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=API_AddRecord&apptoken=d4y5wt4betuct5khdpyxbvqp7p6"
      & "&_fid_48=" & $RID
      & "&_fid_39=" & [Data Source 2]
      & "&_fid_25=" & [Brief description of data] 
      & "&_fid_42=" & [Approx # Interfaces]
      & "&_fid_44=" & [Project Name];

      var text URLTwoNoRecordID = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=API_AddRecord&apptoken=d4y5wt4betuct5khdpyxbvqp7p6"

      & "&_fid_39=" & [Data Source 2]
      & "&_fid_25=" & [Brief description of data] 
      & "&_fid_42=" & [Approx # Interfaces]
      & "&_fid_44=" & [Project Name]

      & "&_fid_48=";

      var text RedirectNoRecordID=URLRoot()&"db/"&Dbid()&"?a=er&rid="; // REDIRECT TO THE FORM IN EDIT

       

      "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #783c7c; border-radius: 5px; color: #ffffff; display: inline-block; padding: 4px 6px;text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 12px \"href='"
      & $URLOne
      & "&rdr=" & URLEncode($URLTwoNoRecordID) & $RID

      & URLEncode("&rdr=" & URLEncode($RedirectNoRecordID)) & $RID
      & "'>Add Data Source</a>"