Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Building on the method described in the link below to post to Quickbase using an HTML form and EOTI access, is there a way to retrieve records to a similar form using an rid in a custom URL link (or any other way)? If so, how would you do it?https://community.quickbase.com/discussions/quickbase-discussions/posting-from-an-html-form-directly-to-quickbase/90206
Making a field required on a form only protects that form. Grid edit, imports, pipelines and API buttons can all save the record without it. And the field-level Required setting is all or nothing, which doesn’t help when the value only matters later in the process.For that, put the check on the table instead. In the table’s Advanced Settings, turn on custom data rules and add a formula. It runs on every add or edit, wherever it comes from.A simple one:If(Trim([Cost Center]) = "", "Cost Center is required.")Or only at a certain step:If([Status] = "Submitted" and Trim([Cost Center]) = "", "Cost Center is required before you submit.")Two things I’ve learned. Keep the message specific, since on an API or pipeline save it shows up in the response or the pipeline error, not next to the field. And existing records that break the rule aren’t touched, but they’ll fail on their next edit until someone fills the value in.Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/
Our company has several apps, it has become apparent to me that we have a lot of common information in tables across these apps. It has also become apparent that we could leverage connected tables to help manage this, so that we only need to update a table in one app as opposed to updating the same information in several apps.I'm wondering though how one would handle the existing table relationships. Example. We have an app (App A) that has a 'Customer' table. This table could be used in another app (App B) which has it's own 'customer' table. But the second app's table has several existing child tables. Would I be able to just make a new connected table from App A to App B, and then just sever the existing relationship with one of App B's child tables (but keep the reference field), then make a new relationship with the connected table? That seems possible to me, but I'm wondering about the key field in the connected table. I wouldn
Can anyone see why this pipeline doesn't trigger when # of REQUEST DECISIONS APPROVED = 7. If any other info is needed to help me, please let me know.(some info has been xxx'ed for security reason)--------------------------------------------------# NOTIFICATION REQUEST FULLY APPROVED## Account slugs:# - quickbase[aaa]: PIPELINES <None>---- META:name: NOTIFICATION REQUEST FULLY APPROVEDenabled: true- TRIGGER quickbase[aaa] record on_update -> a:FILTERS:- AND:- of_request_decisions_approved equals 7inputs-meta:export_fields: '"# LEAVE REQUESTS TOTAL, # of PENDING REQUESTS AA, # of PENDINGREQUESTS ASSOC HEAD, # of PENDING REQUESTS DEPT HEAD, # of PENDING REQUESTSDIRECTOR, # of PENDING REQUESTS DIV ABCMP, # of PENDING REQUESTS DIV ASTRO,# of PENDING REQUESTS DIV NUPAT, # of PENDING REQUESTS DIV NUPAX, # of PENDINGREQUESTS FCR, # of PENDING REQUESTS HR, # of REQUEST DECISIONS APPROVED,# of REQUEST DECISIONS DENIED, # of REQUEST DECISIONS PENDING, % APPROVED,APPROVAL PROCESS,
I had to disable averages and totals from a report I use in document creation because it adds the additional row with no label, indicating it's an average or total. I saw a video somewhere showing how to add separate area for totals, but can't find it anywhere and it's not included in the Document Creation help. I'm creating customer invoices and the totals/subtotals are important. Hoping someone can point me in the right direction or provide the solution.
I have a pipeline that successfully adds or updates a Google calendar event when the event is added or changed in a QuickBase table. Does anyone know what format Google Calendar is looking for in the Time Zone field (see attached)
I am working on a task scheduler for my team that would automate the task assignments. Tasks are based on season. How can I automate the Season field using date ranges that exclude a year. As of now this is the formula I use: If([Date Assigned] > Date(2024,10,15) and [Date Assigned] < Date(2024,12,31) ,"Aep",If ([Date Assigned] > Date(2025,1,1) and [Date Assigned] < Date(2025,2,28) ,"Aep","Non-AEP"))This gets what I need - this year. But if we use this going forward I will need to go in and change the dates to adapt for next year. How would Month(ToDate(Date Assigned)) or something similar be used to accomplish this goal regardless of year?
I have a QuickBase table with a 'Manager Approval Status' field set to 'Pending' by default. When a manager selects 'Yes' or 'No' in the approval field, the 'Manager Approval Status' field updates to 'Approved' or 'Denied.'I want to send the manager an email notification (when the field is new or changed) where they can simply click 'Yes' or 'No' in the email to update the table automatically. How can I set this up?
Hello, I have a pipeline question and am hoping someone much smarter than I can help. I have read other discussions on this matter such as:@markShnier_You and @KristofferKeen1 Collaboration: 'Looping through field values in Pipeline | Qrew Discussions'as well as @ChayceDuncan response:'How to iterate through the fields of a single record in a Quickbase pipeline? | Qrew Discussions'I am thinking this may be a combination of both?I have a field called [FAILURE DETAILS] and it's formatted like this:ps. I can change this to look however I need it to for this solution to work as it is just a rich text formula field consisting of if statements with html outputs to add underlining and line breaks. My question is, how would I have pipelines parse through a rich text field such as this and create a record per line, separating the title from the description. Example:Table Name: Failures[record id#]: 1[Field Label]: TYPE OF PROVIDER[Failure Description]: MISSING[record id#]:
I just created a purchase order system in quickbase and I'm using quickbase to generate the PDF document that is sent to the vendor. To pull in the PO line items I'm using a line item table and that is added to the PDF document template with a report. Works perfect but from a formatting perspective I changed all the fonts to 12 pt and added some color to match company branding. The challenge that I'm running into is the embedded report for the PO lines, I don't see a way to change the font or the table colors. It looks like the default is a 14pt font and it is using a grey color. I can live with the color but the font is too large. Is there anyway to control the font?Thanks
I have required fields in one of my forms. I'm using a custom button to save the form. When I click the "Save" button, it checks for the required fields in the Add Form, but it doesn't perform the validation in the Edit Form.How can I ensure that required field validation works on the Edit Form as well when using the custom save button?This is the custom button formula:// Define the container stylevar text container = "display: flex;" & // Use flexbox layout for arranging children "justify-content: center;" & // Center all child elements horizontally "gap: 17px;"; // Add space between child elements// Define the subcontainer stylevar text subcontainer = "display: flex;" & // Use flexbox layout for subcontainer "justify-content: c
I’ve been asked to change the behavior on one of our calendar reports and am not sure if I can do it. When using the report, the user double-clicks to add a record. Upon record save, the user is taken back to the default view for the table versus the calendar report. Is there a way to change this behavior to return to the report?
I have a table called "Crane Inspections" that is the child table of a table called "Open Crane Deficiencies". I am trying to have a way to put in deficiencies (up to 4 in one form) that are either existing (noted on previous inspections and still an issue) or new. On the crane inspection form, a crane is selected from a multiple choice field, 23 different questions are completed, then deficiencies (existing or new) are annotated at the bottom.I have a way that this works now, but I am trying to make better. Right now, I have a pipeline that triggers when a new crane deficiency is put in the form (also up to 4 new ones) and creates open deficiency records in that parent Open Crane Deficiencies table. Our maintenance department goes and works on correcting the deficiency, then closes it out which deletes the record from that table. Meanwhile, on the crane inspection form, that previous open deficiency option will no longer be one on the existing crane deficiencies multiple choice field
I have been wracking my head all day on this. I was reading Generate Documents from your records in your app where it says "However, you can also create API calls and use Pipelines, code pages, or custom integrations to generate documents. Each part of the formula represents an API parameter.". I was using Restful "Generate a Document" and was able to make a request:How do I get the output of making a request or basically the document template for this record as a file attachment in the record? I tried using:<qdbapi><rid>1700</rid><field fid="22" filename="Model_T.jpg"> Base64 encoded file content</field> Thank you so much!
A form that I use that has many checkbox fields, shows true / False in a Save Document API button as well as the print button is there any way to make the form just show a check mark if true and a blank if False?
I am trying to Make a QR Code Using the quickchart.io formula I have made one that will take me to the inventory part. Is it possible to have it take me directly to making child record ( Inventory Usage ) form for that record??? its setup as Inventory > Inventory Usage i would like to have a binder with all the parts that can be scanned to "Check out" the part(s) and take the user directly to the form so they can deplete the inventory. Any help on this would be greatly appreciated.
Hello Everyone,Our food rescue picks up food from different stores in our city. We then partner with distribution sites that pick up food from us on specific days each week or month. Most of our sites are weekly; for example, they pick up every Tuesday. In other cases, the sites pick up on the fourth Thursday of the month. Is there a way to build or create a calendar where I can enter this data, and it generates all the sites and what day they would come to our location to pick up food? Currently, we have a table for each site with the day they would pick up and other additional information. I have attached an example of the calendar that we created in Excel. Thank you.
I have a project log table that tracks each status change for a related project.How do I calculate the duration of time in each status?Essentially the difference (in days) between each record Start Date.I'm thinking this can be done in a report formula field
Hi Everyone,I will preface this with formulas are new to me. I have two tablesTable 1 (Preferred Provider): This is the master table of only the preferred providers identified by Provider IDTable 2 (Member Assignments by Provider): This table is the universe of all member assignments-both preferred and non preferred. Providers are identified by Provider IDWhat formula (and formula field) do I use in Table 2 that will look for a Provider ID match in Table 1 that will populate the new field in Table 2 as yes or no?This app won't have user entries so I don't think I need a relationship. I just need to be able to match the preffered providers assigned in Table 2 to the master preferred provider list in Table 1.I tried something super simple which, as you likely know, didn't work.IF(Size(GetFieldValues(GetRecords("_DBID_ASC_PREFERRED_PROVIDERS.PROV_ID = _DBID_MEMBER_ASSIGNMENTS_BY_PROVIDER.PROV_ID")) 0,"Yes","No")
Hi all, I have 3 tables, one for store, one for master material and one for data output for running pipelines. The pipeline is based on a trigger initiating form the store table where i tick say 'coffee pack' when i create a store which then copies anything from the master material table to the data output table. This all works fine and say if i had a trigger to copy tea products based on another trigger for 'Tea Pack' when i create a store it will just copy the tea output to the data output table. If i select both coffee and tea packs on the store table it copies all products with tea and coffee in the allocation field used in the material master.however, i want to be able to transpose the store information into the data output field also like store name. The data file will then show the products in the data output and have the store requested name against each product. Is this possible?
Hi want to write a formula to show and hide fields on a form which is in Table 3.Table 1 has one to many relation ship with Table 3. (not sure if it even matters)Table 2 has one to many relation ship with Table 3(not sure if it even matters)So few questions on this?Do i write this formula in Table3 - Advance Settings > Build custom data rules for this table: > in this field?How do i control where these fields will show up on the form and alignment ?How do i hide all fields initially, just remove them from the form ?Also Table3_Form_Field1 = will be selected by the user when they create a new record in Table3 so is this going to work dynamically or i need to use the dynamic form rules only instead?If the formula will do the job then, Is this the right formula structure?
I have looked everywhere and tried everything I can find but no luck. I want to background color a field if the values are the same. For instance, if a field for "Job 2345" has the number 523 in the ID field and "Job 1234" has the same 523 number in the ID field, color the background so they're identifiable. And hopefully grouped together so all jobs with field ID 523 can have the same crew assigned. Thoughts?
A lot of people have tried an AI app builder in Quickbase and Pave and been impressed by how fast it gets you to a first version. The harder question is whether you’d trust it with a real workflow.What would it take for you to rely on the AI App Builder tool/Pave to create, interate, and maintain your app(s)? What do you wish it could do? Share your take, any recent experience, or something you wish were different.
Hi Team,While exploring the Quickbase application i want to fetch the application data across the Admin User account including all the applications that are created by other users of the account.Being Super Admin I am able to see the applications of the other users from UI in the Admin console. I want to fetch this information through the API, while I am unable to find the REST API that fetches this data, is there any REST API available that fetches list of all application across the user account including the other user's apps.I tried using the XML based API and found that the API_GrantedDBs gives the apps created by the Super Admin user but was unable to give the other user's application in the list. How can I find the list of all applications across the user account including the other user's app. I am using the authorization ticket that is required to call the API. Please guide me for the same.I also require to find the users and groups that have access to the app
Hello,I would like to set up a pipeline to call API_GetUsersInGroup when a record is created and check to see if the user in a particular user field is in the group and if not, add them using API_AddUserToGroup.I am struggling to find a way for it to see that the user is in the group and stop the pipeline if they are not. Instead, it always shows they are NOT in the group and tries to add them, erroring out when they are already in the group.I'm fairly new to all of this, so apologies if it is a silly question - but how can I have it search through the results of API_GetUsersInGroup for my user and correctly identify if they are already in the group? I appreciate any assistance!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.