Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Would like to chain pipelines together, need a return value in order to know the next best path for future calls. Can the calling pipeline see or know when the called pipeline has finished? Is the Bucket channel the only way to store a value that can then be used in the calling pipeline to achieve this? pipe A calls B, B does work, pushes a value into the Bucket, then A can then see this value? This post is from about ~2 years ago. At that time, return value was not an option. https://community.quickbase.com/discussions/quickbase-discussions/callable-pipeline-return-value/18753
I have looked at several of the answers to this question but I am having some difficulty creating the snapshot field.
Hi! I am trying to resolve an issue that has been happening since last year and that neither QB Support nor I have been able to solve. This issue randomly began out of the blue, and I can't make sense of it.The process:User 1 adds a task (record) to the 'Client Request Form' for XYZ Company.User 1 clicks 'Add Client Request Contact'. This takes the user to the child form Client Request Contact.User 1 will add the XYZ Company contact via an email dropdown box. If the contact does not exist from a previous entry, User 1 will click 'create new contact'.Upon clicking, the 'Contacts' form will open for User 1 to enter a new contact associated with XYZ Company.After adding the new contact, the contact is now available to add as a contact for any future Client Request Form tasks/records entered.The issue:When User 1 attempts to associate an existing contact with a Client Request form, the list of possible contacts does not display, resulting in the user having to add the contact repeatedly.Ad
Hello Mobile Qrew! Thank you to all who were able to attend our Mobile “FastField FAQ” with Jenny Gomez on Wednesday the 21st. Here’s a quick recap our meetup: Jenny Gomez, FastField Technical Support Engineer, joined us for a session to review the top 10 questions that new customers ask when starting out with FastField. It featured five main categories: Form Customization and Functionality User Management and Access Mobile App Features – online/offline capabilities Workflow and Reporting Data Integration and Automation If you missed the meeting, you can check it out here in this recording: Passcode to access recording: 8!bb&iUq Attached is a copy of the presentation for your viewing My favorite moment in our meeting was seeing everyone helping each other by answering questions in the chat and in the meeting, sharing resource documents, and sharing their mobile experience with the beta program. Here links to documents that were shared in the chat: FastField Help Center
Hello AEC Qrew! Thank you to all who were able to attend Tuesday’s meetup. Here’s a quick recap of our session: Rob Salaj, Customer Advisory Director – Construction, shared his experience as well as his vision and roadmap of Pro-App solutions for the construction industry. Long story short, You will see Quickbase at more Construction industry-related conferences, host in-person construction meetup, and be available to engage with you to bring solutions that speak your language. In addition to the CRM & Bid management app and the Prefab Tracker App, Rob highlighted a roadmap where you’ll likely see a new or updated application available in the Exchange in the following categories: Preconstruction Project Support Resource Management Project Execution Project Accounting Safety Organizational Effectiveness We don’t want to make too many promises on timelines, but the team is hoping to release at least one or two new or updated construction app every few quarters. Missed the meeti
Newbie here, and I'm stuck on one portion, so Ill try to explain the best I can:I am creating a new record from Table A. Table A fields:field 126 called [Temporary Identifier]field 35 called [Ticket Status]field 6 called [Ticket#]Upon saving the newly created record I would like to automatically scan Table A and mark any record that has a [Ticket#] equal to the [Temporary Identifier] on the newly created record to automatically change the [Ticket Status] to "Expired".What I'm trying to achieve: Copy a ticket record, change information, save. The newly created ticket record becomes the "Current" ticket and the old ticket record becomes the "Expired".example: I copy record for [Ticket#] A1234. The new record opens and the [Temporary Identifier] on the new record automatically is set to copy the ticket number of the copied ticket, A1234. I change new record [Ticket#] to B123 and save. After saving, I would like the original record for [Ticket#] A1
Hi, - So I have a notification that goes out with a lot of information in it, and one of the items on the record is a PDF of some scanned documents. When my users receive the notification, if they click the PDF it attempts to take them to the record, but if they aren't logged in already, they get a "page does not exist" error. If they are logged into Quickbase in their browser it successfully launches the PDF. Is there an easy way to "force" the login, or should I just email them via a pipeline instead? I don't want to open up the record or PDF to anyone without a login. Thanks in advance.
Hi All,I have a phone number type field that you have to manually enter an individual's phone number w/ hyphens. Is there a way to use a formula phone number field to auto add the hyphens when a number is keyed into that field (and possibly add parentheses around the area code)? I haven't found anything yet that works.Thanks in advance!-Scott
looking to create a formula or rule to do the followinginterior Date Field to not allow changes if interior status is confirmed and less then 2 weeks from current week.
I have created a form rule that says when Field A (field A is a formula checkbox field) is TRUE, then change Field B (checkbox) to TRUE when the record is saved --- ELSE if Field A is FALSE change Field B to FALSE. It seems simple but I'm not able to get this to update/fire correctly
I have read every single post on this board regarding this subject, and have tried every suggestion and nothing is working. Please help!I'm trying to take a user input Multi-Line Text field and convert it into a Rich Text field.When converting it directly to RT, it takes out line breaks. When I do SearchAndReplace, nothing: SearchAndReplace([Schedule],"\n","<br>") I've tried the following codes for line breaks / carriage returns, and none of them have worked:\n\r\\\\n\\r<br><cr><enter><return><crlf><nl><newline>&nsbp;&crarr;I even set up a debug field to display "this one" if the [Schedule] field contained any of the code/characters above. I'm completely at a loss, can someone help?------------------------------Danielle Wilczewski------------------------------
Good Afternoon,I am developing an app intended for mobile use and desktop oversight. I have a rich text field that I want to take the records from a Combined Text field and display each record on its own line for a clean view. I'm finding that the RT field has a height limiter designed into the mobile app I can't seem to get around - it forces you to scroll through the limited dimensions of the field to see all the records, and I would like the field to auto-size based on the size of the records. Currently, it will only display 3 at a time without scrolling. Any thoughts on this? For reference, [Item - Quantity - Unit] is a Combined Text summary field. Formula below://For mobile form use displaying each stock item on its own lineSearchAndReplace( "<div style='border: 1px solid; background-color: yellow; padding: 10px;'>" & SearchAndReplace( ToText([Item - Quantity - Unit]), &
Has anyone found functions or built functions to do bit math (i.e. And, Or, Xor)Excel has the funtions BITAND, BITOR, and BITXOR. I'd like to have the same functinality in my Quickbase application.Example of And:And(4,3) = 0 (0100) and (0011) = (0000)Or (4,3) = 7 (0100) or (0011) = (0111)Xor(4,3) = 7 (0100) or (0011) = (0111)And(15,3) = 3 (1111) and (0011) = (0011)Or(15,3) = 15 (1111) or (0011) = (1111)Xor(15,3) = 12 (1111) or (0011) = (1100)Thoughts?
I have a QuickBase and I have three tables involved. DSOTINSContactsThe Tins and the contacts table are related to the DSO table using the Field DSO name.What I need to do is pull in some contact fields into the Tins table.How would I set up the relationship in order to do this? Thanks.
I am a newer user to QuickBase and am learning how to use the formula fields. What are some of the best practices to learning how to use formulas at a mid - high level?
I copied over a database to start a new one.I see that there are about 7 embedded reports on one of my tables. It has the usage from the "old" database. Is there a way to tell where this report is being used and if it's important - like is it truly embedded in one of my table. I am worried about deleting it and it making a mess of one of my tables
Sometimes, I just can't get the hang of formulas! Please help...thank youCase(DayOfWeek([FINAL PROJECTED START DATE]),0,"SUN",1,"MON",2,"TUE",3,"WED",4,"THU",5,"FRI",6,"SAT","OPEN") Error:
I have a table used as a Cost Estimator. The user fills out values in a form, and the table outputs a series of costs based on formula fields.There are some 200 individual costs that are calculated based on the user's input. For example, a vendor license cost is calculated by # of Users times the Unit Cost of a license. The # of Users is user entered, and the Unit Cost is hardcoded into the formula. Example, [# of Users] * 1.50 where # of Users is entered in the form and 1.50 is the current unit cost of the license.This works as long as the unit costs don't change. Once the unit cost changes, it changes the value of the field for all historical Records in the table which is inaccurate. The two routes to preserve the integrity of the historical records while allowing new records to be created with new unit costs are to utilize snapshot fields which will freeze a field value, or look up the unit cost from another table every time the record is ope
I have a formula that reads It reads[closing costs] - 400/2 Closing costs -(minus) 400/ (divided)2Example: Closing costs 1950.00 -400= 1550/ 2 = 775 But I am getting the wrong calculation - it is coming out at 1750.00
I have a drop down field used in a parent table. The list is coming from another table (child)- it's one field that is a text field that has names in it. in the old forms, there was something saying let users add choices - I have user input but those from list wants me to add stuff into drop down and from another field doesn't make sense- The reason i made a a table for these choices is so I could go in and change them with end dates and start datesThe field says Input typeUser inputFrom listFrom another field I am using the glitchy new forms. horrible upgrade in my opinion I have had nothing but trouble since building it.
I have been doing a manual report for years on excel and I am hoping I can now have it done on QBThese are the fields I haveTour count - has a 1 or 0 in it and it counts the times a client comes to our business. Sale count - has a 1 or 0 in it and counts how many times the client purchases from us.Price then I created two formula fields in report Efficiency which takes the price and divides it by the tour countClosing which takes the Sale Count and divides it by tour count.Location which is where this all takes place. Based on date as well.on excel it would look like this Location#Tour# of Sales PriceEfficiencyClosing %NC Mem Update14960$777,443.06$5,217.7440.27%IM Members11$6,896.55$6,896.55100.00%Members subtotal15061$784,339.61$5,228.9340.67%Totals15061$784,339.61$5,228.9340.67% Then at the end it totals as you can see the closing is 40.67% not 140.67% Usually I need to run two reports to get all the numbers. All fields are in the one form now.&nbs
It's great to see the proposed enhancements to the Open to the Internet functionality. We have a large number of non-profit clients who rely, in some cases heavily, on internet forms for volunteers or other non-user program participants to submit applications, surveys and reports. While the enhancements are welcome, it's unfortunate that some recent enhancements to the platform that can be of great value to non-profit customers are only available if they upgrade their accounts to Business or Enterprise. Many of them are under tight budget constraints and don't require all the functionality of the higher levels. I understand that QB has never had a focus on the non-profit community, but it might consider implementing some sort of non-profit price or account access concession for non-profits to enable access to such functionality. QB is a vastly better platform for non-profits than any competitors, but Salesforce is walking away with the business and costing those NP users a
I posted earlier about this and said I would update, but cannot find the original posting any more.I located what I felt was a bug, but Customer Service has stated is expected. This behavior may affect many of you, and I would be curious to know how many others have realized this is happening.When using SaveBeforeNavigating, if you have changed field values it is a random chance if the order will be: Save the Record and Grab the New Field Values or if it will be Grab Old Field Values then Save Record.Thus, you are are utilizing any changed fields (perhaps you are using an edit record api and taking the value of Field A, which was just changed), you will sometimes get the original value of Field A, and sometimes get the new value of field A. I guess both actions happen at the same time (grabbing the field values and saving the record), so it's a mini race to see which one happens first, and it switches back and forth.As they are labeling this as expected behavior, I suppose we will need
I'm sure I'm missing something simple here, but I have a few tables that are source data for table-to-table relationships. I don't want / need most users to see the information in these tables so have unchecked "show in table bar" in the advanced settings. However, occasionally I DO want to see what's in that table. The only way I've found to do that is to change that setting, look at what I want to see, and then change it back. Is there an easier way?
Hello Qrew, Has anyone conducted an employee culture survey in Quickbase? Any feedback you could share?If you have used Quickbase for your survey, was it anonymous or confidential? Ideally, we would like for it to be anonymous. We have a few ideas on how to make it work but would be interested to hear how others have done it. We are looking to use Quickbase to conduct our yearly safety culture survey. It will be about 75 multiple choice questions with free response questions as well. Thanks for sharing your ideas and creativity!Amber
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.