Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I was watching the video by Kirk Trachy on uploading multiple file attachments to QuickBase and was wondering if it was possible to use this in a code page and pass the Record ID as an input variable that the user would enter in. Here is some of my code for example - the Record ID the user would input. Currently I have one field as an example (Upload File Attachment) but this just allows one file per field. Is it possible to pass the user input of the Record ID (either using getElementByID or $("input[name=_fid_191]").val() )to the code that Kirk Trachy uses to attach multiple files to the project?:<tr><td style="float: right;" class=m><input type=text size=40 name=_fid_191 ></td><td style="float: right;" class=m>Record ID#:</td></tr><tr><td class=m>Upload File</td><td class=m><input type=file id="recordid" size=40 name=_fid_261 ></td></tr>Java:var id = $("input[name=_fid_191]").val()o
Is there a way to clear the value of a date field in a pipeline? I have am replacing my automations with pipelines and I have a couple automations that will clear a date field given a certain condition. I tried using a null field I have in the table and leaving the value empty in the pipeline step. Neither of those worked.------------------------------Paul Peterson------------------------------
Why do the labels for checkbox fields show up to the right of the checkbox? Is there a way to make them be on the left like all the other field labels? I attached a PDF to help show what I'm talking about.thanks,Allison------------------------------Allison Watson------------------------------
I have an order number ie. 123123.1.On a QB Form, when I select an order type from a dropdown I want the order number to be updated. E.g. If I select "return" order from the dropdown, the order number field should be upadted to 123123.1.returnIs this possible? If so, howThanks for the help------------------------------James van der Walt------------------------------
I'd like to add the Formula URL field to the table so that each record has the "copy" button next to that row. When that button is clicked the Formula URL will first create a copy of that original record, then navigate to the form to edit the newly created record.How would I do this?------------------------------James van der Walt------------------------------
I made some changes to a list of items in our inventory which has changed the way they were organized, I need to revert the changes... is this possible?
Hi, I'm trying to create a form to audit some of our company assets(Keys). I have 3 tables called Keys, Employees and Audits. They are properly related. When I add a new Audit, I'm able to select the employee I want to audit, then I need to see a list of the assets related to this employee (for this I used a report link from the Keys table and a rich text button called StartAudit to save-and-keep-working in order to see the records on this link report). In order to register the start-time of the audit, I have a Formula-Time Of Day field in the Audit table called Start Time with the line: ToTimeOfDay([Date Created]). That works just fine. The problem I'm having is on how to register the End Time of the audit. After looking into several comments, I tried using another rich text button called Finish Audit that would change the value of the field End Time, then redirect to the same table and same record ID. This is not
I am aware of the ability to filter records using a report rather than a record picker on a form. Is there also a way to filter available records using grid edit? (I wanted to restrict the selection of training classes but allow for multiple selections by adding an editable child table to the form)Thank you------------------------------Christine White------------------------------
How does one actually get grandparent-parent-child relationships to work correctly?------------------------------Michelle Craig------------------------------
I currently have a live app that my company is working with. We needed to make some new changes to the app so I copied our current live app with all of its data to a test app. From here I have made all my necessary upgrades, how can I now transfer my live data into my test app? I want to do this and then just rename my test app to be the functioning one moving forward. Is this the wrong way of doing this? Sorry still quite new at quickbase.
Hi, I have a table/ report that has 3 fields (like LVL1_GRP, LVL2_GRP and LVL3_GRP) for every record. Is it possible to create a drop down with values from the 3 fields for every record. Every record may have different values for the 3 fields. Example for the records with dummy values listed below.R1 L1_GRP1 L2_GRP3 BlankR2 L1_GRP2 L2_GRP1 L3_GRP1R3 L1_GRP1 Blank L3_GRP2------------------------------Anitha Jeevarathinam------------------------------
I noticed if I put an email address in a formula text field (sometimes I will combine a name and their email), in a formula text field the email address is automatically recognized and a hyperlink is created to the email.However, that same formula in a formula rich text field, and the email hyperlink isnt created. Is there a way to have a formula rich text field recognize and email address and highlight blue with the standard email hyperlink?------------------------------Mike Tamoush------------------------------
Hello,I have a relationship between three tables: A user table has many middle user table entries and jobs have middle user table entries. I have done this so I can assign over 20 users to a WO. However, long story short our reps do not have time do relate our electricians to each job as they move around fluidly. Therefore, when the user selects the job I want them to relate themselves to the WO, automatically and without picking their name from a list. I am trying to achieve this by passing along the user's record ID as this is the key, however, I can not figure out how to obtain this. I have tried multiple different methods in passing data to this field with no success. Any tips? ------------------------------William Hunter------------------------------
so i have my form and i am trying to connect information from one table (the branches table) to my form and then connect information from another table (the market recommendations table) to my form by simply putting in the branch ID. It's set up in another form in my app, but someone else set it up and I cannot really ask them for help.------------------------------Michelle Craig------------------------------
I am trying to get a Jinja Expression to give me the First Day of the Month. Searching the Help Section and web, the Replace function should work.{{time.now|replace(day=1)}}The error message I am getting isValidation error: Incorrect template "{{time.now|replace(day=1)}}". TypeError: do_replace() got an unexpected keyword argument 'day'There are plenty of Python references out there for this and Replace is listed in the QB Help. I am sure it is a subtle syntax change to get the right output.------------------------------Don Larson------------------------------
Hi all! running into issues creating a formula that will compare two date fields - one is a Date field, and the other is a Formula - Date field that calculates x workdays from the record [Date Created] field to see if the first date is before or after the second date. <img" &" src=\"" & "https://images.quickbase.com/si/16/228-rect_green.png\">" I'd also like to group a few of these together with an If statement to create something of a progress bar. Is this even possible? ------------------------------Becky------------------------------
I have a Transaction Table that breaks out some payment into 2 records (Principle & Interest). In another table (parent), I need to count those 2 records as 1 Transaction when I am summarizing up so that I have a correct calculation for # of Transaction over a period of time. I created a Concatenation (formula field), and have tried Summarizing but I can only use the Combined Text function. I need the Count function. What is the best way to count records where the value in the Concatenate field is the same, so I can Summarize up to the Parent with a number value?Thanks in advance for the help. Ashley------------------------------Ashley Harris------------------------------
I'm running into an issue with an 'if' statement I'm using in a field in a Pipeline.{% if a.$prev.client_live_date is not defined %} TBD{% else %} {{a.$prev.client_live_date.strftime('%m/%d/%Y')}}{% endif %}When the pipeline runs, it's throwing this error:UndefinedError: 'None' has no attribute 'strftime'Does anyone have a solution for this? Thank you.------------------------------Matt Makris------------------------------
Anyone know how when hovering over a bar chart to show only those values in the bar vs all the records in the table? ------------------------------George Bramhall------------------------------
Hi everyone, does anyone know how to set 10 hour working days, 7 days a week in the Gantt plugin? I can get 24x7 days working and 8hr working days 5 days a week but no matter what I try I can't find a way to get 10hour days 7 days a week working. Any help would be much appreciated.------------------------------Elise Salt------------------------------
Hello,I've created a formula date field to auto-populate the date two weeks from todaytoday()+Days(14)but I want to allow the users to override it. Normally they would have a call every two weeks but there could be occasions where they/the customer will be on vacation or the date just doesn't work for the customer.Any ideas?------------------------------Julie Bowers------------------------------
I'm trying to get a query to work to compare if data contains similar letters between fields in the two tables and output text from another field.Writing the formula in Table 1Desired output would be if [product code] (FID 116) in Table 1 contains 'EL' and [Product Code Selection] (FID 8) in Table 2 (bs9xqc72i) contains 'EL', list value from Table 2, Name (FID 6). I know I need to use the GetFieldValues(GetRecords( query but I'm new to queries and am lost as to what to do next. Any help would be much appreciated.------------------------------Dawn Rene------------------------------
I can usually alphabetize a list getting creative with a Combined Text Summary field. However, I have a unique situation where I have a Summary Field (that I have already alphabetized) and I need to put it in a list with one more value. But I need this value to fit in the correct spot to make this whole list alphabetized. Example:Combined Text Field = A;B;C;E;F;GExtra Field = DDesired outcome: A;B;C;D;E;F;G------------------------------Mike Tamoush------------------------------
I'm wondering if there is a notification limitation in Quickbase. Both searching Quickbase resources and performing google searches has not turned up anything, so hopefully a little guidance from someone who knows more than me can tell me where I'm missing a step: I have two tables in an app. All Other Inventory is the Parent and Employee Records is the Child.1. Employee Records – in this table our Help Desk can assign to an employee an inventory item such as an apple pencil along with the qty.2. All Other Inventory – in this table I have every Inventory Item listed, along with how many I have of each. If an employee is assigned 1 Apple Pencil, then the total number in inventory is decreased by 1. If I remove the apple pencil from the employee, the total number in inventory is increased by 1. The math works, no matter what the item is, so we're good up to this point.The issue that I'm running into is with the Notification tha
I have a table of customers that contains two dates, essentially a starting and ending date, and the state they are located in. I am trying to develop a summary report showing me a count of customers per state per month where the month is contained between the two dates. I can easily come up with the summary report of the count of customers per state, but not certain of the formula necessary to break down that count by month included between those two dates. Any ideas? Thanks!------------------------------bcloud------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.