Recent Discussions
Old form: label on the left side instead above an input field.
I want my Alt Text field label to show above the field on the form instead of on the left side of it. I know there is a way I just cant remember. I am using the old forms. I've attched a photo. The part highlighted in green is what I am aiming to do. The part in red is what I need to fix. Please help :)Solved0likes1CommentStatic Number Field
Easy question here, but for some reason I am struggling. All I want is to create a number field that has a static numeric value that is not editable. This is being used in a calculation. Hoping this field can show as view only with the static value displayed. Thanks, Brian0likes1Comment(Pipelines) Get Users in Role / Process XML from HTTP API
Hello, any help/advice would be much appreciated. I'm trying to send a reminder email to users in a specific Role, in a specific App, using Pipelines. As far as I can tell, there is not a JSON RESTful API call that does this (Get Users only returns all users for an App, with no info on Roles). However, API_UserRoles returns each user from an app with what Roles they have. In theory, I could somehow loop over this and send the email to only those users with a specific role. I can successfully use the Quickbase Channel -> 'Quickbase APIs' -> 'Make Request' step to call API_UserRoles and get this data. Here's where I run into trouble: How do I process this XML into a form that another step could use (e.g. loop over it and send emails)? I found this question: "To capture an XML response from an API in Pipelines" but I can't seem to figure out how get {{a.json.qdbapi.value}}. When I try to view its contents (emailed to myself) it is blank. There isn't any "Result" field or something like that from this request step available in subsequent steps. Only URL, Method, Headers, Content Type, & Body. For instance, if I want to get the JSON out of the XML (using {{a.json.qdbapi.value}}) with the JSON Handler Channel -> 'Iterate over JSON Records', the 'JSON Source' field states 'No json sources in the pipeline' Thank you for any help you can offer, ~Daniel ------------------------------ Daniel ------------------------------0likes8CommentsAverage last 30 days
Hello, I have a table with a field Date-Consumption (Date) and Quantity-Consumption (Numeric) and I want to obtain the average consumption of the last 30 days, for example if my consumption begins in MAY/01/2024 to today You should obtain the sum of the last 30 days and divide it by the days that have passed, which for this example would be 200likes1CommentHelp Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting
Hi Quickbase Community, I am facing an issue with a pipeline designed to add quantities to an existing field in my Quickbase app, but it keeps overwriting the existing values instead of accumulating them. Context: Tables Involved: Transactions: Records of items being added or removed from containers. Containers: Contains fields for tracking quantities of different items in specific compartments. Fields Involved: Transactions Table: Action Type: Indicates the type of transaction (e.g., "Add Item to Container"). Container Compartment: Specifies the compartment (e.g., "Compartment A"). Container ID: The ID of the container to which the item is being added. Item Name: Name of the item. Item Quantity: Quantity of the item being added. Containers Table: Compartment A Quantity: Field to store the quantity of items added to compartment "Compartment A". Current Pipeline Configuration: Trigger: On new or modified records in the Transactions table where Action Type is "Add Item to Container". Condition: The compartment is "Compartment A". Lookup Step: Fetch the current value of Compartment A Quantity from the Containers table. Update Step: Add the new quantity to the existing value of Compartment A Quantity. Issue: Despite various attempts, the Compartment A Quantity field in the Containers table is being overwritten with the new quantity instead of adding the new quantity to the existing value. Here is the current Jinja expression used in the update step: jinja {{ (b["Compartment A Quantity"] | default(0) | int) + (a["Item Quantity"] | int) }} Steps I Have Taken: Verified the field types and names. Ensured the pipeline permissions are correct. Tested with different variations of the Jinja expression to accumulate values. Checked pipeline logs for errors or issues. Request for Assistance: I am looking for a solution to ensure that the Compartment A Quantity field accumulates the new quantity with the existing value, rather than overwriting it. If anyone has faced a similar issue or has any suggestions on how to resolve this, your help would be greatly appreciated. Thank you in advance for your assistance! Best regards, Tom0likes4CommentsSave & Redirect in a Formula URL Using API_GenAddRecordForm
Hi. I have a need to "duplicate" the record and populate some fields on the new record (from the original record). It's not saving my current record before adding the new record, how do I get it to save first? I have the advanced setting turned on. This is my Formula URL Button: If( [Request] = "Include Existing Contractor + Add NEW FTE for Conversion", URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm" & "&_fid_53=" & URLEncode([Related Business case]) & "&_fid_129=60" & // Softcode the Months Needed to 60 FTE "&_fid_68=This Request is related to " & URLEncode([Request]) & "&_fid_123=14" & // Sets Request to "New FTE (Related Conversion)" "&_fid_127=FTE" & // New Employee Type "&_fid_43=" & URLEncode([Contractor PID - Dept]) & "&_fid_139=" & URLEncode([Related Level]) & "&_fid_138=" & URLEncode([Related Role]) & "&_fid_140=" & URLEncode([Related Hiring Manager]) & "&_fid_171=1" & // Start Date Override Checkbox to Yes "&_fid_259=" & URLEncode([Record ID#]), If( [Request] = "Add New Contractor + Add New FTE for Conversion", URLRoot() & "db/" & Dbid() & "?a=API_GenAddRecordForm" & "&_fid_53=" & URLEncode([Related Business case]) & "&_fid_129=60" & // Softcode the Months Needed to 60 FTE "&_fid_68=This Request is related to " & URLEncode([Request]) & "&_fid_123=14" & // Sets Request to "New FTE (Related Conversion)" "&_fid_127=FTE" & // New Employee Type "&_fid_84=" & URLEncode([Related Role]) & "&_fid_29=" & URLEncode([Related Level]) & "&_fid_38=" & URLEncode([Related Hiring Manager]) & "&_fid_43=" & URLEncode([New Dept1 #]) & // Dept #: sets field 195 to field F "&_fid_259=" & URLEncode([Record ID#]), "" ) )0likes3CommentsFormula Builder Cursor Position Incorrect
When editing a formula in the new formula builder, for example in a rich text field, where you position the cursor and where the edit takes places is not correct. For example I can position my cursor after a field name such as [fieldname] and start typing, but the text I type appears about 4 - 5 characters to the right in the middle of another part of my formula. Is anyone else having this problem? It's the same in both Safari and ChromeSelecting which fields to display from Formula URL searches
I have a number of Formula fields in my database which are searches of my database based on the contents of another field. The general form is this: URLRoot() & "db/" & Dbid() & "?a=QuickSearch2&srchtxt=" & ToText([<SOME FIELD>]) &"&exact=false" (This approach may be out of date now, but it was current when I built the original database in 2017). Here is the problem: The fields that get displayed are determined by which fields are designated as "This field may be used in reports." However, what I want is way to differentially control which fields are displayed, depending on which fields are being searched, whether this is done as part of the formula, or through some other mechanism. For example: Assume I have 4 content fields Category, Manufacturer, Salesperson, Location. And two "search fields" using the approach above: Search_Category: URLRoot() & "db/" & Dbid() & "?a=QuickSearch2&srchtxt=" & ToText([Category]) &"&exact=false" Search_Location: URLRoot() & "db/" & Dbid() & "?a=QuickSearch2&srchtxt=" & ToText([Location]) &"&exact=false" When I search on the contents of "Category" (I.e., looking for all records with the same product category as the current record), I want the Manufacturer field to show up as a column in the search results, but not Location. When I search by Location, I want Salesperson to show up as a column but not Manufacturer. Currently, I have to manually show/hide which fields I want to see after I do the search--very inefficient. For example, is it possible to define a table layout for search results as a form and then indicate the use of that form in the Formula?0likes2CommentsBackground color for Change Logs (Multi-select Text fields)
I tried to utilize the following formula to change the background color of my multi-select text field in the event that the new value changes from the old value: If([Value - Old]<>[Value - New], "<div style=\"background-color:#ABD4CD;\" >"&[Value - New]&"</div>",[Value - New]) I used THIS video to create a change log, but I am unable to use the formula above to change the background color of newly modified multi-select text fields. Does anyone have a workaround for this? ------------------------------ S S ------------------------------0likes1Comment