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
------------------------------
Original Message:
Sent: 01-14-2020 04:27
From: Owen Morgan
Subject: URL Button Return URL
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
Original Message:
Sent: 01-13-2020 12:19
From: Mark Shnier (YQC)
Subject: URL Button Return URL
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
Original Message:
Sent: 01-13-2020 12:07
From: Owen Morgan
Subject: URL Button Return URL
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
------------------------------