Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello Hive Mind! I need to place a link on a Home Page that links to a Dashboard. Button or Link doesn't matter, but a Button would display and fit better. Using a Button Bar, I click add a new Button, and I have 3 options, New Record, Report, or Page. Each of these 3 do not list my Dashboard, and while they provide a field for entering a URL, you cannot, and using it, displays a dropdown, that only lists Code Pages, Home Page (Old), and Home Pages... not Dashboard type pages. This same behavior happens when creating a new Link on a Link Bar too. Any ideas on how to put a button/link on a Home Page to link to a Dashboard? Thanks! Jeff------------------------------Jeffrey Day------------------------------
Okay I am fighting with the syntax of this code more than the logic of it, I BELIEVE, I am trying to increment hours accordingly. What I mean by this is if the store type is a Walmart or a Sam's club and it falls outside of the hours of operation I want to add time to it. I would really prefer to make it the next time they are opened, but I can play with that later. For example a WO came in at 3:05am on 6/14/2023 and due to the priority and a barrier code, irreverent abstraction for this, it adds 18hrs to the time. The time then lands at 7:05pm which is right outside of the range of open hours for Sam's club, therefore it should 14 hrs to the time to make it fall within that range. If that makes any sense, but my code is acting like 7:05pm is within the range. Please advise: Code: //Now that the corrected time has been handed off to this field it will check based on if its a SAMs club or a Walmart if the hours fall during closing time. If they do then it will add the corresponding am
I have tried to locate some direction or even determine if what I am seeking is possible, but unable to do so. Probably because I am not using some correct term on which to search. Here is my request: I'd like to be able to filter, within a Parent record, certain child records. My Parent table is Properties, the Child table is Values. Each Property can have multiple Values. I have established the relationship and can show on the Parent form a report showing all the Child records. What I'd like to do is have a field on the Parent form called Year, and use that value to only display the Child records where the Parent ID matches and the Year matches (the Child records also have a Year field). A Property can have many Values for the same Year. Just trying to cut down on some of the noise of the Parent form and only showing a certain year would do the trick. Thanks------------------------------Ember------------------------------
In the April 2021 Release Notes QB noted that the "New" and "Updated" flags on records would be retired at some point in the future. The release notes provided links to general articles about report filters and formulas without providing a specific example of a formula that can be used. Below is a simple formula to highlight records as being "New" or "Modified". In this example the time frame is set to the past seven days. If(ToDate([Date Created])>=Today()-Days(7),"#6BBD57",If(ToDate([Date Modified])>=Today()-Days(7),"#F1C32B"))//#F1C32B Update Gold//#6BBD57 New Green------------------------------Jon FroderbergPRIME DeveloperHarder Mechanical Contractorshttps://www.harder.comPhoenix, AZ------------------------------
Hi, So I wish to have a connected table which fetches data from Excel file and upon any updates in the file, mirrors that change in QB table as well. but in the Connected tables option, I see only CSV files, Is there a way to get connected table to link to Excel files?------------------------------Namratha N------------------------------
Hello! I'm looking for a way to allow my users to "take attendance" after they host large events. I currently have a working solution for small events*, BUT I really want to provide an easy way to track participation in very large events (60-100 employees attend). Desired result: A user selects the company relevant to the event and then a list of the company's employees generates. Every employee has a checkbox and it can be checked to say the person attended. (Ideally, the check boxes default to checked and can be unchecked.) A QB Action "fires" to create a separate record for every individual attendee. Current status: Right now, I've added an embedded report to my form to generate the list of employees who are possible event attendees. I also have the checkbox (it's just a field in the Employees table). The tricky part is that I haven't figured out a way to translate that filled checkbox into confirmation of event attendance. I've played around with formula fields in the Em
I have a PO app that I would like to create child "item" records from a cvs file that is a file attachment on the parent record. I imagine this would be a Bulk action in a pipeline. Does the file attachment actually a URL to reference? Has anyone done something like this? Could this also be done with a Formula URL button? ------------------------------Julie Meeker------------------------------
I am currently maintaining an already created table with a form that has over 1000 field elements. There is a transaction list section within the form that has the potential to be 100 unique transactions, each with 10 fields/columns that get imported via an excel file. As a result there are 1000+ dynamic form rules that affect the conditional fields of that sections. From my understanding if I wanted to add 3 new field elements I would have to add 300+ new elements and dynamic form rules manually one-by-one. What is the best practice when it comes to forms of this size? Is there an alternative way to handle thousands of dynamic rules via formulas or other means? ------------------------------Bob Jones------------------------------
Hello dear QBers! Been banging my head against this for a bit... I have an identity badge app -- where each user has an image of themselves in their record. On the homepage of that app, I'd like to show them their picture, if they have one. Wrinkle: I don't want to use the single-field report approach ... it's ugly, and doesn't translate well to mobile. I've been trying to write it as a api_doquery using the current user as the filter.. but not getting anywhere Thanks as always! M------------------------------Malcolm McDonald------------------------------
Hello All,I want to share with you a technique to get your JSX React apps in a Quickbase dbpage. First, here's the challenge, most people are accustomed to using JSX with React, but JSX is not native JavaScript and must first be transpiled to JavaScript. This is easily accomplished in a server environment, but how to do this in a dbpage? The requirement came to me to find a way to make this work without using a server.The solution is to do transpiling on page load. This is slower than pretranspiling, but is ultimately necessary if you don't want to use a server. The alternative would be to upload your transpiled code, which you should definitely do if performance is a concern. By the way, performance impact for transpiling on load is negligible for small JSX files.Anyways, here goes:<head> <script src="https://unpkg.com/babel-standalone@latest/babel.min.js"></script>; <script src="https://unpkg.com/react
Is there a reason why the import/export button only displays on the app's home page? ------------------------------Annette Gioia------------------------------
I have a field called Plans. (Text Field). I'm trying to write a formula to count how many plans are being audited by an individual each month. The Field Plan can have anything from one plan to many plans. Ex: Plan: A (Answer 1) OR Plan: A,B,C,D,E,F (Answer 6) Thank you in advance for any suggestions. Kathy ------------------------------Kathy Benjamin------------------------------
Can you use a table in a different QB app to be a lookup table in your current QB app?------------------------------Amy Migliore------------------------------
Hello! I am trying to create a pipeline that emails the record owner when the "Days Since Last Touch" hits 7. I want it to send this email without me creating, editing or deleting the record. Is this possible?? ------------------------------Kirstynn Rowe------------------------------
Hi, I have two tables (Projects and Tracker) related by Project Name. When a new Project name is added to the Projects table, i want to create a record (with the Project name) in the Tracker table. I have tried to create a QB Action but this part doesn't work: The Related MDU (Project Name) always comes in blank. How do I fix it?------------------------------Mike------------------------------
Customer support claims that there should be an Android setting to allow QB links to open in the app, rather than in the browser. I have not found any setting like this. It works great on iOS. Has anyone had success defaulting to the mobile app on android?------------------------------Mike Tamoush------------------------------
I attended the 2023 Empower yesterday, took the session on the "New Forms", and created a new form as was demonstrated. Unfortunately, when I later went back to edit that new form I could only do so with the legacy form editor. What am I missing here??? TIA for your hive wisdom.------------------------------Eric Rovner------------------------------
How would i create color codes for the number of days since a record was modified? For example, if a record was modified today, make it green. If it was modified in the past 3 days, yellow and more than 3 days, red.------------------------------Mike S------------------------------
I'm automating the creation of a task list with Pipelines. The various tasks are due on formula dates - and I've created the necessary formula date fields I need. (These are subtractive formula date fields, based on a date already in the record, minus # of days). So I have a few of these formula date fields that give me the needed due dates, but I hit a bit of a roadblock when building the pipeline. When I create a record for the tasks table, the 'due date' selection is a calendar, and I can only pick a specific date. Since the list of tasks needs a few different due dates, I can't figure out how to get my due date to be the appropriately chosen due date since Formula Dates can't be used in Pipelines. I feel like I'm missing something simple here. If I need four tasks created, each with a different due date (that is a subtraction of days from an existing date), what's my simplest path here?------------------------------Joe Hargrave-------------
There was one earlier post on this Forum which referred to Chat GPT. At the time, a couple of weeks ago, I didn't really "get" what Chat GPT was about. Chat GPT is an AI system co-founded by Microsoft which will respond conversationally in a very human-like way about any subject. It is now in free Beta.Chances are, if you are on this Community Forum, you are a more than a bit of a technology nerd so you have an "obligation" to understand what its about. :) Chat GPT will change the world. I would encourage you to give it a try. Just google Chat GPT.Here is an example of a one sentence Quickbase Application design question and its response. But it can also do your kid's homework essays up to about 1st year university level. What relationships are required for a Quickbase application to track Work Orders In order to track work orders in a Quickbase application, the following relationships may be required: A r
I'm not seeing how to add tabs to a new form. I didn't see it in any of the videos at Empower. Anyone know how to add tabs in the new forms?------------------------------Mike Blinkhorn------------------------------
I have two applications both with the same type of field [ID Number] I want to update records in one application [App 2] only when there is a matching ID numbers in both apps. For example, If john smith has ID Number "123" and there is a John smith with the same ID "123" in the other app, then update the record.------------------------------Phelan Sanders------------------------------
I have two tables. One table contains basic info, county, phone number, area code prefix. The second table contains the county and area code prefix. In the first table I want to select the the area code prefix in table 2 based on the county in table 1. The lookup would be the match the county in table 1 to the county in table 2 then use the area prefix code from table 2 and place it in table 1, area code prefix field. ------------------------------Anthony Pluchino------------------------------
I have a current form that works perfectly, but when trying to create a new form, none of the record pickers work. Any idea where the disconnect would be from the old form to the new?------------------------------Lynda Schutter------------------------------
Hello, This stopped working after a system upgrade a couple of years ago. I can type a £ into a field, but when I save the record it shows as &#163; (not good) or Ł (acceptable, although not quite right). Someone suggested to change App Properties to force UTF-8 encoding. However, when I do this exact forms stop working (they no longer pull values from fields and only show field names/codes). There could be other change in behaviour, that I haven't noticed. Is there a fix for this or a way to show Ł consistently? Kind regards, Arkady------------------------------Arkady------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.