Not returning to parent record

  • 0
  • 1
  • Question
  • Updated 10 months 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 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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]
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
That is bizzare, but sometimes we chalk things up to the world of the unexplained and move on.