How do I check a box then save and edit, redirecting to a specific form?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have the following formula to check a checkbox then save and edit the same record. The issue is that I have several forms available and I want to save and return to the form I'm on, form id 20. The below formula works but redirects me back to the default form for this table. I thought I needed to insert "&dfid=20" in here somewhere to make it work but it's not working and I've tried it in a few different places.

If([Confirm Inventory] = false,
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
   
    "&_fid_282=1" &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=er&rid=" & [Record ID#])

Photo of Andrea

Andrea

  • 90 Points 75 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Try this


If([Confirm Inventory] = false,
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    
    "&_fid_282=1" &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=er&dfid=20&rid=" & [Record ID#])
Photo of Andrea

Andrea

  • 90 Points 75 badge 2x thumb
Yes! Thank you. That was perfect.