ContributionsMost RecentMost LikesSolutionsRe: Table relationship with a formula field in child table As a follow-up to this question, the embedded grid edit report that shows up displays only 4 empty rows. We have use cases where the analyst needs to fill in 200+ rows and would like the ability to copy-paste that many rows into the embedded grid edit report. See above empty report. So when I try to copy-paste more than 4 rows, only 4 rows of data sticks. This would make it very laborious to copy 200+ rows as it would have to be done 4 rows at a time. Is there a work around for this? Thanks! Deepa Re: API errcode 11 XML Parsing Error. unclosed token Hi Chayce, I've checked and do not have any such characters. In my original post above, I've actually inserted the actual XML string (only x'ed out the usertoken and any emails and names). Typically for such errors, I see XML parsing failed. This error reads Unclosed token...that is a new one for me. Thanks! ------------------------------ Deepa Prashant ------------------------------ Re: API errcode 11 XML Parsing Error. unclosed token It appears I forgot to mention the exact error I get. Here it is... <?xml version="1.0" ?> <qdbapi> <action>API_AddRecord</action> <errcode>11</errcode> <errtext>Could not parse XML input</errtext> <errdetail>XML Parsing Error. unclosed token at line 1 column 907 (which is byte 908)</errdetail> </qdbapi> So I tried to find the 907th byte...and that is the very last part of the payload. 907+ remaining bytes shown below. ></qdbapi> So confused. ------------------------------ Deepa Prashant ------------------------------ Re: API errcode 11 XML Parsing Error. unclosed token Hi Chayce, I am using a software called Alteryx to parse my data and pull out of SAP to figure which line items need to be added to my Quickbase app. That software needs me to use the inverted commas in that fashion to make it work. I have not added any new fields...as you can see all the fields I am trying to add data to in the QB app, have an FID#. This morning, the API_Add call went through properly and added a record in QB. But just this one from Feb 27th (entry date) did not make it through. Would like to depend upon the API calls to create the records and not miss any. Hence, want to understand why this line failed to load into QB and yes....that is the actual payload that is failing...just x'ed out the names and emails and user token. Thanks! ------------------------------ Deepa Prashant ------------------------------ API errcode 11 XML Parsing Error. unclosed token So my Quickbase app records are created via an API. I've had no issues and been able to solve all XML errors thus far. This one stumped me. All tags are closed in the XML. I've checked multiple times. What could be causing this error? <qdbapi><usertoken>xxxxxxxxxxxx</usertoken><field fid="75">2024</field><field fid="76">9</field><field fid="15">103032696</field><field fid="28">03-16-2024</field><field fid="9">70050</field><field fid="12">162191.45</field><field fid="53">Trace3 LLC</field><field fid="54">588</field><field fid="55">Cisco Global Maintenance Support 3 years BL 1130</field><field fid="256">640400</field><field fid="21">654127</field><field fid="152">SA</field><field fid="188">2024-02-27</field><field fid="6"></field><field fid="158">fake.name2@fakecompany.com</field><field fid="153">L1_OTHER</field><field fid="154">L2_GIS</field><field fid="155">L3_ENTPR_INFRASTRUCTURE</field><field fid="156">L4_CORP_FUNCTIONS</field><field fid="48">fakename@fakecompany.com</field><field fid="49">Fake Name</field><field fid='8' filename=""></field><field fid='60' filename=""></field></qdbapi> Thanks Deepa ------------------------------ Deepa Prashant ------------------------------ Drop down has users of a certain role So, my app has multiple Roles and each Role has a set of Users. I want to create a drop down field which will have choices of Users within a specific Role. How do I achieve that? ------------------------------ Deepa Prashant ------------------------------ Re: Related Filtered field Figured this one out!! Created a snapshot of the original related field and changed my formula query to use that. Worked like a charm. Sometimes it helps to write out your question. :-) ------------------------------ Deepa Prashant ------------------------------ Re: Related Filtered field Hello, I am making progress! I was able to get my formula query to work by just converting the type to text. But how do I now take a snapshot of either [Location Code in Process RecID] or the actual Record in Location Code request table which gets pulled up initially upon choosing the in-process location code? Once the in-process location code gets marked as completed, that value will disappear and so will the formula query value? Thanks! ------------------------------ Deepa Prashant ------------------------------ Re: Related Filtered field Hello, I tried to use a Formula Query hoping to pull up the corresponding record from the Location Code request table. My query is as shown below: GetFieldValues(GetRecord([Location Code in Process RecID],[_DBID_REQUEST_A_NEW_LOCATION_CODE]),103) where [Location Code in Process RecID] would be the corresponding Record inLocation Code request table but get an error This is my first time using a Formula Query. What am I doing wrong? Thanks! ------------------------------ Deepa Prashant ------------------------------ Related Filtered field Hello, I have an app where I have two tables for Location Codes. One is a sync up withSAP for All active Location Codes and the second table (Location Code request) has a form to Change or request the creation of a new Location Code. In the Location Code request form I also have a STATUS field that tells us if the request is New, in-process or Completed. Of-course if it is completed, it would mean the New Location Code has been created in SAP with the next sync up run (which is daily) and mySAP for All active Location Codes table will now include that New Location Code record from Location Code request table. Now, I have another table calledAsset forms where users can create an Asset Capitalization request and as part of that form can choose from the 'existing' (SAP for All active Location Codes) table or choose from an 'in-process' (Location Code request) list. In the in-process list, we did not want the Location Code requests that had a status of 'Completed' as these should ideally be picked from the SAP for All active Location Codes table. So I used Quickbase action to create a duplicate of the Location Code request table but filtered for anything other than "Completed" Status (lets call this Duplicate Location Code requests). So the problem I am having is that when a Location Code request gets marked as Completed, the Asset form loses the Location Code request choice as that no longer lives in that table Duplicate Location Code requests when it gets updated via Quickbase actions (again daily). Was hoping to create a field that would say if the record number of Duplicate Location Code requests is 33. I would then need to freeze that Record ID# '33' and then lookup Record ID# 33 in Location Code request. As Location Code request table will hold all values, the chosen Location Code will continue to inhabit in the Asset form. Or is there a better easier way to achieve this? Thanks! Deepa ------------------------------ Deepa Prashant ------------------------------