Clearing a merge field?
Wondering if anyone has ever cleared a merge field in a child table? Based upon reference below, we can UPSERT to a child table using a merge field as the surrogate key and the relationship is made (the related parent record id# values are filled in on the child record). Now I am trying to break the relationship so the related value is empty after upsert using the merge field. I have tried 0, "", nil, null and nothing happens. Any ideas are appreciated. Reference below: Link related data by importing into lookup fields Builders now have an easier way to import records with related data or link related data in integrations. Now, any lookup field marked unique on the parent table can be used to match instead of reference fields. RESTful Upsert Records—Users can UPSERT data to lookup fields marked unique in the data array in Record Upsert. https://helpv2.quickbase.com/hc/en-us/articles/31900230487700-Quickbase-November-2024-Release-Notes
Code Page for User to Search And Return a Report Visual
I have the following Code page. I have successful code where the user inputs data into 2 fields and QuickBase data is returned. However, where I am struggling is instead of data being returned, a report being returned ideally or I have a formula URL field that can be returned but needs to be an iframe. <!DOCTYPE html> <html> <head> <title>Quickbase Data Retriever</title> </head> <body> <label for="inputField">Enter Record ID or Search Term:</label><br> <input type="text" id="inputField"><br><br> <button id="retrieveButton">Retrieve Data</button> <div id="result"></div> <script> document.getElementById('retrieveButton').addEventListener('click', function() { const inputValue = document.getElementById('inputField').value; const appDbId = 'XXXXXXXXXXX'; // Replace with your Quickbase App DBID const tableDbId = 'XXXXXXXX'; // Replace with your Quickbase Table DBID const targetFieldId = '6'; // THIS IS THE formula URL field const queryFieldId = '37'; // Replace with the FID of the field to query against const userToken = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; const apiUrl = `https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? a=API_DoQuery&query= {'${queryFieldId}'.EX.'${inputValue}'}&clist=${targetFieldId}&usertoken=${userToken}`; ****I have also tried report is qid 6 const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} fetch(apiUrl) .then(response => response.text()) // Quickbase returns XML .then(xmlStr => { // Parse the XML string into a DOM object const parser = new DOMParser(); const xmlDoc = parser.parseFromString(xmlStr, "application/xml"); // Extract the value inside <possible_url> const statusNode = xmlDoc.querySelector("possible_url"); if (statusNode) { document.getElementById('result').textContent = statusNode.textContent; } else { document.getElementById('result').textContent = "No field found in response."; } }) .catch(error => { console.error('Error:', error); document.getElementById('result').textContent = 'An error occurred during the API call.'; }); When I call the formula URL field I get this so 1) is there a way instead of the URL being retrieved to have it in a iframe so that the report visual is shown? 2) Is there a way to instead filter the report for example: const apiURL='https://xxxxxxxxxxx.quickbase.com/db/${tableDbId}? qid=6&nv=1&v0= {'${queryFieldId}'.EX.'${inputValue}'} (this URL does work: https://xxxxxxxxxxxxxxxx.com/nav/app/xxxxxxxx/table/xxxxxxxx/action/q?qid=6&nv=1&v0=Minnie123 (Minnie123 would be the user's input to filter/query based of) and then have visual show in the html? The report does have a filter of "ask the user"
API not deleting attachments
Hi all, hoping someone may be able to assist. Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1' The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist). Has anyone else encountered this or possibly have a solution ? Cheers in advance.
Save & Continue on New Record form
Hello all, I'm trying to create a Save & Continue button for an add form that will return to the record to continue editing. I found this thread ( Add Save and Keep Working Button on form for a new record | Qrew Discussions ) from a few years ago which is exactly what I want to do, but it doesn't seem to be working as stated anymore. var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%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 When I click the created button I do see the "saving record" alert appear and then the green "Record saved!" but then directly after a window pops up "Leave site? Changes you made may not be saved." with options of Leave and Cancel. It doesn't matter what option I select, the next screen is the quickbase error page "Record Not Found" and to either go to the application's dashboard or go back to the previous page. Although the record is there when I go back in manually. I'm not sure what to add to the formula to get it back to the created record in edit form. Thanks, Kelly
RESTful API to Create Lookup Fields?
Can a RESTful API be used to create lookup fields using a pipeline? Or, can anyone suggest a faster way to create 130 lookup fields for a use case in which I have 130 relationships between two tables (I need a new lookup field for each relationship)? I'm hoping to find a faster way of doing this other than manually one-by-one.
File Name for PDF attachments
I'm creating a reoccurring notification with a PDF attachment. The attached file name is only showing as "document-1". The pdf is created through the document template and I'm able to already save it with a specific file name. How do I change the file when it's sent out as a PDF attachment with the notification?
Error message trying to connect to Netsuite
I'm attempting to create a connection with Netsuite and I get this error message. ERROR: duplicate key value violates unique constraint "ServiceTableDefinitions_pk" Detail: Key ("SessionId", "SessionResourceId", "ServiceTableDefinitionId", "LCName")=(t20434735s121413_38826vFk1JV2DG6CAVTXW25SDDXSBW4NM, 1JV2V7HFGFHT8V7ZP11D3V5SK, , country) already exists. I don't know what it means. Any help would be appreciated. Scott
Assigning User to Group if Not in Group
Hello, I would like to set up a pipeline to call API_GetUsersInGroup when a record is created and check to see if the user in a particular user field is in the group and if not, add them using API_AddUserToGroup. I am struggling to find a way for it to see that the user is in the group and stop the pipeline if they are not. Instead, it always shows they are NOT in the group and tries to add them, erroring out when they are already in the group. I'm fairly new to all of this, so apologies if it is a silly question - but how can I have it search through the results of API_GetUsersInGroup for my user and correctly identify if they are already in the group? I appreciate any assistance!
