URL Button Return URL
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] re...
Forum Discussion
When returning to the Cases table form, are you returning to a 'New Case' form with no record ID yet?
------------------------------
Brad Lemke
------------------------------
------------------------------
Brad Lemke
------------------------------
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
Qrew Legend
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
------------------------------- Thanks Mark,
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 necessary
Owen
------------------------------
Owen Morgan
------------------------------- If the target was opened in a window, the original record would need to be refreshed in order for it to see any Key Terms added.
What if you added a new numeric field to the Key Terms table? This numeric field could have the Case id carried into it via the link you provide to the user. We'll call this field [UserCaseID] and pretend its' field id is 99.
Link from Case to Key Term - *Formula URL*:
URLRoot() & "db/bp2kau43a" & "?a=API_GenAddRecordForm&dfid=2" & "&_fid_99=" & URLEncode ([Record ID#]) & "&z=" & Rurl()
Now, in the Key Term table, create a custom save button that will submit the new record and redirect the user back to the original case id.
New Button from Key Term back to Case - *Formula Rich Text*:
var text URLOne = URLRoot() & "db/bpw9r2twc" & "?a=er&rid="& [UserCaseID] & "";
"<a class='Vibrant' style='font-size:14px; color:white; background:#6BBD57; white-space:nowrap; text-align: center;'onclick='RedirectURL.value=(\"" & $URLOne & "\");editform.rl.value=(\""&""&"\");DoSave();'>Submit and Return</a>"
------------------------------
Brad Lemke
------------------------------
- Hi... what field are fid_7 and fid=10...
I am trying to accomplish this as well but do not know what fields need to go in the formula... Assuming they are record ID and such but cannot get it to work...
Thank you.
------------------------------
Amanda Torrisi
------------------------------- MarkShnier__YouAmanda, I suggest hat you post a new question as it's not clear what you mean by "this as well"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
