Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have created a code page with HTML and Javascript. I have the following field that is required in the QuickBase form itself:However, I would like this to translate to the code page:<tr><td style="font-family: Sans-serif;" class=m>Contractor Business Name:*</td><td class=m><input type=text size=40 name=_fid_6 ></td></tr>How do I make the field in the code page required? or will that kind of functionality need to happen in the javascript. If so, how?Thank you so much!------------------------------Lija Harris------------------------------
Good morning QuickBase Community, Question: If I'm using a shared value from field #1 in field #2 (different tables), how can I link them? Your help here would be greatly appreciated. I am a Data team of one! I currently have two tables in quickbase – An employee table (built already)– where each employee gets a row with their demographic info. Primary Key: Each individual's User ID A managers table– where each employee gets a row for every manager they had. A manager will always be an employee. I have the tables set up successfully (down to each manager being associated with an employee user ID from shared values) except I'd like to be able to link each manager to its corresponding employee table record (e.g., if Hagos is a manager, his manager record is linked to his employee table data).That way, I can pull relational things like what's highlighted and do other things that rely on relationships (e.g., drilldowns, counting the # of direct reports a manager has). Employee Table
Hi,I am trying to set up a formula checkbox field, I needed it to be checked if there is a date in a corresponding date field, if no date I want it to be unchecked. Here is what I have but it has checked all, date and no date. If ([Epic Agreement Sign Date] = null, false, true)Any help would be appreciated.thank you------------------------------Zana------------------------------
Hello,I need to use a many-to-many relationship between a PO table and Invoice table. I have the relationship setup but I'm hoping to find a way to simplify the data entry.For the most part, these relationships are 1-to-1 but we have rare occasions where it can be 1-to-many in either direction, hence my reason for many-to-many. Is it possible to have a button on the PO form to create a new invoice and link everything through the intermediate table without the user needing to select the PO and Invoice?------------------------------Matt Hardy------------------------------
I currently have the following: An employee table (built already)– where each individual gets a row with their demographic info An annual employment snapshot (built already) – where each individual gets a row for each year they're employed (e.g., if someone has been employed for five years, they get five rows) Do you have any ideas on how I can achieve the following? - Track each individual's mentors by year in the employee snapshot table (in any given year, an individual can have several mentors). I envision it looking like what's below. - Have the mentor linked to the employee table (so, each mentor can be linked to their demographic information). I envision it looking like what's below. Employment snapshot data: Name (links to employee table) Year Mentors (links to a mentors table) Employee1 2020 Mentors Employee1 2021 Mentors When I click Employee1's 2020 mentors table link I get: Name (links to employee table) Ye
I would like a field to populate the date a box is checked.... How would I go about this?------------------------------Angela Bowman------------------------------
Hi QB users,I have a QB with a simple formula that pulls the last name from a [Full Name] field, which works most of the time except for suffixes like Sr., Jr. II, etc.Current formula:Right([Full name]," ") I guess I could write an if statement for each case, but I'm not good with trim, part or left/right, so could use help on the syntax to get the second to last "name" in those cases.Thanks in advance,------------------------------Troy MacPherson------------------------------
Has anyone used the ShipStation pipeline channel? I am trying to figure out how to create a shipment (or a label) and it doesn't look like that step is available.------------------------------Edward Hefter www.Sutubra.com------------------------------
Hello,I am trying to fix a formula for a numeric formula field that calculates the weighted average build cost of house plans we build. Here is the formula: (([3 Month Average Build Cost] * 10) + ([6 Month Average Build Cost] * 6) + ([1 Year Average Build Cost] * 3) + [2 Year Average Build Cost]) / 20The Field References are summary fields. The numeric value is the "weight" we are giving to that summary field.The problem we are having is that occasionally the Summary Field used in the formula is blank/null and it causes the result of the formula to be blank. What I believe needs to happen is for the formula to simply disregard blank values and continue the formula calculation.For instance, see the attached screenshots. 3 Month Average Build Cost is blank and therefore the "Weighted Average" formula result is blank. Rather, it should still calculate the remainder of the 6mo, 1yr and 2yr averages.The other obvious issue is that if any part of the formula is blank then the numbe
When you save a report as a spreadsheet the totals on the report are not saved in excel? Why is that? Is there a way to get the totals on the report into Excel?Thank you
Hi Community,I work for a healthcare system in Talent Development/Training. I'm also the resident Quickbase person. In my job, I create, implement and manage training programs across our system. Much of what I do is in the form of electronic learning, graphics, etc. I do have a few in person training programs that I manage but those are getting few and far between.We are struggling with content management, versioning and tracking. So say I develop an eLearning course, I certainly can store my original files in a folder on our SharePoint site, or a SharePoint list, but I find that system not so easy to use. And customization, while possible, isn't the best.So I decided to ask the community for examples of how you track assets. Admittedly, I'm having a designer block in my brain and hope that by seeing or hearing about examples of how you use QuickBase to upload, track and iterate assets, it will give me the inspiration I need to make this a
Is there any was to encode a file attachment field into base64 in QB?------------------------------Justin Ferris------------------------------
I'm trying to figure out how to update options in a multi-choice field using a pipeline. I'm open to other automated/scripted ways to do this. Any help would be appreciated.Ultimately, I'm looking to add a value to the field whenever a new, unique values is added via a relationship. My reason for wanting to do this is to use the multi-choice field in the 'groupby' field in the Kanban report, which doesn't seem to accept relationships in that particular setting. Thanks!
I have a column called Reference Range that has a 'normal' range for a variable in the structure <number - number>. I would like to populate two extra columns in the same table called 'Lower Bound' and 'Upper Bound' with this range. The Regex formula: '(\d+)\-(\d+)' matches and gives me the groups. However, I'm not entire sure how to structure it in a Pipeline. The Reference Range is in an already existing table and I'd like to run this expression over all existing and future records. The "Apply Regular Expression" function should work for that however it expects a 'Text' field and I'm not certain how to get the 'Reference Range' column in there. TLDR; want to run the Regex (screenshot) over column in table whenever record in table changes------------------------------Jille van der Togt------------------------------
I want three buttons on my homepage.Depending on the button that user selects I want the action of pushing that button to pass information to a field. Is that possible with homepage buttons? ------------------------------NOEL HODGES------------------------------
[ACTUAL FINISH] = any day within the week, then[BILLED DATE] will = that week's Friday dateFor Example[ACTUAL FINISH] =11/1/22, [BILLED DATE] = 11/4/2022[ACTUAL FINISH] =11/3/22, [BILLED DATE] = 11/4/2022etc...thank you------------------------------BuildPro------------------------------
My QB Sync table has a patient primary key and a multi-select field (although QB imports it as a text field) with hundreds of possible symptom values. I would like to make this into a join table between patients and symptoms with each record being one instance of a patient with that specific symptom. Is there any way to do this natively with QB? I can script it, but the organization I work with is not very technical, so it would be difficult to maintain. Much easier to maintain in a low code platform like QB.------------------------------Solace Sonder------------------------------
I am trying to write a pipeline to create a record for each person in a Multi-select Text field. I am assuming that you would use a text step to do this, but I am not familiar with how to format the regex expression so that it will pick up the names. there is the "; " that separates the names. Help please!------------------------------Julie Meeker------------------------------
I am working on a duration field to count the number of days passed from a date that is entered in another field, but it's returning a negative number. I'm sure it's something I need to add to the formula but I am not sure[Date FOC Form Sent]- Today()------------------------------Lorrie B------------------------------
Hi all,With in my Form I'm performing a number of calculations which result in a final score, which I then display with an indicator, where the color depends on the score achieved. However for this indicator is there a method to adjust the width so it increases with the score.Have tried a another variable and then reference it within the width parameter - but that is not processed. Have attached an image and highlighted the attribute I would like to dynamically adjust.RgdsPatrick------------------------------Patrick O'Neill------------------------------
Hi All,Whenever I assign two different roles for a particular user(Access via Individual) the lower-priority role's home page is displayed as a home page for the user. I override the role between Admin and Viewer(The roles are QuickBase default roles, the permissions are also set as default, and admin is set as the default role for my application). But according to the QuickBase help guide, the higher priority role's home page should be displayed as a home page for the user. But when I override the lower priority role's home page is displayed as a home page for the user. What is the expected behavior here? Reorder Role Priorities Quickbase Help remove preview Reorder Role Priorities Roles determine what a user can see and do inside an application. But what happens when roles collide? It's possible for a user to have multiple roles within the same application. For example, say a user belongs to two groups, and you've granted both groups access to your applica
We have a series of labs panels composed of a series of lab tests that are put in the exact same way every time. I have a join table with patient and lab information. Patient X Lab A Test 1 Patient X Lab A Test 2The ideal flow would be for a user to select the patient and the lab panel they want to add, and a grid edit/add would open with that patient, lab and test values already populated (in this case there would be two rows in the grid add, like the above mini table). Is this possible in QB?Again, we can script it, but the organization is non technical so trying to look for native ways as much as possible.------------------------------Solace Sonder------------------------------
Hi all,I'm trying to work through a few different dilemmas that all stem together: I run a pipeline from a 'per interaction' form that staff fill out each time they complete something with a client. The pipeline updates a 'Contacts table' from which we can update our mailchimp. the Pipeline is supposed to either ADD or Update records, depending on if the contact already exists or not. To prevent user error/typos - we made the contacts table look-up-able if they select a radio button that says if the contact is 'NEW' or 'Existing' If existing, they lookup (fid "email_address") If NEW, they input the email address (fid "New_Email_Address) However, the Pipeline doesn't appear to be that smart - and I can only use one field to use for the pipeline If Then statements. I can't say "When New Record Created, Look IF FID Email_Address exists, if Yes - update; if NO, look at FID New_Email Address - and create new record in contacts table.So - I thought to myself, okay; I need to wr
I am attempting to create a button to use on a table or a form to allow not so familiar users to find easily.I am using this formula"?act=API_EditRecord"in a URL-formula field but am getting an error.Is the URL-Formula field the way to go?------------------------------Michael Hall------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.