Recently active topics

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! 

Table 1 - RequirementsTable 2 - Meetings For each requirement there can be multiple meetings, owned by separate sales rep.I already have these two tables, Now if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2 - Meetings, but if the same SalesPerson_A has 5-7 follow up meetings for the same Requirement_1 then 5-7 more separate associates records are created and we have created a field dropdown - Round of meeting where we are manually managing, 1st, 2nd, 3rd, etc to keep track, then we are manually copy pasting the previous meetings links in the coming up meeting to access them. this is too outdated and time taking.Also SalesPerson_B can also have a Meeting_1 for Requirement_1 then another new record is created in Table 2 - Meetings n for further follow ups its same manual way.What i want to achieve is that if SalesPerson_A has a Meeting_1 for Requirement_1 then an associated record is created in Table 2, Called Record 1, then I can h

I've created a system where when a user clicks "Create New Agreement" URL button, a new record will be created that brings over key information, including the "predecessors" record ID so that the new record can capture that this previous agreement is a "predecessor". However, I'm trying to figure out a way on how to link the "predecessor" record to the newly created agreement as I want a user to actively see in the "predecessor" record that this work has already been completed. Any recommendations on how to do this? Thanks!

I have a parent table called principal investigators (PI) that has a child table called "applications". This is for external users to apply to a grant we are hosting, all the information will come through a form in the applications table. However, I want to pull information from the applications table into the PI table for future querying.  Very simply, users will put in their name, email address, and departmental affiliations which I want to then create a record in the PI table if it does not exist. If it does exist, I want to update the applications table with the related PI record ID. I cannot get this to trigger properly and I have tried many times. It fails at the IF/ELSE statement. Here is my YAML file below if it helps (I removed identifying information): # Add PI to table## Account slugs:# - quickbase[DB]: Realm Default Account <None>---- META:name: Add PI to tableenabled: false- TRIGGER quickbase[DB] record on_create -> a:inputs-meta:allow_triggers: Any

Can a RESTful API be used to create lookup fields using a pipeline? Or, can anyone suggest a faster way to create 130 lookup fields for a use case in which I have 130 relationships between two tables (I need a new lookup field for each relationship)? I'm hoping to find a faster way of doing this other than manually one-by-one.

Hi Folks! I am working through a change in agenda and wanted to know if any folks in the App Builders Qrew Group has a use case they would like to share to the Qrew November or December? We can do one of two optiions: Looking for a volunteer to have a Quickbase Smart Scheduler expert help plan and build out a scheduling app with the Smart Scheduling feature. Dates are November 10th, December 1st, or December 8th. You have a app a use case that you excited to share that’s been working well at your organization. We would love to learn about it and get a quick tour. Dates are also November 10th, December 1st, or December 8th.Please reach out to me, Esther, elaville@quickbase.com or message me via the community and I’ll quickly follow up. Thank you! 

Hi,I have 2 tables, I would like to add a button in the form from the Accounts table that takes me directly to the related record in the Findings table. Both tables have the same Account ID field so I have created a table to table relationship between the two. I'm assuming I can achieve this with a url field with a formula that some how finds the related record in the Findings table by matching the account ID# but I have no idea what that formula would be. Please helpThanks

Hey Qrew!For my help desk application, I need to be able to change the record owner from time to time in cases where I add tickets on behalf of requesters.It was relatively simple in legacy forms to change the record owner at the bottom of the page, and I'm wondering if anyone has found a way to do the same in new forms.If I need to, I can still view the record in legacy forms and make the switch, but it is slightly annoying and takes extra time to switch back and forth between form styles and view modes.Also, I attempted to create a workaround by using a pipeline to edit the record based on an override field; however, I got an error back stating that the "Record Owner" field cannot be modified. I also tried to take the long route and use the QuickBase API_EditRecord, but I ran into walls that way as well. So, at this point, I am open to any suggestions.All thoughts are appreciated!

In a new QB app we created, we have a table "Phishing Attempts" where we want to create records by importing a spreadsheet. We also have a table "Targeted Users" which has employee info such as Employee ID, email, position, etc.Phishing Attempts table has a relationship with Targeted Users table, where we have the Employee ID field from Targeted Users included in the Phishing Attempts record form along with lookup fields that are automatically pulled from Targeted Users table.The spreadsheet we want to import to create new records in Phishing Attempts table includes an employee ID number. When we import the spreadsheet, we select the target field Employee ID in the Phishing Attempts form.The problem is that the Employee ID field in the Phishing Attempts form is not populating when we do the import. The ID number in the spreadsheet matches exactly what is in Employee ID in Targeted Users table.Is this not working because the Employee ID field in Phishing Attempts is pulling from Targete

I am using the formula below for a duration TAT.  I have checked off the HH:MM:SS for the type and it is still displaying 0:00:00 for things that are one hour from rec'd to acknowledged time enteredDays(WeekdaySub(ToDate([Acknowledgment Date/Time]),ToDate([Communication Received Date/Time]))) Do you have any suggestions on how to get the TAT to display accurately?Thank youJill