Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is it possible to take latitude and Longitude coordinates and convert them into an address field?------------------------------Paul Peterson------------------------------
Hi, We are using QuickBase for our end-to-end customer workflow and need advice on how to link email communication into a lead record? We want to:Receive and respond to emails linked to a lead record and have the ability to respond within the record (QuickBase) so it keeps an end-to-end communication history archive for context with our customers and streamlines our sales resources workflows as they have the ability to work in QuickBase and not jump between QuickBase and Outlook. We use O365. Any ideas would be much appreciated.Neil------------------------------Neil McWilliams------------------------------
SGS Position announcementWe are hiring a person with significant QuickBase experience as an Environmental Protection Specialist at the DC Government Department of Energy and Environment. This position is full-time with benefits, based in DC, has the option to work remotely 2 days per week (with lots of flexibility), and the salary range is $85-$109K. Work with the Green Infrastructure Incentives and Assessment Branch (GIIAB) to develop and refine QuickBase features in the agency's Surface and Groundwater System (SGS), https://doee.dc.gov/sgs, supporting stormwater, watershed protection, and water quality programs.Key responsibilities:1. Develop new QuickBase applications and enhancements to existing applications.2. Analyze program objectives to recommend system design to improve program operations.3. Work with program staff to identify and draft development requirements.4. Write complex formulas in QuickBase, Excel, or other data management systems.5. Test and troubleshoot new features
I am working with an API call in a pipeline and trying to update the JSON body to include the value in a QB field along with some of the static text in the JSON body provided by the third party's API. Specifically, I have a line in the JSON Similar to this:"emailSubject": "Static Text",I am trying to change it to something like this:"emailSubject": "{{a.qb_field}} Static Text",When the pipeline runs the output is just the Static Text.What do I need to do to include the QB field?------------------------------Paul Peterson------------------------------
Amazing Opportunity to join a Quickbase Patner! Advantage Integrated Solutions- Sr. Solutions Consultant Job Title: Senior Solution Consultant Location: Remote Experience- 6+ years of experience developing solutions and delivering projects in the Software Industry. Quickbase Experience preferred but not required. To Apply: Please send resumes & inquiry to hiring@advantagequickbase.com Advantage Integrated Solutions is seeking a full-time experienced Senior Solution Consultant to join our fully remote team headquartered in Denver, Colorado. This position requires a driven, focused, reliable team member who is eager to learn and share our passion for cloud-based software business solutions. As a senior solution consultant, you will lead client-facing projects that include gathering and analyzing client business needs and requirements, then designing and building custom cloud database applications to solve for those requirements. Who we are: Advantage
Amazing Opportunity to join a Quickbase Partner! Advantage Integrated Solutions- Account Executive Position Opening Job Title: Account Executive Location: Remote Experience: 5+ years experience in business software or software solution sales or services. Business, Engineering or Computer Science-related degree preferred To Apply: Please send resume and inquiry to hiring@advantagequickbase.com Advantage Integrated Solutions is seeking a full time Sales Professional to join our team in a fast-paced, dynamic environment headquartered in Denver, Colorado. Who we are: You will be one of the early members of an internal startup, which we intend to spin out as a separate company within the next year. Our primary product is the Form Engine, a patent-pending product, that is in the e-signature (DocuSign) and e-form builder (Formstack) space, but with unique features targeting different, large new markets. Advantage is a Quickbase and ServiceNow partner. The Form Engine is a clou
When in table view, I only want 25 characters of may the 250 to show so the table won't be stretched so far. How can this be accomplished?------------------------------Phaedra Mclaughlin------------------------------
Has anyone ventured into the offline capabilities? I've found 3 limitations that I think pretty much render it useless (#3 isn't so bad..., but #1 is an incredible oversight).1. You cannot choose which tables users are allowed to add records to. This means, once you set an app to have offline capabilities. ANY user can add a record to ANY table. The only way you can stop this is to literally take away user add rights - but typically you still want a user to be able to add records to child tables....now they can add orphaned records thanks to this oversight.2. No lookup fields. I understand that this would have to be limited (as you would need to download the field data to a device), but the fact that you can't even choose any to add is quite a limitation.3. No dynamic form rules. This one is the least troublesome, but still a surprising limitation.I think #1 essentially renders the entire thing useless (my only work around would be to have a specific app for offline mode, and when new
Hi everyone,I'm struggling to update a lookup field, I couldn't find any information about updating look up fields via JSON RESTful API, however, API_EditRecord works, here is my payload: { "to": "tableid", "data": [ { "3":{ "value":12 }, "11":{ "value": 4 } } ] } fid 3 is my Record ID which is equal to 12.fid 11 is my lookup field (with Drop down list from a child table).I'm getting this error: { "data": [], "metadata": { "createdRecordIds": [], "lineErrors": { "1": [ "Can not change the value of the lookup field with ID \"11\"." ] }, "totalNumberOfRecordsProcessed": 1, "unchangedRecordIds": [], "updatedRecordIds": [] } } ------------------------------Sonke Gumede------------------------------
I have a parent table with only one record named Communication. Record ID# 1. It will always be only one record. When a new record is created in the Opportunities Table from another table the Related Communication has to be linked manually. Is there a simple way to populate it automatically. I have tried Form Rules, and Quickbase Actions with no luck.------------------------------Denis RochatRookie------------------------------
Does QuickBase have an out-of-the-box way to re-order the rows in the grid with drag and drop and then save the new order afterwards? I found this link that does that but lacks the function to automatically save the re-order. This is a requirement for me from my customer.: Auto re-order steps in a process | Discussions (quickbase.com). In this demo you can drag and drop rows of a report to reorder the records:. QuickBase Bloggershttps://haversineconsulting.quickbase.com/db/bmguzsp87?a=td Pastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=543 A little additional code could be used to add a new row or you could add a new row before invoking the drag and drop solution. If you want help with this feel free to contact mo_an the ultimate next week using the information in my profile: http://getsatisfaction.com/people/dandiebolt------------------------------Alex Yu------------------------------
I was reading this post about Subtracting units from one Table based on entry into another Table regarding Inventory and Orders and getting the QOH formula field calculated. My question is if I replenish the starting inventory, e.g., 100, how can I reset the QOH to be the same as that as the starting inventory? Currently the QOH is calculated as the difference between the starting inventory from the parent table minus the total Orders in the child table. Here is the post I found that allowed me to be able to calculate the QOH: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=3663f84a-a355-4743-bbe7-10f5a2503b64&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewerSubtracting units from one Table based on entry into another Table--> OR <---Just allow me to deduct the starting inventory when an order is placed. There is a video on youtube.com this is similar to the solution I'm looking fo
Is there a way to put "Toggle to next report" button to toggle to another report? Or...create a field on 1st report to toggle to another report?For example:READY TO HANG REPORT to go toREADY TO SAND REPORT------------------------------BuildPro------------------------------
Here is the loom video to my question: Project Management Scheduling ------------------------------Jennifer Meyer------------------------------
My first attempt into Pipelines and I'm a bit lost honestly. Because I don't have any experience in this, I chose to use the "wizard?".Here's what I have Work Crews, Work Crews are assigned to specific workload records. Workload Records have a crew pay associated with them as well as a completed date and paid date.I create a Work Crew Pay record child to the Work Crew. Work Crew Pay record has a pay period start and end date. I would like to create a pipeline which looks at the Workload Records, makes sure that it's assigned to the associated Work Crew, Check the Paid Date and make sure it's blank, if it's blank check the complete date and see if it falls between the pay period start and end dates. If so then I want to copy the Workload details (multiple fields) including the work crew pay to the Work to be paid table assigned to the Work Crew, hopefully providing a Work Crew Pay Record with multiple Work to be paid records. Essentially looking at al
I have a Currency formula(This field is called Amount to Reimburse to Employee) that work perfectly fine now, however I will need to add more condition to this formula! I would like to say if [Category] equals to "Training" "Amount o Reimburse to To employee " should be 0.I tried different ways but either it does not work or return formula error!Any help would be really appreciated If([Category Requires # of 1-Way Trips Field],If([Category - Multiplied by Mileage],([# of 1-Way Trips] * [Category Rate]) * [Resource' Commuter Miles 1-way],([# of 1-Way Trips] * [Category Rate])),[Mileage Cost]+[Cost])------------------------------Michael Naser------------------------------
Hi everyone,I have two tables in a HR app, one called Team Members and the other Compensation.In Team Members I have the Team Member name and their TitleIn Compensation I have a record for each salary so I can keep track of their history.In Team Members I am summarizing the maximum salary to get the employees current salary.In Compensation I am looking up the name and title of the Team MemberWhat I want to do is calculate the average salary per title. I am fairly certain I need to do a formula query to do this but I am trying to dynamically determine how many records and calculate it.The logic around this in english is:Get the records of all of the team members with the same titleSum all of their current salariesDivide that by the number of recordsThat should return the average salary.Can anyone help me get started on how I would go about doing that?------------------------------Ivan Weiss------------------------------
I have a table with service orders. Each service order could have up to 6 technicians assigned to it. I use a Kanban report to show which service orders are assigned to which service orders & filter it to only show service orders scheduled for Today(). However, right now, I am only able to show 1 technician assigned to the service order (using a User Field). Is there a way to user a UserList field and still use a Kanban report to show which services orders are assigned to which technicians and scheduled for Today()?
Background: we have a QB app in which we store events. Those events are posted in a QB calendar report. It contains many pieces of info about each event in the event record – much more than we can do in Outlook. However, most everyone here still manages daily attendance to any event by Outlook. That is not up to change. Users in a large community can see this calendar and select events they need to attend. Currently, users who wish to attend the event can download the ICS file of the event on Quick Base and export that instance to Outlook. However that does not sync to later updates made in Quick Base. We need a live sync between the Quick Base events and Outlook events. If the event needs to change, we need the automatic live sync to change it/update it on the Outlook calendar of the attendees who signed up and send out a notification that this has occurred. Do we have any solutions, native or third party, that
Typically for open as popup, I have something like this:var text URL = MyURL"<a class='OpenAsPopup' data-height=800 data-width=900 data-refresh=true style=\"text-decoration:none; background: #688EB3; border-radius: 5px; color: #ffffff; display: inline-block; width:145px; height:22px; text-align: center; font-size: 12px \"href='"& $URL& "'>Button Words Here</a>"I am trying to make the Open as popup a variable, so something like:var text Popup = If(Condition = true,"class='OpenAsPopup' data-height=800 data-width=900 data-refresh=true");"<a" &Popup & "style=\"text-decoration:none; background: #688EB3; border-radius: 5px; color: #ffffff; display: inline-block; width:145px; height:22px; text-align: center; font-size: 12px \"href='"& $URL& "'>Button Words Here</a>"The above didnt work. I know it is the syntax of how i added that variable in. Can anyone explain how to do it?------------------------------Mike Tamoush------------
Here is a loom video I made showing what I am talking about: Click Here for the Loom VideoI have looked and looked and not found a specific post regarding this so I am wondering if I am way off base with this. Any feedback is greatly appreciated.------------------------------Jennifer Meyer------------------------------
I have a formula query field in a table and the formula editor is displaying my query incorrectly.Is anyone else seeing this? Any thoughts on how to fix it? It makes it hard to work on the formula .... there are just two lines of code but they are displayed on the same first line in Formula Editor. I'm working in Chrome and on a Chromebook running Version 99.0.4844.94 (Official Build) (64-bit) of ChromeOS------------------------------Jeff Patrick------------------------------
All of the areas with red arrows. Am I able to hide them? (I forgot to put an arrow on the "search records"------------------------------Jennifer Meyer------------------------------
I am working on a pipeline that is importing a JSON object into a table. Some of the elements are being sent as an array even though there is only 1 element in the array. The Jinja for the fields is something like {{b.item}}. I have tried {{b.item.selected}} and {{b.item.selectedvalue}} (the latter is the way the item is defined in the JSON generated from the source) without success. I also tried {{b.item.[1]}} and {{b.item.(1)}}, both of these turn the textbox border red indicating an error. What are your suggestions?------------------------------Paul Peterson------------------------------
I have a Daily Status Report (DSR) form which contains several rules, and 2 reports. one of those reports points to a TASKS table. Each record in the shows a "copy" button, which purpose is simply to duplicate the task in that row with all the same data. The DSR uses Iframe (launching the DSR Form using IFV=1)Problem: when you click the "Copy" button it does what it is supposed to by duplicating task, BUT it drops you back into the DSR form without the Iframe controls - basically it looks like any other form.The code looks like this:var text Copy = URLRoot() & "db/" & Dbid() & "?act=API_CopyMasterDetail&relfids=80&recurse=false&copyFid=6&destrid=0&sourcerid=" & [Record ID#]var text DisplayDSR = URLRoot() & "db/" & [_DBID_TIME_CARD] & "?a=dr&rid=" & [Record ID# of Focus DSR];$Copy& "&rdr=" & URLEncode($DisplayDSR)I tried modifying Display DSR by adding iframe in the end like this: var text DisplayDSR = URLRoo
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.