Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,I have a user (using same email ID) which is part of two roles:User --- Role ----- ProjectsUser1 --- Officers ----- Project1User1 --- Managers. ----- Project2Both Project1 and Project2 are parts of the same app. The user1 in the 'Officer' role for Project1, and in 'Managers' role in Project2. When I login as User1, I should only have limited access to Project1 data, but when I login as User2, then I should have access to many columns and rows in the Project2. Is there a way that I allow user to choose which role he/she is using while logging in?I know the role in the top of the order (App Settings...) gets precedence, but I want user to decide on the role while logging in.Your thoughts will be highly appreciated.------------------------------Hameed------------------------------
Hi,I'm spending to much of the morning trying to understand how folks have done this.I use the following formula to 'Submit' our forms and redirect users to a 'Thank You' page:URLRoot() & "db/" & AppID() &"?a=ShowPage&PageID=2&ifv=1"I've been watching Quickbase Junkie's online guides for classes, but they don't make the buttons actually larger.I've found one older thread on here recommending using Get Bootstrap Buttons: https://getbootstrap.com/docs/4.0/components/buttons/But I don't understand how to work their class code into a formula that won't generate syntax errors.This is likely due to my inexperience with writing formulas in Quickbase, but my director specifically requested I make the 'Submit' buttons bigger, with larger font. Can anyone help point me in the right direction here?Thank you!Jen------------------------------Jennifer Juhasz------------------------------
Hi all, hoping this is an easy question. It feels like the answer should be easy, but I can't figure it out.Put simply: I have an App where an Employee has many Cases. Each Case has a Drop Down field that is either A or B, with another drop down field called Status which is either Open or Closed. I'm Trying to create a report to show Employees who have an Open A Case, and an Open B Case. Appreciate this community's help.------------------------------Troy ------------------------------
I have a Parent Table (Projects) that has numerous Child Tables. The Primary nucleus for Project Editing and Viewing is a detailed Project Main form that has embedded children tables (for viewing) and appropriate editing of children tables from the launch point of the parent table.Editors of the Project Table (Project Managers and Portfolio Managers) should be presented with Save & Close and Save & Keep Working. They should NOT be presented with Save & Next since the "next" Project Record is entirely irrelevant to the PM or Portfolio Lead. In between updating a single project record, they would return to a dashboard and select the next project to work on based on actionable items on their dashboard or based on the project updates that are working next per meeting schedule. How do I turn OFF Save & Next?------------------------------Annetta Coleman------------------------------
I have ~170 active Projects (parent table) that each provide a weekly status reports that are contained in a Status (child) table . Two questions:1) What formula fields would I create in the Status Table so that I can filter by:- Most recent reports (for each project)- Reports submitted in the past weekly reporting period (for each project)2) From the Stakeholder dashboard that dynamically filters projects, how do I associate the filtered projects (parent) to the most recent status reports (child table) for those filtered projects (parent table)? ------------------------------Annetta Coleman------------------------------
Hi all, I am trying to update the project record with the most recent comments from the task. I have 2 tables, Projects (parent) and Tasks (child). I would like to populate a most recent comments field from the Tasks table to the Projects table. Any advice is greatly appreciated! ------------------------------Candace GregoryNew but eager to learn------------------------------
Hopefully there is a simple answer to this question.....I need to order Pie Chart and Funnel Charts Labels in a fashion other than alphabetic by label or value of the segment.Example: Five Project Phases: Initiating, Planning, Executing, Delivering, Closing. Labels on these charts need to progress in that specific order of labels. Neither alphabetic by label of value of the contents with the series segment 'tell' the story needed. How do I order the segments on these charts by a custom order sequence of labels?Thanks!------------------------------Annetta Coleman------------------------------
In our Project Management app we have a Multi-Select field to identify the various "Value Chain" teams that are impacted by the project. This works as intended for notifications and dashboard views. We also have one use case where we need to target projects that affect only our "Clinical" value chain and no others. I currently have a formula checkbox that 'technically' works via a deeply nested IF statement, but is not very elegant. I am seeking a more elegant conditional statement for my formula checkbox that basically says 'If Clinical is the ONLY value selected in BUSINESS IMPACTS (a multi-select field) then this formula checkbox is checked'.How would you code this?------------------------------Annetta Coleman------------------------------
I am creating a Pie Chart, I want to display the sum of all slices of the pie chart onto the chart or as a separate slice.------------------------------Del------------------------------
Looking to have a field on a form that can accept an entered fraction 1/8, a percent entered as 25%, Decimal .05 or an integer and have it display as a decimal in any case. Do I create a separate formula field?------------------------------Del------------------------------
Hey,Any help would be greatly appreciated. I am just getting started and was working through the basic training. When I got to the last training video to set up your dashboard I deleted all the practice data by accident. I have no idea how to restore the data so I can continue training up and experimenting. LOL no back button to restore? I am also getting some weird alerts that my data is exposed to the entire internet...What should do?Newbie Betty------------------------------Betty Toto------------------------------
Hi Comunity, I created a Rich Text field that I succeed in adding a record using QR code with API_AddRecord call the challenge that I have is when I scanned it, save the new record but is not redirect to (var text redirect=URLRoot()&"db/"&Dbid()&"?a=q&qid=6";) and does not link all fid list it on. see below my Rich text fieldvar text redirect=URLRoot()&"db/"&Dbid()&"?a=q&qid=6"; var text ADD = URLRoot() &"db/"& [_DBID_SCANS] &"?a=API_AddRecord"&"&_fid_6="&[Student ID] &"&_fid_9="&URLEncode("In-Person")&"&_fid_22="&URLEncode((ToTimeOfDay(Now())));"<img src=\"http://chart.apis.google.com/chart?chs=100x100&cht=qr&chld=|0&chl="&$ADD& "&NextURL=" & URLEncode($Redirect)& "\"\"/>"I have the same button but with url field type and it works perfectly I tried to find a code page but I did not succeed, I will appreciate any help.------------------------------
Hello,I need to copy all the records that are imported in a connected table to another table. I tried using Webhooks but they don't get triggered when all the records are imported.Is there a way to trigger the Webhooks, or is there an API button I can create that will copy all the records? Thank you in advance.Dusan------------------------------Dusan Djordjevic------------------------------
I have a table with an Invoice # field (numeric) - how can I find the highest Invoice # using a formula?Thanks------------------------------Matt Hardy------------------------------
Need help calculating IRR and discounted payback period for a series of cashflows. Wondering why we cannot have inbuilt functions like we have for PV. Thanks.
I have a Project Status Report that pulls from two different sources (Business Project Manager & IT Project Manager). The problem we are trying to solve is to produce and Online Status Report that will enable us to abandon our historical PowerPoint '4 Blocker' status reports. Stakeholders (including executives) who have QuickBase access will view online. Stakeholders who do not desire QuickBase access will be able to view a pdf version of the Status Report via eMail attachment or pull it from a shared drive. The online Status Report form works as intended. The print as pdf version has two problems. 1) It loses the background shading of the Red / Yellow / Green Health Status field (a formula rich text field) and2) The field label wraps as if it is compressed horizontally (see attached pic which shows a screen print of the form and also a screen print of the pdf)What do I need to do to get the pdf version to disp
Hello,I'm tracking how long it takes on average for me to receive documents from an outsourced department. I currently have a submission date, and a received date.I have a formula to calculate how many days until I received my documents in a Formula - Numeric field. The formula is:ToDays([Permit Received Date] -[Permit Submission Date])I'm trying to have this fill in the number of days from the permit submission date to the current day [ toady() ] if Permit Received Date is blank. I haven't found the method to communicate "if blank, then x"Can someone support?Thank You so much.------------------------------Anthony Wong------------------------------
Hi thereI have a table of financial values called [Role-based Limits] which are unique based on two fields - [role]&[region]=[value]A user can add more than one [value] based on [role] and [region] by adding a new effective date. So, a unique value would be [effective date]&[role]&[region]In a second table called [Authority Limits] I have employee data. There is a relationship (1 authority limit to many Role-based Limits)In [Authority Limits] table I also have [role] and [region] fields. What I want to do, is when role and region are populated in [Authority Limits], the latest [effective date] and associated [value] fields are populated from the [Role-based Limits] table.I do have a look-up field for the [value] in the [Authority Limits] table, but this is just a dropdown of all of them. How do I do this??------------------------------JemmaData Analysis & Visualisation United Kingdom------------------------------
- I have a child table (Tasks) grid edit report (grouped by Phases) that is embedded on a Parent (Projects) Main Form. The full version of the child table grid edit report is available from the parent main form also.- The phase headers on the Full Report are collapsible by group (Phase) The picture attached show ALL since this is coming from the embedded report, but the FULL report is grouped by phase. The phase headers naturally demonstrate total for the group (Red Boundary in upper right of attached .jpg)- I created Report Formula to calculate the # tasks complete. I also created a Report Formula for Total Count but do not need this Report Formula because the total is already provided inherently. I added these two columns to the grid edit report (Yellow hashed boundary in upper right of attached .jpg)My problem: I would like to be able to display the # of Completed Tasks (from the Report Formula) in the Header Row for the Group (Phase) so that I can display "# complete" of n tasks. (
We have a table structure as follows:(Job) is a parent to both (Phase Codes) and (Estimates). (Estimates) and (Phase Codes) can both have many (Estimate-Phase) records. After a minimum of one (Estimate-Phase) child record exists on an (Estimate), it appears in an embedded table report on the (Estimate) form view. The form view has the native add record button to create additional (Estimate-Phase) records which is the current default practice for this workflow. However, we also want users to be able to create new child (Estimate-Phase) records directly from the embedded table in grid-edit mode.[Phase Code] is set up as a conditional lookup on [Job (Est)] with a custom record picker. This works as expected in form view on the (Estimate-Phases) table.However, in grid-edit mode the user is unable to select a [Phase Code] from the dropdown list, even though the parent (Estimate) has been filled in on the next table row and [Job (Est)] is displaying the related (Job)
We have a Project Table that has numerous Children Tables including Tasks. The Task Table rows are populated from a Task Master because each project is required to have the same ~50 tasks organized by sequence within 5 Phases. Although the Project Managers have the ability to add additional subtasks on their project plans in Microsoft Project, they are not allowed to add new tasks or phases or re-order these tasks in QuickBase. (Stakeholders view task status, milestones completed and timelines in QuickBase so the QB view is a dashboard of the corporate standard.) The Project Managers can easily update the Task rows from a Grid/Edit report. Opening up the Task Main Form is both confusing and unnecessary for PMs and for Stakeholders since literally everything they need to edit or view is on the Grid/Edit report. We removed access to the Task Table from the Project Form, but some users are still going to the Task Form via the pencil an
I currently have this Rich Text formula field that displays a file in a field. "<a href='"& URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e81/v0' target='_blank' >" & [Attach Disclosure] & "</a>"How can I have the field appear as the text "File" instead of the actual name of the file?------------------------------George Bramhall------------------------------
Hi!I need a button to create an "authorization" from an existing form to a new authorization form\. I have both forms built so only the necessary info is displayed.I would also like to have the status field changed (1st form) automatically when I use the button to create the authorization, and display the record to print or even email.Am I crazy or is this doable thru a URL formula?Any help is awesome!!Kelly------------------------------Kelly Lyons------------------------------
Is there a way to find records in a table that have orphaned, red text multiple choice options? In the example below, the records have a multiple-choice option that no longer exists. (To be clear, I'm not looking to identify only records with red "Third Party Governance." There are plenty more records in the table that have orphaned records. I need to find all of them.)Any help would be appreciated. Thank you!------------------------------Tom------------------------------
I'm baffled, I set up an automation on a table to add a record when a record in another table gets modified. The record is added but it has my name instead of the person who modified the original record. How do I capture the person's name who modified the record instead of mine? (person who created the app).Example: Record is Table 1 is edited by a user, (Last Edited By: captures My Name) / Table 2 adds the record which was edited, but has (Last Edited By: My Name) instead of user who edited record in Table 1, which is what I want to capture. I think the automation is the culprit, but not quite sure.Thanks for any input!------------------------------William Wallace Fleet Operations SpecialistMotional------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.