Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am trying to write a formula that provides a number of weekend days in a span of a start to end date. e.g from 4/1/2023 to 4/23/2023 there are 8 weekend days. I want a formula that solves this for any Start and End date.------------------------------George Bramhall------------------------------
If I have a table in App A, is there a way to find all of it's relationships? Meaning, if it has a cross app relationship, where the table in App B is the child, you don't see the relationship from the parent. Do I have to manually go through every table that could potentially be a child table, and look at the relationships? Or is there some sneaky way for me to find all the child tables of a cross app relationship?------------------------------Mike Tamoush------------------------------
I would very much like to kick off a pipeline from a couple of formula fields.... Use case: - Business Requester creates an new Request in Work Item parent table- Pipeline creates review records for each new request for each Product Team in child table.- Pipeline creates notifications to Product Team member(s) to review the new Request- When all Product Teams have completed their review, summary fields are updated in the parent table. - A formula checkbox in the parent table confirms that all product teams have completed their review. Another formula checkbox field confirms if the work item is above the threshold that requires leadership to review and approve at their next scheduled meeting.- We want the next step to be a Pipeline based on the two formula checkboxes to create an agenda item in the Leader Review child table for each work item that needs their approval. This will enable leaders to pre-review / pre-vote at a time convenient f
Greetings,I had a formula URL in (let's call it) Table1 that adds a record to Table2 and then redirects to a corresponding record in Table3. Table2 and Table3 are setup for EOTI so users who are not signed in can utilize the URL in question. This was working perfectly fine until a few hours ago when I made changes. I added a couple of fields to Table2 and expanded the formula URL to accommodate them. Also, I updated how the formula was built to use a condition to determine whether or not to use API_AddRecord vs API_GenAddRecordForm. Now, the resulting URL only works when I am signed in. I confirmed that Table2 and Table3 can still be seen without being signed in but, when I try the resulting formula URL it just takes me to a Google search for the URL itself. I tried with the AddRecord URL and the GenAddRecordForm URL. Again, they both work as designed when I am signed in but Google comes up for both when I am not signed in.Any input on what happened and how to a
Greetings,Is it possible to setup a formula URL that will edit an existing record and populate one field with whatever value is in another field in the same record? I am having recipients of a notification receive a bar code. I want to track how many times the bar code is used. Looks like I can't just simply increment a field's value with an API call so, I am thinking I have to use a field to hold the calculated incremented value. I'm stuck at this point though because, if the same bar code is used multiple times, I don't have a way to have the newly incremented value utilized in the URL.Let me know if I need to be more descriptive in order to assist, assuming what I am trying to do can be accomplished. Thanks in advance for any input / suggestions.------------------------------James Carr------------------------------
Hello! I am trying to figure out if there is a simple way to get a QuickBase formula field to generate a random string of characters (ideally 15-20 characters in length) once and then use that as a value to base the tables record ID off of. Does anyone more versed in QuickBase have any thoughts on how I would do this? ------------------------------Melissa Hale------------------------------
Hi,My users want a button to pre-populate some Rich Text fields. Here is my solution:URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxx&rid=" & [Record ID#]& "&_fid_202=<pre>project management of included scope | shop drawings (+1 revision) | material | fabrication | finishing + sample (+ 2 revisions) | delivery | installation</pre>&_fid_203=<pre>general</br> exterior work | metalwork | stonework | electrical work | plumbing | structural work (wood or metal) | finish carpentry (siding, jambs, etc) | decorative hardware, hooks, and accessories | upholstery | appliance supply and install | non-wood countertops | metal cabinets | glass supply and install | mirror supply and install | passage doors | pocket doors | track hardware | grommet supply | art rails | standalone furniture | access panels not shown in drawing set | building permits</br>specific</br> tbd</pre>&_fid_204=<
Hello,For our system, people get email notifications as proof of their "confirmed reservations". Our reservationist is concerned that people are able to forward the confirmation email to someone else, and when forwarding, they have the ability to edit fields in the embedded report, such as the date field, in order to come up with a reservation with a "spoofed" date. I have tried, in dynamic form rules, setting everything to "read only" for the embedded report that gets sent out with the email, but the recipient is still able to edit the fields on the embedded form when they forward the email to someone else. Is there any way to prevent the recipient from modifying the text in the fields when attempting to forward the email to someone else?------------------------------Coleman DuCharme------------------------------
Is there any tricks to be able to make a formula rich text button 'fill the mobile' screen (width) like a formula URL button does? Is there any sneaky CSS that somehow is 'maximum width' or anything clever?------------------------------Mike Tamoush------------------------------
I have a generic 'Contacts' table that is a child table to both a 'Company' table and also to a 'Customer' table. In then have an 'Issues' table where I want to use a relationship to 'Contacts' to select the Issue Owner (thus 'Contacts' is the parent table to 'Issues') . 'Issues' is also a child table to 'Customers' (Full Diagram below)When creating a new issue record, I'd like the Owner (Contact) dropdown to contain all of the contacts related to Company A + the contacts related to the Issues related customer.I'm familiar with the conditional dropdown concept but can't wrap my head around how it might support this type of query (e.g. contacts related to Company A AND contacts related to the Issue's related customer)Hoping I'm just overthinking it. Appreciate any help. ------------------------------Jennason Quick Base Admin------------------------------
Greetings everyone! A few announcements and a call to action...1. April Release Notes became available this past Sunday, have you had a chance to check them out? Quickbase released its Snowflake and Gmail Channels in April.2. We've got a Feature Focus webinar with everyone's favorite CSM duo, Manny and Kiko, one week from today on April 27th, make sure to register! Formula Queries, Copy Record Steps in Pipelines, and other Pipelines upgrades will be the focus for this webinar.3. Do you have a question about these specific features, or others from the April or March release, that you want answered in the Feature Focus? Post it in this discussion and we'll do our best to get these answered. Thanks all! Ben SimonSenior Community Engagement ManagerQuickbase
There may be a simple answer to this question, but for the life of me I cannot figure it out. When setting up a dynamic rule to display a message when the conditions are met. Is there way for the message to have a field value included? I would like it to be like this: Field: [Skipped Stations] Value: "Station 3" Message: "Cannot Complete. Station 3 needs to be completed first." Instead, it's this: Is there a way for me to get it to display the value of a field in the message? ------------------------------Kaitlyn Stanley------------------------------
I have a client that is asking for a transaction log for the workflow I am building out showing the username, action taken, and date-time stamp for all decisions and other changes made as the workflow progress. They would like this log to be reportable and able to be queried. My first thought is to create a separate table for this and have a pipeline set up to capture this info in the new table, but I am wondering if there are other ways to do this?------------------------------Chris Swirtz------------------------------
Here is my situation: I have installers in the field who upload completion photos to a "photos" table. The project managers in the office need to be able to download these photos to our network. Is there an easy way to download them all at once? I tried a pipeline, but it looked like the only option for file attachments was to upload them.Thanks!------------------------------Allison Watson------------------------------
I don't see it in the Audit Log feature. Is there any way I can tell which report was accessed by the user versus the generic "a report was accessed in Poles table"?
I have a Customer record with first payment date, last payment date, term (number of months) and monthly payment amount fields. I would like to create a report that tells me the projected revenue from all payments for each month of the next 12 months. Is this possible?------------------------------Jim Boozer------------------------------
Hello. I use quickbase to track contract request. There are a few different types and based off the type we have a target to get them sent out in. So I have a Received Date Field and a Date Issued Field. I need a formula to tell me if a certain type of request (New Supplier, Existing) was issued with in 4 days, another to tell me if a different type of request (Bidder) was issued in 2 days, and one to tell me if another type of request (Convo) was issued in 2 days. I can figure out how to get a field at the end of my table that says how many days is between the received date and the issued date but I am struggling to determine how to get it to mark if it hit the target based of the request type. ------------------------------Kirstynn Rowe------------------------------
A specifc Form is set to be opened from a calendar report but goes to the table's default form when the calendar report is placed on a Dashboard. Anyone else notice this. Any work around?------------------------------George Bramhall------------------------------
I know in the search bar for a report, you can use the OR operator or AND operator when searching. Are there any other operators that work, and if so is there a list somewhere? Particularly something like NOT CONTAINS or NOT EQUAL. Something where someone can search by excluding a word?------------------------------Mike Tamoush------------------------------
Hello! I have a table includes has three fields that I am trying to report on. The fields are Text - Multiple Choice. The 3 fields include all of the same information but for different request. They hold the type of Contract that is sent to the supplier in that row. I am trying to report on how many of each type of contract gets sent. Is this possible? ------------------------------Kirstynn Rowe------------------------------
Short Version: When uploading a file attachment via the Quickbase API: the Base64 content should be on a continuous line and not contain any Carriage Returns or Line Feeds / aka CRLF (ASCII Character 13) and LF (ASCII Character 10). You may need to filter out these characters from your Base64 attachment to generate this result. Long Version: Just wanted to post this here, as I spent an entire day trying to upload an image into Quickbase via the API. The response showed that the transfer was completed, but when I went to view the resulting URL, all I saw was a white square on a black background. I opened a support ticket, where the QB tech verified that our XML request was correct and stated that he did some tests without issue, noting "My image uploaded when the string was all on the same line." The solution, my Base64 encoded file needs to be on a SINGLE LINE! It would have been helpful in the API Docs, that it is more clearly stated that Base64 text is supposed to be on the SAME LINE
Old threads show ways to make a formula/url or rich text that emulates the cancel button, but it involves using javascript. Is there any current way to make a custom cancel button?My use case involves needing it for mobile. I have a custom save button that does more than just save, and so I want a custom cancel button next to it (I currently have a big warning telling the user not to use the native buttons below, since I cant get rid of them).I tried just making a button to navigate away from the page - the problem is it autosaves no matter what. I want it to NOT save. I believe the advanced option to save when navigating away from the page, does not have any effect on mobile, so I cant simply uncheck it.------------------------------Mike Tamoush------------------------------
I know using a bulk record upsert is a more efficient way to add or modify records using pipelines. Is there a best practice when deleting? Or just use the search function, and then a for each loop?------------------------------Mike Tamoush------------------------------
Hi I know there is a Map report that can chart out locations if you have an address, however, I have a need for counts per state where I only have a state abbreviation. I envision a Map with a numerical count per state abbreviation . I don't believe anything like that currently exits? Can I throw this in the suggestion bucket please! Thank youBarb------------------------------Barbara Alvarez------------------------------
I am having issue with uploading a PDF file attachment using quickbase API.I have already converted the PDF File to base 64. After the record gets updated in quickbase, I get an error whenever i try to download the file.Sample API CallHeaders:Content-Type: application/xmlQUICKBASE-ACTION: API_EditRecordBody:<qdbapi> <apptoken>app_token</apptoken> <ticket>ticket</ticket> <rid>30</rid> <field fid="80" filename="test.pdf"> BASE 64 ENCODED STRING OF THE PDF FILE </field></qdbapi>What is wrong with base64 for PDF file attachments in quickbase using the API or are there specific files that quickbase can be able to decode correctly.Or if there is another alternative approach. ThanksFYI, I am currently using a Restlet Client - REST API Testing to do the testing to ensure the api works well, before diving in to code in any language
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.