Solved
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...
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#])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.
