Recent Discussions
Can I create a single field that displays record owners from a child table
Hi, The use case for my application is for users to track their testing results - there is a parent table for requests and a child table for activities (i.e., test results). I am wanting to create a field within the Parent table that lists all of the people who have submitted an activity for the parent request. Any ideas?Solved0likes3Comments
Delete Formula Button Error
Hello, I have a URL Formula field I created that I'm trying to use as a Delete button on one of my tables, but I keep getting this "A formula cannot end with an assignment to a variable declaration." error message when I try saving it. The formula I am using is this: var text Delete = URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord&apptoken=*XXXXXXX*=" & [Record ID#]; Does anybody know what I should change? Please let me know.Solved0likes2CommentsRestful API Report digesting JSON
I really want to batch UPSERT to a unique field in Pipelines. I am using RestfulAPI to get a report ~ the data is filtered at the source. ChatGPT has shown me {{b.json.metadata.totalRecords > 0 }} is how I know my report has values. I want to iterate over the JSON, Restful API returns JSON ... I cannot select the Restful API as an input for the iterate step. Why must I add a FetchJSON step in front of the iterate step and essentially move the values from the Restful output to the fetch and then to the iterate?Solved0likes1CommentRunning Total
I want to get a running total of the number of rows in a report. I have a formula that is COUNT([field name]), which returns a value of 1. To get the running total value, do I have to first create a var text query on the field I am counting? var text QUERY //var text QUERY = "{fid#.}"; Is the Running Total formula: SumValues(GetRecords($QUERY),fid#)Solved0likes2Comments
Calculation/Performance Limits Inquiry
Hi all, I'll try to keep this as brief as possible. I'd like to know if anyone has a similar sized application in production and if they see any performance issues as it pertains to record loading and report loading. I have an Accounts table (table A) that will have 1,500 records total at any given time. This table has 3 children tables B, C, and D with 72,000; 168,000; and 168,000 total records at any given time, respectively. These children records will all have an Account# to tie it to their parent. On table A, I need to keep up to 4 years worth of data (Current Year, Prior Year, etc.). As a result, I will need about 1,500 to 1,750 currency summary fields per year (6,000 to 7,500 in total). This number then gets doubled because Quickbase does not have a built-in way to display numbers in Accounting format, so I need an additional 6,000 to 7,500 rich text formula fields. At no point in table A should I ever need a report with more than 12 columns of calculated summary fields for all 1,500 Account records. This is the max performance need. On the forms, I plan to "only" have 6,000 to 7,500 of the 12,000 to 15,000 total fields displayed. This will be broken across 4 different tabs (hoping that improves performance) for each year of data. Then each tab will be broken into 6 sections, which can be pre-minimized if it will help load times & performance (Actuals, Budget, Forecast, Actuals VS Budget, Actuals, VS Forecast, Budget VS Forecast). This table A is my biggest concern. If you care for additional context: In addition to this, table A will be a child to table E (Summary Report Rows). There will be 12/13 total Summary Reports (table F; parent to table E), made up of about 168 table E records. To restate, the 168 records will be parents via 3 relationships to the Accounts (table A). There is 1 relationship per key/vital column in the Accounts table. These will be running calculations based on the summary field calculations in table A. I'll leave it at this for the time being to see if anyone is able to take the time to respond. At the end of the day, I've never built something with this many calculations and I'm not entirely sure on the order of operations for Quickbase when it comes to forms. Regards, CurtisSolved0likes10CommentsIs there a way to "Pause" an app
We intercompany charges for Quickbase app usage and I have been asked if there is a way to suspend or pause an app while this intercompany charge is resolved. This app has like 225 users and about 50 roles. I really don't want to go user by user or even by role. I totally do not want to delete the app. Any ideas would be appreciated.Solved0likes2Comments
If Then Else formula with a multi select field.
Help Please. I have a multi-select field that has the options of Mail, Email and Dept to Initiate. Mail and Email can both be options. In that case, I want it to display "Mail and Email". But if just mail, "Mail, if just email, "email", etc. However I can't seem to get it work correctly. it does show both. Then will show just Mail, but when Email is selected it still shows Mail. I've looked at this so long and tried to refigure it that at this point is probably glaringly obvious, but I just can't see it. This is the current formula I have: var text Receipt=If(Contains(ToText([License Master - Renewals Received via:]),"Mail, Email")=true, "Mail and Email", Contains(ToText([Renewals Received via:]),"Mail, Email")=true,"Mail and Email", Contains(ToText([License Master - Renewals Received via:]),"Mail"), "Mail", Contains(ToText([Renewals Received via:]),"Mail"), "Mail", Contains(ToText([License Master - Renewals Received via:]),"Email"), "Email", Contains(ToText([Renewals Received via:]),"Email"), "Email", Contains(ToText([License Master - Renewals Received via:]),"Dept to initiate"), "Dept. to Initiate", Contains(ToText([Renewals Received via:]),"Dept to initiate"), "Dept. to Initiate"); "<span style='font-size:18px;color:#1E90FF;white-space:nowrap'><b>"&$Receipt&"</b></span><br>";Solved0likes2CommentsAdd button to create record in different app
Hello, I'm trying to create a button that will direct users to a different app to create a new record in the other app. The database ID for the other app is buwc5yqwz The table ID in the other app is bupbavsbm The related field in the other app is 38 I've searched the community and attempted some examples that others tried but converting them from edit a record to adding a record, but I'm not getting anywhere. What I have attempted so far gives a Page unrecognized error. Attempt1: URLRoot() & "/db/buwc9wxmb" & "=API_GenAddRecordForm&_fid_38=" & [Record ID#] &"&z=" & Rurl() Attempt2: "https://xxxxx.quickbase.com/nav/app/buwc5yqwz/table/buwc9wxmb/action/nwr?a=cr&rid=new&field38="& URLEncode() Do I need to add a token? Thank you!Solved1like2CommentsSorting Combined Text Field by Record ID#
I have a Combined Text summary field titled "Languages Spoken by Admin" that pulls data from a table also named "Languages Spoken by Admin" that I created. I added the combined text field onto a report on my "PSL Survey" table, but the problem is that the data is automatically sorted alphabetically (see 1st screenshot attached) and not how it's entered on the table shown in the 2nd screenshot (see attached). Does anyone know how I can sort the data by it's Record ID#? NOTE: I have read through different posts that suggest creating a formula text field, but I would like better explanation here on this post.Solved0likes4Comments
Formula Query with custom key
I have a parent table with a custom key, and I have several formula fields with formula queries that pull data into the parent. The ones that are summing into numeric fields work, but I also have one that is a checkbox formula. I want the parent to have a checkbox if any of the children do. var Textlist vals = GetFieldValues(GetRecords("{48.EX.'"&[Custom Key]&"'}", [_DBID_TABLE_NAME]),43); If(Contains($vals, "High"),true,false) There are no syntax errors but it's not working - there are child records with a checkmark in field 43 but on the parent records there isn't a checkmark. I know the GetRecords function is returning the correct records because it works for my other functions that sum correctly. I tried to run the formula checker, to check each step, but it doesn't work with my custom alphanumeric key. How can I figure out what's going wrong here?Solved0likes3Comments
