Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Are your Exact Forms not being asked to the prom? Are your rendered invoices and letters getting laughed at for their awkward looks? Well it is time to whip off those nerd glasses, and give those puppies a MAKEOVER!I will be starting from the basics on this, so that everyone can follow. Feel free to skip around and grab code as needed. All right, let's get those forms 'on fleek'. First you will need to understand that we will be manipulating the <style></style> section of the .html page that your Exact Form 'Word' doc renders. If you are planning to update your Exact Form using the 'Word' doc, you will probably have to replace all of your code in the <style> section each time you save. So, I would recommend finishing your build in 'Word', saving, and then going into the .html to alter anything from then on. Ok, let's get started. First, go to your Pages: Next, navigate to your Exact Form (This can be a rendered Exact Form or a Code Page, it just needs to have .h
Hi, We are using quick base exact forms for one of our application.We are able to increase the font size for header of embedded child table report. However not able to increase the font for records content.can anyone help me in resolving this.We are using below code to get records from child table. updating font size in this script not helping.--------------------------------------------------------------------<p class=MsoNormal align=center style='margin-bottom:0in;margin-bottom:.0001pt;text-align:center;line-height:120%'><span style='font-size:11.0pt;line-height:120%;font-family:"Trebuchet MS","sans-serif";letter-spacing:.2pt'>~=if(f[252]!=0)qdb.GetURL(&quot;bgc7px2h4&quot;,&quot;API_GenResultsTable^query={'6'.EX.'&quot;+ field[&quot;RecordID#&quot;]+&quot;'} AND{24.EX.0}^clist=26.8.17.21.64.57.23.63.13.67.68.69^options=qws.nvw.ned.phd.nfg.sortorder-A^slist=26&quot;)~~=if(f[252]==0)qdb.GetURL(&quot;bgc7px2h4&quot;,&quot;API
I have another API Button question...similar to my last question. Using the same table set up (below), but this time the button would be selected if it's for a license that would not be applicable and input from the User would be required. I created a simple table that would pop up when the button was pushed asking the User to add information into the field. It would also check the [Not Applicable] button, then refresh back to the original page. However, I get the attached error page. Any thoughts? License Master (parent table)Pending Locations (parent tableSuggested Licenses (a child (many to many table) to both above)Licenses (child (many to many table) to both License Master and Pending Locations / unrelated to Suggested Licenses)var text UpdateSuggestedLicense=URLRoot() & "db/" & [_DBID_SUGGESTED_LICENSES]& "?act=API_EditRecord"& "&rid=" & URLEncode([Record ID#])& "&_fid_18=tru
I'm trying to modify the layout of a form, but it's difficult to move elements because of the edit menu/toolbar that appears on the right side of the screen. Every time it appears or disappears it moves the form's columns to a new width. Is there a way to make this menu permanently visible so that my columns will stay still?
Hi there,We had a form button (URL formula field) that allowed us to upload multiple documents at one time. Here is the formula:var text URL = URLRoot() & "db/"&Dbid() & "?a=dbpage&pageID=4&refFid=7&rid=" & [Project #]& "&fileattachment=36"& "&attachmenttableurl=" & URLRoot() & "db/" & [Project Name];If(IsNull([Project Manager]), $URL)After the last QB update (last month?) it stopped working.Can anyone assist with this issue? Much Appreciated,Veronica
I have RULE that says when "Ready for Approvals" is checked and an attachment has been added, it triggers an email.Now I want that email to be triggered again if the attachment is modified, that is someone saves over the attachment again (they may or may not change the name).How do track that an attachment has been modified?Thanks!Deepa
Howdy all, I am trying to figure out the easiest way via a Pipeline to identify whether or not a specific email has a user in 3 different applications. I need to be able to dynamically take action based on If Statements within the Pipeline.So far, functions like API_GetUserInfo is useless because if the user's email isn't in the app, it errors out and won't complete, rather than just returning "no user found". Even if it did, you apparently cannot use it on a specific application?Any ideas? I just need to be able to take an email, and see "does this email have a user in THIS specific application, not just the realm overall".
I am coming here to express my frustration. It has been quite a while since I have ventured into Pipelines. I just spent 15 minutes adding all the fields one at a time to the search step and none of them show up in the loop step. I don't want to loose any changes so I am opening all the steps and hoping that moving things around will finally add the fields I selected in the first step so I can pick them in the loop step. Doing this for a while, no fields appearing, I give up and refresh the page. EVERYTHING IS GONE!! Now I start over.PipeLines : if I cannot trust you to save my work, can I please have some indication you are paying attention!!! What is wrong with a save button?Going back to cave.
Does Quickbase still offer functionality to send data from a table to a Box folder via csv in a notification?I have this set up and it's not working.Thanks!
Good evening, I have tabs set up in my parent table records, and in one of those tabs the information is a parent to a child table. I want the purple button to not show for certain case types in a drop down field in the parent record, or if the record has meet the outcome of having 2 reviews completed. Is there a way to do this?
On our app home page, when I try to update an existing report using the widget, or add a new report using the widget, our reports are not showing up in the report dropdown. Even the report that was already previously added via the widget is not showing up in the report dropdown. I am the app manager and have administrator access.We have a number of existing reports for this table, and several are used on the app home page, and have been there for at least a year. All are shared reports with no access restrictions. They are not grid-edit reports. I have not made any changes to the type or location of our reports. I have 3 apps where I'm the manager/administrator, and the issue is happening with all of them.How do I make them show up again? And could this be tied to the recent QB update that changed some UI (tables now listed in a left sidebar instead of on top, etc.)? This is the first time I've tried to change reports since that UI update. Thank you for your help!These are the rep
I have 4 tables I'm working with: License Master (parent table)Pending Locations (parent tableSuggested Licenses (a child (many to many table) to both above)Licenses (child (many to many table) to both License Master and Pending Locations / unrelated to Suggested Licenses)I have a pipeline that searches criteria in the License Master to see if it matches criteria in the Pending Location. If any License Master records match they are copied to the Suggested Licenses table. On the Licenses main form the Suggested License embedded report has the API button I'm trying to create. I want to be able to click the button to Add the Suggested License record to the Licenses table if it is applicable for that location. Then edit the Suggested License record by checking the box "Added to Location" to then filter it off of the Suggested License report for that location. This is the formula I currently have and I'm so close. It adds th
For future me.Leaving this here because I was unable to find any reference using the Khoros Search or Google Search.If((ToText([Email Date]) <> "" and [Email Date] <= (Today()- Days(14)))or (ToText([Instructions Send Date]) <> "" and [Instructions Send Date] <= (Today()- Days(14))or (ToText([Verification Email Date]) <> "" and [Verification Email Date] <= (Today()- Days(14)))),true,false)This formula defines a checkbox formula field.The Checkbox formula field is used in a Pipeline to filter records meeting the criteria.The entire purpose of the Pipeline is to clear the dates from these records once they are older than 14 days in the past.I add this formula field to a report with the fields being evaluated and then look at the report. Only the ones that meet my criteria should be checked. I can use the report to verify it is working or make changes as needed.Once satisfied with the results, I add the formula checkbox to the Pipeline as a single filter.In case
Hello, I received technical support from QB to modify a Pipeline that looks for dates when several conditions are met. The automation searches previous records for the same Employee name, same Topic and Same Category. If any of those records have a date in the Coaching Counsel Field Enter the most recent two into the Coaching_pipelineText field into the new record that also has the same Employee Name, same Topic and Same Category. Currently, the pipeline works when there are available dates. However, when there are no dates I receive the Pipeline Error email. In trying to rectify the issue with QB they state I should do the following:The error you encountered can be addressed using a Jinja conditional statement to clear the field or to input an empty string ("") when the JSON is blank and the data from the JSON when it's available. Please refer to the article below.The Update code currently is this:I am unsure on how to write the Jinja If statement to accomodate
I am seeing an issue within my app where a user's name shows becomes italicized and says "User has been removed" once a form is saved.The use case is a group approval form. In section 1 you enter names from different groups as approvers, and then they can select their approval decision from a multiple choice dropdown in section 2. For some users, once the are selected as approvers in section 1 and the form is saved, their name becomes italicized and says "User has been removed". I have verified that this person is active in the app's user list. Has anyone else seen this behavior and if so how was it resolved?
Hello, I need to have three date fields Sunday dateDeparture Date Arrival DateI need a checkbox to be true if the Sunday date is within the Arrival and Departure even if Arrival or departure is null.And False if the Sunday date is prior to Arrival or after DepartureAny thoughts on the formula? Thanks,Tara------------------------------Tara Stroup------------------------------
The conundrum I'm having is how can we highlight just a cell that triggers a Color-Coding situation.if(Contains(toText(<any Field at all>),"??", "#FF0000)We want to implement a rule like this for a report... for every field, and ideally only highlighting the cell/field that has the ?? in it.Is there anyway to do this, besides having a custom rich text field copy of the text field with a <div> around it and using case for background-color... or Code Page IOL that parses the entire page?------------------------------Ryan Stanford------------------------------
Hello:My current formula-numeric field returns null, instead of 0.How could I tweak the formula below to return 0? Please note:A. The numeric fields below have the "treat blank values as ''0' in calculations" enabled:GPA - Associate DegreeGPA - Bachelor's DegreeB. The Primary Program Name and Secondary Program Name are text fields.*********************************************************var number AssociatesDegreeScore = If([GPA - Associate Degree]>=3.3, 2);var number BachelorsDegreeScore = If([GPA - Bachelor's Degree]>=3.3, 3);var number FinalScore = If( not IsNull([GPA - Bachelor's Degree]), $BachelorsDegreeScore, not IsNull([GPA - Associate Degree]), $AssociatesDegreeScore, 0);If([Primary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)" or [Secondary Program Name]="Nursing, Associate Degree - LPN to ADN Option (A45110L)", $FinalScore)*1.5*********************************************************Thank you,Roula
We have 300+ client orgs with multiple users of our QB realm per org and need to ensure only authorized users access the system. We know that across our 3000+ users, there are some who are no longer with their organizations but yet still have access since the password is managed by QB. In the long term we're going to be moving to using Okta and integrating with our partner org IDPs. But for now I want to know if there is a way to use the QB API to download reports of users automatically and send those out to the client orgs on a periodic basis so that old users can be removed. Maybe starting with this call: https://developer.quickbase.com/operation/getUsers And then iterating. Is this feasible? Any other ideas for managing users from so many different external orgs?
Is there a way to have a field calculate and display time and half pay from an hourly base pay field?
Hello, I have created a new App that will service multiple departments and a bunch of Users. The issue i am running into deals with the fact that not all users have individual QuicBase accounts. Older accounts use the company login ID as the QuickBase UserName. The newer accounts fall under an Enterprise license and they show up as the company email, not their ID when using a User field in QuickBase. During initial testing we did not realize this was going to be an issue. I created Form Rules that would check against the Current User and make sure the ID they selected matches on their entry Form. If it didn't match the Prevent Save would kick in. I was also able to use similar logic in Report criteria to limit records visible to the ones created specifically by that person. So now that we have broadened our testing participants we are seeing issues because some individuals show up as an email address when I am trying to compare back against the ID. I tried using the ToUser() on the ema
Is there a way to view the table of the trigger step in the list of pipelines, or an export of the list of pipelines showing this info? I would like to get a count of # of pipelines by trigger table, as there is a limit of 90 pipelines per table and there is no easy way that I see how many pipelines I have per table now. I just know this when I hit 90 and that does not help me plan for the future.------------------------------Rick Miller, Trinity------------------------------
I am trying to build an app that will keep track of attendance by name based on the selected location of the plant. Ideally there is just a multiple-choice field at the beginning of the tracker of the area of the plant, and that will populate the list of names associated with that area. From there, each name would have a checkbox associated with it to designate that person was in attendance. If possible I would want there to be some way to show the attendance percentage of each person as well.I was thinking having the list of names associated with each area in a separate table. Then each person that populates in the tracker form would have an associated check box as a separate field (unless there was a way to make that one field). The issue that I see with that is there isn't really tracking by person that I could figure out, and if you change that list in the separate table then that changes past records of the tracker, which could be an issue.Any help or tips with this would be great
Hello Everyone,I have created an API button, but I keep getting an update_id error. Can someone please help me understand what this error means so I can fix it? Thank you -Bart<qdbapi><action>API_AddRecord</action><errcode>0</errcode><errtext>No error</errtext><rid>26238</rid><update_id>1731629328550</update_id></qdbapi>
I'm working on a formula to concatenate values from multiple multi-select text fields while removing any duplicates in the output. My goal is to create a unique, semicolon-delimited list that’s easy to process further. Here’s a breakdown of the fields I’m working with:[Related Modification - Operator Access][Related Project - Operator Access][Related Phase - Operator Access][Note Replying To - Operator Access][Related User - Affiliation]Quickbase’s formula language doesn’t support loops, assignments, or a direct Unique() function to filter out duplicates. Here are some of the approaches I’ve tried:Using Conditional If StatementsI set up If statements that check each field’s value with Contains to see if it’s already present in the accumulating list. While this approach works in theory, I have been having trouble with type and syntax errors. It also quickly becomes verbose and difficult to maintain as the list of fields grows.var text initialList = ToText([Related Modification - Operato
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.