Current URL Display without JavaScript
Hello! I am trying to figure out a way to capture the URL of an open form when a record is opened in Edit Mode. I need to run numeric calculations differently when a record is in Edit Mode vs. View Mode and thus need a signal to verify which state the form is in. My idea was to capture the URL and use Text functions to identify if the URL contained the "er" vs. "dr" as a signifier of which mode the form was in. Most of what I could find uses JavaScript. Is there a way to do it without JavaScript? I suppose all I need is the URL displayed in a text format, like pictured below. Thank you!Create Child Record, Save and then Edit button
When I press this URL button it just hangs. Any ideas? I am getting this code from Magic Buttons The button: URLRoot()&"db/"&AppID()&"?a=dbpage&pagename=createchildsaveandedit.html&targetdbid="&[_DBID_Estimator]& "&referencefield=11"& "&rid="&[Record ID#]& "&apptoken=xxx" The code page: <!DOCTYPE HTML> <html> <body> <script> const urlParams = new URLSearchParams(window.location.search); const rid = urlParams.get('rid'); const apptoken = urlParams.get('apptoken'); const targetdbid = urlParams.get('targetdbid'); const referencefield = urlParams.get('referencefield'); const xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if(this.readyState == 4 && this.status == 200) { const response = this.responseXML; const redirectUrl = "https://" + window.location.hostname + "/db/" + targetdbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent + "&rl=bbv"; location.href = redirectUrl; } }; xhttp.open("GET", "https://" + window.location.hostname + "/db/" + targetdbid + "?a=API_AddRecord&_fid_" + referencefield + "=" + rid + "&apptoken=" + apptoken, true); xhttp.send(); </script> </body> </html>
"Button" Data Refresh Quirk
I'm working on a Formula - Rich Text field ([Reject]) that creates a clickable "Reject" button as part of an Expense Report app. The goal is for a user to be able to type notes into a form and then click Reject to trigger other actions via API calls.It's pretty much a variation on the (awesome) Magic Buttons app's "20A. Edit record then add record then display record" field. The first issue I encountered was that the button wouldn't "know" the latest value of the [Notes] Text field that's being edited since it hasn't been saved/persisted to QB yet. A workaround for that was a [Current Notes] Formula-Text field with a formula of just [Notes]. Since it's a formula, it gets updated every time the user updates the [Notes] field. With that problem solved, the button almost works... Except there's a catch: If the user enters notes and -immediately- clicks the Reject button, then the formulas don't get refreshed before [Reject]'s current <a> link gets followed. This means the API calls don't have the latest [Current Notes] value. I've tried Form Rules for updating field values, but that didn't seem to help. Any other user action, like pressing tab, enter, clicking somewhere on the form, or even holding down left click for a second or two, causes the formulas to refresh and the button works A-OK. Has anyone else encountered this behavior and/or know of a way to force formulas to be refreshed?Color coding multi-list pulled from another application
Hello! I am attempting to create a color coding for a multi-list field pulled from another application. But am having difficulty with creating the formula. Utilizing this article: Color-coding fields – Quickbase Help. I created this formula: However the"=" is saying that can not be used for textlist, text. I have tried "contains" with multiple errors. Any help is appreciated. Thank you!
ToUserList display in order of formula entry
I'm using the ToUserList function to create the list (user names) of required approvers for specific records. Ideally I would like the order of those approvers to match the roles listed in an adjacent section of the record. I wrote the function to have approver 1, approver 2, etc. in the preferred order, however it seems that they are only displayed alphabetically on the form. Is there a way to change this default? I've looked and cannot find it.
