Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I have a timecard app and I would like to create a report that displays a yes or no if a timecard was completed for each week day. The report would show all employees. Is this possible? Or can something similar be achieved? Additionally I would also like to show a month total completion number such as 23/30 days completed.EmployeeMonTuesWedThursFriMonth TotalNameyesnoyesnoyes25/30Nameyesyesyesyesyes30/30Nameyesnoyesyesyes15/30
Hi,Is there a way I can add child record(s) when adding a parent record through a single form? I am trying to collect general info in the parent form and then have the ability to click a button to add a selected data source into the child table. Once that data source is added, it should automatically redirect me back to the parent form in edit mode as I left it and I should be able to add as many data sources as I want. I tried using a formula button which I found in the exchange, however, it only works as intended when editing a parent record. It doesn't work when adding a parent record because the record ID hasn't been created yet so it can't redirect back to the parent form in edit mode. Here is the code in the formula URL button that I currently use in the form to add a child record:var text redirect=URLRoot()&"db/"&Dbid()&"?a=er&rid="&[Record ID#]; // REDIRECT TO THE FORM IN EDITvar text url = URLRoot() & "db/" & [_DBID_PROVIDER_DETAILS] & "?a=
Has anyone experienced issue with downloading an app for use in offline mode on a mobile device. I am able to download Magic Buttons for example, but the app I really need gives an error message when I try to download this. Message is basically download failed, contact app admin. Are there limitations or app settings that are causing this issue?
Greetings,I have downloaded a publicly available spreadsheet from the FDA containing their warning letters and have imported into quickbase. It has worked well but I am stumped on how to do the following. Under their "subject" column, they list multiple causes for the warning letter. I have been able to convert those causes to different text columns because they are delimited with "/". However, what I think really would like to do is to create a checklist of all causes and then associate that back to the record. That way, I think, it will be easier for me to analyze and report the occurrence of the causes. In case it matters, the order of the causes is not always the same.The column in question (in the form in which it is downloaded) looks like this:SubjectCGMP/QSR/Medical Devices/PMA/Adulterated/MisbrandedCGMP/QSR/Medical Devices/Adulterated/MisbrandedMedical Device Reporting/Misbranded I presume it needs some sort of formula so I have tag
Is there a way for non-admin users in Quickbase to filter a report using a formula? I have stakeholders who are looking to streamline their workflow. They need to filter down to specific, unique IDs that require changes. Instead of creating individual filters for each ID, is there a method for them to view all these IDs in a single report?
Seeking direction/information on setting the tab order of fields on forms. I'm not talking about page or section Tabs, but the order in which fields are accessed when pressing the "tab" key on a keyboard. I have a form that has over 30 fields, but only 5-6 are editable (the others are reference fields from other locations to provide detail to the user). When adding or editing new records users must "tab" through a dozen or so fields before they arrive at the 1st field they actually need/can insert data.In old MS Access db world, I would just set those reference fields as having no "tab stop" so it would be passed over when doing data entry. Is there something similar in QB new forms I could set to achieve this same feature? I understand I could just rearrange my editable fields to be at the top of the form, but then I lose the added context by rearranging the fields just to make data entry easier. I also know I can not show those reference fields during add/edit mode, but again, I lose
is there a way to remove several members from a user group instead of clicking the remove button one by one?group has 4200 members and I need to remove about 1000
Hello, When a table becomes too large, it changes the report home page to look like this by default:Is there a way to mimic this and create this report for a table that is brand new?
I have a pipeline that is supposed to export a table to a csv and send the csv as an attachment in an email. I put the file handle as the URL for the email but it does not send an attachment in the email that gets sent. Is there anyway to send out the csv using the file handle? I only have access to the Quickbase and Gmail channels.
I would like to create a form rule using the native Record ID field. I am not seeing it in my drop down list of available fields on the legacy form version. Is it available to be used in a form rule?Thanks, Brian
I am fairly new to quickbase and got the hang of it somewhat to make reports, dashboards, etc. I ran into a hiccup on a table that a peer would like to see data on. The data has a total at the bottom for total "Invoice Amount" (each record is a job with a invoiced amount), then each record also has a "Total Hrs" where the total amount of hours that job took). Then a grand total of all the rows for Invoice Amount and Total Hrs. I wanted to make a simple calculation for a running rate where it divided the Invoice Amount / Total Hrs and put it in a widget on a dashboard. I attempted adding a new field/column in the existing table and it takes the total from the given table all together and divide and spit that value into that field. However, this only did the calculation by row - not take the grand total of all the records/whole table itself.
All,I have built a rich text field that when clicked displays the record for the end user. I have loaded images up into an attachment field. I have set the versions to "0" to always pull the most recent image, but it is not working. Can someone look at my rich text formula and see what I am doing wrong? (appp token hidden). var text pix = URLRoot() & "up/" & Dbid( )& "/a/r" & [Record ID#] & "/e35/v0";"<a href=" & URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#] & "&apptoken=&xxxxxxxxxxx" & URLEncode($pix) & "' height='100' target='_blank'><img src='" & $pix & "' height='100'/></a>"I have attached a screen shot. Image is the rich text field where the above is at and Picture is the file attachment and yes, my fied id for the file attachement is 35. Thoughts?
Hello, I am currently building a webhook when a Employee Role field is modified. I was wondering how do I carry over the old value of this field in the message body in JSON formatting as I already have the new modified value carried over? Thanks
I am having a strange problem that I never encountered before.On Parent form, I have a report link to Child Records.When I choose the option "Display just a link to the related children," I get a correct report.However, when I choose the option "Display the related children directly on the form," the report is empty.Why would this happen?
Hi, I have some buttons using similar code as below, where I have formula URL/formula rich text buttons with the "OpenAsPop-Up" parameters, as well as the auto refresh "data-refresh=true" parameter, which refreshes the parent record once the user closes the pop-up window. How can I modify the below to auto-close the pop-up window when the child record being added from it is saved? This is essentially just saving 1 click of the user having to manually close the pop-up window on their own. Code snippet from formula URL: "<a class='Vibrant Success OpenAsPopup' data-height=600 data-width=850 data-refresh=true href='" & URLRoot() & "db/bsud3tnnt?a=API_GenAddRecordForm&_fid_1027=" & URLEncode ([Record ID#])& "&z=" & Rurl() & "'>Add Timecard</a>"code snippet from formula rich text: "<a class='OpenAsPopup' style='text-decoration:none;' data-height=600 data-width=850 data-refresh=true href='" & URLRoot() & "db/" & [_DBID_CLAIM_INFO
The horizontal scrollbars are not visible in any of my report to scroll through the report data to the right. Why is this happening?
Hello everyone! I am hoping someone may be able to assist me with this issue.I have a role that prevents users from editing a record once the status of the record has changed to "Closed". However, there are instances where I want to allow the user to edit certain aspects of the record. I would do this by creating a button that would show up for the user based on certain conditions that I set.The issue, naturally, is that even though I can display the button for them, they still cannot edit the record due to the restrictive conditions of the role. They get the "Access Needed" message.Is there a way to override user's roles, and maybe use Administrator access, in a URL button so that users who see the button can click it and edit the record?Thank you in advance for your input!
Have you ever had the need to send an email that includes the result of a list in the body (even with HTML format)? Let me help you. marbentor@gmail.comThank youMarcelo Benavides Torres
Hi everyone, I have a formula url with the following code: "mailto:" & [External Email Addresses] & "?subject=" & URLEncode([Email Subject]) & "&body=" & URLEncode([Email Body]) & "&cc=" & URLEncode([Internal Email List]) The Email Body field is Rich Text Field in Quick Base. When I click on the button with sample data I get the results on the two screenshots included. Any ideas on how to prevent the html from showing? ------------------------------Ivan Weiss------------------------------
Is there any way for a formula field to check either one of the following:1. If a user has access to the app2. If a user is part of a user groupI have an employee list that automatically imports (synced to box). If an employee is suddenly inactive, I need to know to deny them as a user and remove them from the user group. I possibly can have a notification sent when a user is marked inactive, but I am not sure if notifications fire that way (from a sync)? It would also need to be a multi change message since a lot will be marked inactive at once. I would rather just have a subscription where it looked if a user was marked inactive, but has access to the app.------------------------------Mike Tamoush------------------------------
Can we combine a Formula - List-User field with a List-User field? I'd like to use the field as the 'Notify Whom' value in notifications and avoid creating a set of notifications for each field.Thanks!------------------------------Heather Bryant------------------------------
Struggling with the correct formula syntax to evaluate the value in a field for color coding. I have a % field that can calculate to either a positive or negative number. I have a separate field that I am using to display a color depending on that % value. I'd like for the color field to show as green if the % is between 15% and -15%, if the % is outside this range (above 15% or below -15%) to show as red.This is the formula I've created thus far (using responses from other discussions), but nothing is displayed.If([Land % Change]>0.15,"<span style='background-color:red;'></span>",If([Land % Change]<-0.15,"<span style='background-color:red;'></span>","<span style='background-color:green;'></span>"))I even tried reversing the "<" and ">" but still nothing shows up.
I have a table to track parcel values. Each parcel will/can have 1 record for each year. I am trying to calculate the percent change for each parcel between years. I have the following fields:Parcel # - look up from another tableCurrent Year - number field to enter yearPrevious Year - formula field to calculate previous yearCY Key - formula field to combine Parcel # and Current YearPY Key - formula field to combine Parcel # and Previous YearValue - numeric field to enter parcel value for the yearPY Value - formula field that returns the Value of the record where the CY Key equals the PY KeyI'm trying to create a % Change field formula: ((PY Value-Value)/PY Value)*100The issue is, I think, the field types. The "Key" formula fields are Text fields, but the values I want to return are/should be numeric. So my formula for the PY Value is:ToText(GetFieldValues(GetRecords("{143.EX.'"&[PY Key]&"'}"), 11)).This formula correctly returns the PY Value (yay), but it is in a text field typ
I noticed when an outside user submits a QB form via mobile, it asks them to sign in instead of giving them confirmation that their entry was submitted. The submission confirmation shows up on the PC browser but not on mobile.The entry shows up on the back end as expected but this could be confusing to outside entities submitting an entry.
Hello everyone :) Thank you for the engagement during our last meetup around, and I hope you're all making the most of summer!We're looking forward to our next Women's Qrew meet up on Tuesday, August 20th from 1-2PM EST. The registration link is live on the https://www.quickbase.com/events, so if you haven't had the chance to register, please do so here!During the meetup, we'll bring along some seasoned vets to the Qrew as well as members of the Quickbase product team to talk through Pipeline road map, best practices, tips and tricks and some live Q&A. Feel free to start a thread of some of the main Pipelines questions/topics you would want to learn about during the session!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.