Creating a Formula Rich Text Field
Good afternoon,
I am trying to create a button that will save a record then put me back into edit mode then copy information from one field into another. I have done research on this and found two ...
Forum Discussion
Something like this should do the trick. I got it to work with a few tests so you may need to tweak a bit for your use case. I copied my own example below
_________________________
var text view = URLRoot() & "db/" & Dbid() & "?a=er&rid=";
var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & If( [Record ID#] > 0, ToText([Record ID#]),"%%rid%%") & "&_fid_38=101&rdr=" & URLEncode($view) & If( [Record ID#] > 0, ToText([Record ID#]),"%%rid%%");
var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>";
$link
_________________________
The idea is that you do the 'EditRecord' first in the formula since the SaveBeforeNavigating will commit the record into the system, and then the %%rid%% syntax along with the data-ReplaceRID will swap out the new RID for both instances so that your editRecord and redirect both work as intended. In your EditRecord call where you're doing a redirect - just make sure that you leave the RID piece outside of the URLEncode - otherwise the %% will get encoded and the data-replaceRID won't operate as intended.
------------------------------
Chayce Duncan
------------------------------
The only issue is QB is saying i am missing an app token. I am unsure of where and how to put the app token in this formula. Also, is there somewhere I can learn more in depth about these URL and Rich Text formulas? I am only learning form the discussions area of the QB community and it would really help if I could learn this more in depth. Thanks for your help!
------------------------------
Bailey Desormeaux
------------------------------My test system doesn't require tokens so I took it out. In your editRecord call - just add this back:
(the actual token needs to be updated with your token)
API_EditRecord&apptoken=xxxxxx&rest of your code
As for your question, QB university will be the primary place for info - items like the %%rid%% unfortunately aren't really documented consistently. They live in the archives of the forum or miscellaneous articles that I've found over the years.
------------------------------
Chayce Duncan
------------------------------Hi Chayce,
On the following formula I am trying to make Field 153 be populated with the [Mission ID#] however when i try to do that in your formula i get a syntax error. This is what I was trying to update the formula to:
var text view = URLRoot() & "db/" & Dbid() & "?a=er&rid=";
var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=xxxxxxxxxx&rid=" & If( [Mission ID#] > 0, ToText([Mission ID#]),"%%rid%%") & "&_fid_153=" &[Mission ID#] &rdr=" & URLEncode($view) & If( [Mission ID#] > 0, ToText([Mission ID#]),"%%rid%%");
var text link = "<a href='" & $url & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>";
$linkHowever quickbase is highlighting the two percentage signs here (%%rid%%") and saying please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. Also, if the field name contains either '\' or ']', they should be prefixed with a '\'.
------------------------------
Bailey Desormeaux
------------------------------
