URL Button Return URL

Question

I have a button on the [NEW CASE] form that gives users the opportunity to create a new record [NEW KEY TERM] within another table which then populates the option list for [KEY TERM] on the [CASE] record.&nbsp;
I have a button that works BUT i can't seem to get the RURL right - I want to return to the existing form/current record within the Cases TableCases Table =&nbsp;bpw9r2twcKey Terms Table =&nbsp;bp2kau43aURLRoot() &amp; "db/bp2kau43a" &amp; "?a=API_GenAddRecordForm&amp;dfid=2&amp;bg=1" &amp; "&amp;z=" &amp; Rurl()Please help!------------------------------Owen Morgan------------------------------

bradlemke · Answer

When returning to the Cases table form, are you returning to a 'New Case' form with no record ID yet?​------------------------------Brad Lemke------------------------------

markshnier__you · Answer

Owen,Maybe leave out this&amp;bg=1I'm not sure what that is there for.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

owenmorgan · Answer

No ideally to the record they are starting from, or even more ideal, the box would be a popup

------Original Message------

When returning to the Cases table form, are you returning to a 'New Case' form with no record ID yet?

------------------------------
Brad Lemke
------------------------------

markshnier__you · Answer

Owen, we must be missing something about what you are trying to do.

I just launch an Add Parent button and while in Add mode ( and having set my Table Properties Advanced settings to Automatically save Parent when child is added), I clicked to

Add Child with this code

URLRoot() & "db/" & [_DBID_CHILD] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode ([Record ID#]) & "&dfid=10"
& "&z=" & Rurl()

I was able to save the child and upon save was returned to the parent in edit mode.

How is your workflow different than mine?

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

owenmorgan · Answer

Thanks Mark,&nbsp;That's part of the challenge. There is no relationship between the tables. [Key Terms] is a field in [Cases] that draws from the Key Terms table into a multiselect field. They are effectively tags on a record. So there is no parent/child in the scenario.The formula as I posted has no return string, I left it empty as nothing I tried worked. Ideally a window would pop up and then the key term could be added. Would love to be able to add as multiselect works "add new choice" but that requires a relationship which is not really necessaryOwen------------------------------Owen Morgan------------------------------

Forum Discussion

URL Button Return URL

Related Content

Formula Url Buttons

Nesting URL API Calls in one Button

Formula URL Button to Open New Form and Check a Box

URL formula -API_RunImport

Delete Formula Button Error