Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm creating a pipeline to dispatch FastField forms and I'm getting an error message regarding the headers. Has anyone else used Quickbase to dispatch FastField Forms?------------------------------Paul Peterson------------------------------
I am trying to create a daily batch pipeline. It should able to send data from QB Table to Azure Storage (Blob). I tried API but I am not able to fetch all records. Then I looked into QB pipelines I didn't see Azure Connector.------------------------------Uday Juttu------------------------------
Hello AllI am trying to get Multiple Attachment Uploads to work in my quickbase app. Anyone got a few minutes to help me out. I selected the files that I wanted saved and it doesn't go to the child table I created.Please help------------------------------Justin Holl------------------------------
Constructing a Formula Query to auto-number payments that are part of the same Stripe Subscription. All of the payment records are in the Trans.Donations table. [Stripe Subscription ID] is the identifier for the subscription. So, we first want all of the Trans.Donations records that are part of the same subscription. [Stripe Subscription ID] is field 96.Nextt, we want to find the records that are AFTER the current Trans.Donations record. This uses the field which is field 24.This is the definition in the Formula Numeric Field on the Trans.Donations table:var text QUERY = "{96.EX.'"&[Stripe Subscription ID]&"'}AND{24.AF.'"&&"'}";Size(GetRecords($QUERY))+1)I'm getting an error on the first statement (the var definition). The error is indicated at the end of the statement, and the error is "Expecting number"Where is my syntax incorrect?------------------------------Jeff ------------------------------
Hi QB Community, I'm looking to bring a table of child records into a form using a code page. I need to add arguements and options which don't seem possible going off the default report (ex. ~bids~ )My Query looks something like this (I've replaced table ID):~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}")~Or this query ~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}^clist=1.2.3.4.^options=nvw.ned.phd.nfg.sortorder-A^slist=25");~The result is this message: Invalid Table This operation is only supported on individual tables and not on the application itself. Please check the URL. The other merge fields in the form work correctly, so it seems to have to do with the Child table although it also sounds like the problem is the URL. Does anyone have an idea of what might be going on here?Thanks!------------------------------Jake Rattner------------------------------
This must be a bug, but perhaps it makes sense to someone?If you have a proxy field, and use that proxy field in a dynamic form rule to hide another field, the behavior is as follows:1. If the proxy field is set to use a report, dynamic form rules fires correctly.2. If the proxy field is set to use the default record picker AND the record picker only has ONE field assigned AND the field is the one triggering the dynamic form rule, it fires correctly.3. If the proxy field is set to use the default record picker AND the record picker as MULTIPLE fields assigned, the dynamic form rule ONLY works in edit mode. Behavior 3 I believe is a bug?------------------------------Mike Tamoush------------------------------
Hellos,I've a simple JSON file but I'm unable to extract the value belowbody_json.contact.displayName failsbody_json.contact.displayName.0 failsbody_json:Objectcontact.displayName:Array[1]0:"Prashant Maheshwari"------------------------------Prashant Maheshwari------------------------------
So I'm trying to accomplish a couple of things here. First, we install custom closets. So I have a table called "Installations" which is used to schedule the jobs (installs). I have a separate table called "installers" that I use to track our installers. Originally I created this relationship (Installers>Installations) and used a Multiple Choice field that did a "lookup" from the list of installers, and that worked for that immediate need. Now I'd like to be able to generate reports for the installers as to what jobs they worked on, $ value, etc., to track their efficiency. I can't seem to figure out how to get the list of installers to work so that the information would populate back to the parent field - i.e., I should be able to go to the installer table/record and see a list of all jobs (installs) they were on, but I'm getting zero results. I feel like this should be QB101 but I'm hitting a wall.Here's a couple of goals:Some jobs need 2 installers, so I have to duplicate th
Does anyone know how to limit the number of records returned in a pipeline quickbase channel records search using the value in another field as the criteria? I know that we can hard set the limit using the limit field in the step, but I need the ability for it to depend on the value in a field.------------------------------Emma Finger------------------------------
Dear All,Please can you suggest what is the best way to check by whom the Billable steps have been used?Thank you.Iryna------------------------------Iryna Pylypenko------------------------------
Hello! I have a commissions calculation where I'm paying 20% of commissions owed for their first payment at a MAXIMUM of $1,000I placed this formula in a formula - numeric field and it isn't keeping the maximum number capped at $1,000. Max(1000, [Actual Commissions]*0.2)I tried switching the the items between the comma and it still didn't work. Can someone please help? Thank You------------------------------Anthony Wong------------------------------
Hi Team, Is there a way to show some default value in a dropdown list on the form? I've a form in which I want to show the default status as draft or after this record gets saved we can change status to draft? I've some other fields and rules which are related to this status field which updates status to approved/not approved. so cannot make default value "Draft" in the fields.------------------------------Mrunali Kadam------------------------------
Our company has Pipelines locked down to be insanely restrictive so I'm having to be a little creative here. RIght now I am building an app for a non-technical audience where they need the ability to import daily work tasks into QB from an external file which is stored on an internal network share.I am looking for a way to achieve the following optionsA) View a sample or demo of an API button that will import data from a file (csv or xlsx) into a table. I'd like to actually see it in action rather than a script. I have not been able to locate any resources that actually show this functionOrB) Create a button that will allow the intended user to attach a file as a record then get the data from that attached file into a table. (Not sure if that's even possible. )The button would have to be a hardcoded url/file name that never changes. Happy to provide additional details if needed.Thank You------------------------------Michael Mahon------------------------------
Has anyone figured out how to do a custom new user email? I know I can use API_SendInvitation to modify the text, but that doesn't allow me to remove the laptop graphic, change the subject line or generally customize the email. Anyone do this?------------------------------Jessica Feauto------------------------------
Is there any way to determine if a field is used in a conditional dropdown, by looking at that field? Or is the only way to go to the related field and look there?I have some forms where they have become messy. When I was new, I just had a hidden section labeled 'for Dynamic Form Rules', where I put anything for rules and conditional dropdowns. I've since learned to have another section 'For Conditional Dropdowns.' However, some of these old forms got real messy, with a bunch of fields added that dont need to be there, and i want to go through and remove all the unnecessary fields. It is easy to tell which are needed for rules, but is there any way to tell what is needed for conditional drop downs?------------------------------Mike Tamoush------------------------------
Hi,I've checkboxes on the form and wanted to use them in the report. In report, it only shows yes/no that is if checkbox is selected or not and doesn't show the checkbox text. Form:Report:Is there a way I can show actual text or name of that checkbox in the report instead of yes/no? If multiple checkboxes have been selected then can we handle that scenario? Thanks in advance!------------------------------Mrunali Kadam------------------------------
I am getting data from an external source via a webhook and pipeline. The business owner of this part of the app wants separate Date and Time fields rather than a Date/Time field. The external data is coming in as a timestamp. I'm looking for a Jinja ninja help me convert the timestamp into date and time fields. The external data is coming in like this: 2022-06-24T11:26:27-04:00Obviously the date is the first 10 characters and the time starts after "T" and the last 6 characters are the time zone offset. Does the date need to be reformatted, or will Quickbase handle the date formatted as it is?Your suggestions are greatly appreciated. ------------------------------Paul Peterson------------------------------
Hi all, I have just successfully built a summary report by having distinct count with an artificial batch key (i.e. customer ID + date). For summary report, i could utilize the summarize data section. However, in Stacked Bar Chart, in section "Data values on y axis", only numeric type field could be selected. Is there any alternatives to show the distinct count of a batch key in stacked bar? Thanks for the help.------------------------------Alex Wong------------------------------
Hi there friends.Here's what I'm trying to do...I have an "Events" table which includes a production report area, comprised of 6 multiline text fields for notes from department heads. As part of this production report, I want to capture weather data so that we can analyze that information against attendance/sales anomalies. I have a button that triggers a webhook in a pipeline to fetch the weather data. The weather data gets entered into its own "Weather Reports" table. All that works great. The issue is that I want that information to then update back to the events record from whence the button was pressed. I'm having trouble figuring out how to tell the pipeline what the original record ID for the event where the button was pressed it. I'm sure there's an easy solution, but I'm kinda new to this and putzed around long enough lol. Help?------------------------------SLMPAC Development------------------------------
You can see the little icon in "My Apps", "Pipelines", and "New App". I would like to be able to add something next to "Employee File", "Employee Dashboard" and whatever other app I want to have going. Is there a way to do this?------------------------------Jennifer Meyer------------------------------
Hi there,Question 1:I would like your feedback on making a "multi-selection text" field from the result of another field or a calculated formula.Example1 :The client owns a machine producing 12 kilos per week. Depending on how many days of the week the machine is working, we can conclude the production per day. So from the number of days of operation of the machine (which will be field by the user), I would like to have a "multi-selection text" field with: Default value: 12/[number of days of operation of the machine], other values (...)Example2:The user fills in a "multi-selection text" field containing 12 fruits. He chooses 3 fruits. In another section, I would like to give him the choice between the 3 chosen fruits in another "multi-selection text" field.PS: I have already read some solutions by creating tables and linking them to answer this question. This is not a solution for me since for each project I can have up to 40 variables that if I create a table for each it will take up
From: Michael Guarino Sent: Monday, June 20, 2022 9:38 AMTo: notify@quickbase.comCc: Katrina Borders (Kborders@dfamilk.com) <Kborders@dfamilk.com>; Michael Guarino <mguarino@dfamilk.com>Subject: 6-20-22 Quick Base Care has updated your case #689050 DFA El dorado springs MOImportance: High Good morning. We have not heard back on this. We will need some support on this immediately. Quickbase is the main database we use for internal audits…. We have not been able to enter data for over a month. Please let us know the status ? Thanks, Mike Mike Guarino Quality Assurance Manager Dairy Farmers of America 305 W US Highway 54, El Dorado Springs, MO 64744 Cell: 585 409 7796 Office: 417 430 2524 dfamilk.com From: notify@quickbase.com <notify@quickbase.com> Sent: Tuesday, May 17, 2022 1:06 PMTo: Michael Guarino <mguarino@dfamilk.com>Subject: Quick Base Care h
HiIs there somewhere I can see all the attached files (pictures or documents uploaded to a record) in QB? What happens to the attached files when I delete the record it's related to?We have contacts in our database and can add a picture of the person which shows as a thumbnail on the record. As contacts may later leave a company, they get deleted from the database. What happens to the image file that was attached to the record? Is it still stored in QB somewhere? If so, how can I find and delete it too?Thanks,Kim------------------------------Kim G------------------------------
When a report is executed in Quickbase the results include the number of records returned and goes on to outline the filter criteria. This is found at the top right of the report. In my example it says, "0 requests where Person Responsible is ....".I do not want the user to see what criteria were being used for security purposes.Is there a way to "hide" that from the report?Thanks,Scott------------------------------Scott ShimerSouthwest Airlines------------------------------
I have a notification email. The recipient of the email (me) and the owner of the Notification record are both in an Administrators role that have no restrictions on the table in question. Yet when I receive the email from the notification being fired, some fields are missing and one field in the subject line is printed as "*no access*". Interestingly, the fields that are not showing up do in fact line up with another role, 'Viewer' that does not have access to those fields. But again, both the owner of the Notification and the recipient do not have any limitations on the fields.Is there some way that the Notification email is using the wrong Role when determining what fields are visible based on permissions? Does it automatically pick a Role?Thanks for any insight!------------------------------Daniel------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.