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.
Checkbox Formula - only pertinent records
Hello all, trying to have a checkbox formula that will look to see if all checkboxes are checked for a section, which I have working. But I need to limit it by project, so it doesn't think they are all the same, since each project will have its own checklist. How do I alter the syntax to correctly only associate the checkboxes on the same project? If( ([Yes] = true and [Section] = "Lorem Ipsum") or ([No] = true and [Section] = "Lorem Ipsum" ) or ([N/A] = true and [Section] = "Lorem Ipsum"), AND <I need to limit this to only items on the same project> Ive tried to put in and GetRecords("{16.EX."&[Project - Record ID#]&"}",[_DBID_CHECKLISTS]) But it returns the error "The operator 'and' cant be returned on types 'bool' and 'recordlist' What syntax am I missing to limit the IF check to only items that are part of the same project?
