Not returning to parent record

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a parent table for POs and the button that adds a child record (Acct charge). But I can't get it to return to the PO record after I click "save & close" on the new acct charge record. What am I missing? This is my code:


URLRoot() & "db/bncigsm2t?a=API_GenAddRecordForm&_fid_3=" & URLEncode ([Record ID#]) &"&dfid=10" & "&z=" & Rurl()
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
So this part here 

&_fid_3=" & URLEncode ([Record ID#])

says to populate fid 3 with the Record ID# that you are sitting on (ie the Purchase Order Record ID#).  But that fid is not the correct one.  You need to look at your child table and change that to be the fid of the field for [Related Purchase Order]
I'm not really sure what the problem is.,  You may need to go to Support.  Can you post the URL that appears when you click the Add Charge button?
I actually was asking if you could copy and paste the actual URL that you see at the top of the screen when you click that button.
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb
Sorry. Time for more coffee.....

This is where the url button takes me to add the new record:
https://pike.quickbase.com/db/bncigsm2t?a=API_GenAddRecordForm&_fid_21=61&dfid=10&z=etf
I think that you will need to put in a support ticket, assuming that you are launching off a saved parent record and it is not returning to that parent record.  I can't see anything wrong.
Photo of TRNC

TRNC

  • 314 Points 250 badge 2x thumb
I copied the coded and created a new button with the same code. Works perfect now lol
That is bizzare, but sometimes we chalk things up to the world of the unexplained and move on.