Return URL function doesn't work cross app?

Question

Hi all. It seems there is a bug right now in the return URL when utilizing in a cross app functionality, and I am wondering if anyone has found this same bug, and has a work around. I'm hoping I'm wrong, but am not optimistic as I spent time with Kirk Trachy in office hours and he thought the same thing.

The issue is this - when you create a table to table relationship, it creates an 'add xxxx' button to add an entry on your child table. The url coding is generically as follows:

URLRoot() & "db/bpywdcwyf?a=API_GenAddRecordForm&_fid_20=" & URLEncode ([Record ID])& "&z=" & Rurl()

Kirk has informed me that the last part of that line is to return you to the url you came from, so you aren't stuck in the child table. This works perfectly when done in the same app.

However, when the tables are in different apps, it does not return you. My users end up floating around in my master tables app.

Is anyone else encountering this, and have they found a work around? Is it indeed a programming bug or is it simpler than that and I am just doing something wrong?

Thanks!!

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

I just replicated that bug and it does seem like a bug to me.

A work around is this syntax which will erdirdct on save to another URL - that being the parent that you launched from

var text ADD = URLRoot() & "db/xxxxxxxx?a=API_GenAddRecordForm&_fid_69=" & URLEncode ([Record ID#])
& "&_fid_6=" & URLEncode([Request Title])
& "&_fid_10=Active";

var text DisplayParent = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" &[Record ID#];

$ADD
& "&NextURL=" & URLEncode($DisplayParent)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

Sign up

Login to the community