Display a code page within the Quickbase interface
I have a Projects table, with a button in the form which opens in a new tab a single page application contained in a code page. The link looks like this: https://realm.quickbase.com/db/abcdefgh?pageID=17&projectId=81902&a=dbpage The &a=dbpage was added so that the code page loads wrapped by the Quickbase applicaton interface (with the tables in the left navigation and the header at the top). Recently I noticed that this doesn't work any longer and the page opens in a blank page. Is there a way to fix this?
Conversion from user identifier to UserList
Hello, Has anyone found a more elegant solution to the problem of a list of user identifiers like ID's, usernames, emails, and casting or converting it to a UserList data type? I have found people mentioning a variation of the brute force approach which is essentially what I use. I have a count and conditionals to try to reduce needless processing. My total runtime is 0.073 seconds. ToUserList( If([Related Users - Count of Viewer Users] > 0, ToUser(Trim(Part(ToText([Related Users - View Access]), 1, ";")))), If([Related Users - Count of Viewer Users] > 1, ToUser(Trim(Part(ToText([Related Users - View Access]), 2, ";")))), If([Related Users - Count of Viewer Users] > 2, ToUser(Trim(Part(ToText([Related Users - View Access]), 3, ";")))), If([Related Users - Count of Viewer Users] > 3, ToUser(Trim(Part(ToText([Related Users - View Access]), 4, ";")))), If([Related Users - Count of Viewer Users] > 4, ToUser(Trim(Part(ToText([Related Users - View Access]), 5, ";")))), If([Related Users - Count of Viewer Users] > 5, ToUser(Trim(Part(ToText([Related Users - View Access]), 6, ";")))), If([Related Users - Count of Viewer Users] > 6, ToUser(Trim(Part(ToText([Related Users - View Access]), 7, ";")))), If([Related Users - Count of Viewer Users] > 7, ToUser(Trim(Part(ToText([Related Users - View Access]), 8, ";")))), If([Related Users - Count of Viewer Users] > 8, ToUser(Trim(Part(ToText([Related Users - View Access]), 9, ";")))), If([Related Users - Count of Viewer Users] > 9, ToUser(Trim(Part(ToText([Related Users - View Access]), 10, ";")))), If([Related Users - Count of Viewer Users] > 10, ToUser(Trim(Part(ToText([Related Users - View Access]), 11, ";")))), If([Related Users - Count of Viewer Users] > 11, ToUser(Trim(Part(ToText([Related Users - View Access]), 12, ";")))), If([Related Users - Count of Viewer Users] > 12, ToUser(Trim(Part(ToText([Related Users - View Access]), 13, ";")))), If([Related Users - Count of Viewer Users] > 13, ToUser(Trim(Part(ToText([Related Users - View Access]), 14, ";")))), If([Related Users - Count of Viewer Users] > 14, ToUser(Trim(Part(ToText([Related Users - View Access]), 15, ";")))), If([Related Users - Count of Viewer Users] > 15, ToUser(Trim(Part(ToText([Related Users - View Access]), 16, ";")))), If([Related Users - Count of Viewer Users] > 16, ToUser(Trim(Part(ToText([Related Users - View Access]), 17, ";")))), If([Related Users - Count of Viewer Users] > 17, ToUser(Trim(Part(ToText([Related Users - View Access]), 18, ";")))), If([Related Users - Count of Viewer Users] > 18, ToUser(Trim(Part(ToText([Related Users - View Access]), 19, ";")))), If([Related Users - Count of Viewer Users] > 19, ToUser(Trim(Part(ToText([Related Users - View Access]), 20, ";")))) )
Formula Text field populating based on date range
I am working on a task scheduler for my team that would automate the task assignments. Tasks are based on season. How can I automate the Season field using date ranges that exclude a year. As of now this is the formula I use: If([Date Assigned] > Date(2024,10,15) and [Date Assigned] < Date(2024,12,31) ,"Aep", If ([Date Assigned] > Date(2025,1,1) and [Date Assigned] < Date(2025,2,28) ,"Aep","Non-AEP")) This gets what I need - this year. But if we use this going forward I will need to go in and change the dates to adapt for next year. How would Month(ToDate(Date Assigned)) or something similar be used to accomplish this goal regardless of year?
Formula button on a form that opens an add record screen as a popup
In the new forms, if you have an embedded child table and click the add record button. It will "popup" the add record form without redirecting to a new page, or opening a new tab. Is there a way to make a formula url or formula rich text button do that?
Consolidate Field Types
Hello, Is it possible to consolidate several Text - Multiple Choice field types into 1 field for a report? I believe I would have to create a new field and a text-formula as well. My working theory is below: [Scope 1 Manufacturer] and [Scope 2 Manufacturer] and [Scope 3 Manufacturer] and [Scope 4 Manufacturer] ="Company A" We have over 100+ customers, so creating 100 field types for each customer seems to be ineffective option. Thanks! I appreciate this community's help.How to Dynamically Check for Renewal Dates in the Next Month in QuickBase
Hi QuickBase Community, I'm trying to create a formula field that checks if any of several renewal dates (in various fields) are in the next month (from the current date). I want this formula to dynamically calculate the next month without hardcoding specific months. I have several date fields, including: TMB Renewal BLS Renewal ACLS Renewal PALS Renewal I want the formula to check if any of these fields have a renewal date that falls in the next month. For example: If today is December, the formula should check for renewal dates in January. If today is August, it should check for renewal dates in September, and so on. I am not great at the code part of Quickbase and all my attempts so far have failed. Thank you for your help!
Color a mulit-line text based on another field (mulitple choice) response.
Hello, I'm trying to find a way to color the text that is in a multi line text field based on another field (Multiple choice). If ([Mulitple Choice]="No",[Multi Line],color yellow) Any suggestions would be greatly appreciated. Thank you
Checking For Null Field on Text Field?
I have the following formula that checks a date field to see if it is null: If(not IsNull([Coaching_Pipline_Date]), "You have been counseled prior to this conversation on", null) I would like to do this same thing, but change the field to be checked to a text field as when I try to change the field in the formula I get the error : How would I write this to check a text field type? Thanks BrianQUICKBOOKS BILL PAYMENTS PARSING
I have have app that my team can monitor Quickbooks activity without letting the entire user team into our accounting. I have a connected table to Bill payments. When I try to set up a report link In by Bills table I have to mine a record in the Quickbooks table that has the Bill ref # and applied amount. Once Record looks like this: [(null,null,null,'978.00',{('162021','Bill',null)},null)] 978 is the applied amount 162021 is the Quickbooks bill ID Multiple records look like this: [(null,null,null,'97199.28',{('163251','Bill',null)},null), (null,null,null,'37784.30',{('163351','Bill',null)},null), (null,null,null,'8100.00',{('163364','Bill',null)},null), (null,null,null,'12658.44',{('163352','Bill',null)},null), (null,null,null,'1092.00',{('163432','Bill',null)},null), (null,null,null,'1103.00',{('163433','Bill',null)},null), (null,null,null,'130.00',{('163439','Bill',null)},null)] How do I parse this into a Useable Form? I need [DATE],[Bill ID],[And Applied amount]. in a table that I can plug into my Bill View.
