Forum Discussion

ShawnSchrotber1's avatar
ShawnSchrotber1
Qrew Member
6 months ago

Formula URL - Edit then Add

Hello Everyone,   I'm trying to create a single button that will allow our users to add an effective end date to a record on form ID 11 and then when that is saved redirect to the add record api usi...
  • MarkShnier__You's avatar
    6 months ago

    Try this

     

    URLRoot() & "db\" & Dbid() & "?a=er&rid=" & [Record ID#] 
      &"&dfid=11"
      & "&NextURL="
    &URLEncode(URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" 
      & "&_fid_6=" & [Paragraph]
      & "&_fid_7=" & [Publication]
      & "&_fid_8=" & [Description]
      & "&_fid_11=" & URLEncode([Staff Contact])
      & "&_fid_17=" & [Effective End Date]  
      & "&_fid_19=" & [Record ID#])

  • MikeTamoush's avatar
    6 months ago

    Marks answer should work, but I just wanted to add that this will only work on desktop version, as $NextURL does not function on mobile, so just be careful of that.