Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Validation error: Incorrect template "{% set json = d.content | from_json %} {%set activities = json['trackResponse']['shipment'][0]['package'][0]['activity']%} {%set ttime = activities[0]['time']%} {% set tracking_time = ttime[0:2]+":"+ttime[2:4]+":"+ttime[-2:] %} {{tracking_time}}". UndefinedError: 'dict object' has no attribute 'package' This is the error I am getting. Any ideas on how to fix it?
We need to compute for below formula:Utilization % = Total Actual Hour / (Weekdays in a month * 7.5)How do we get the weekdays in a month?
I would like to create an app that is specific to a Client, I can use paid seats for the users logins.Specifically, there are 2 main functions I need. The ability for submission of request and then once reviewed, the ability to view/access the requested information from the Client specific App. I do not want to give any access to our main application, which is why I was thinking the client specific app would be best to build.I want to set the new app up similar to a “portal”, where this Client can log in and do/see several things such as:Submit an estimate request through a formCheck the status of this requestProvide updates for the requestAdd authorizations and scheduling updatesSend message or make notesUpload attachments I am thinking I could create tables in the Client App that will mirror the tables/fields etc. that are in the main app, thus assisting in relating the data. Then have some type of notification set up when a new submission is made.Our teams would then &nbs
Anyone know the settings I can use to send an email notification like this? I have tried everything.------------<?xml version="1.0" encoding="utf-8"?><?adf version="1.0"?><adf> <prospect status="new"> <id sequence="1" source="Aimbase">aimbase_manitou-209168</id> <requestdate>2024-05-31T04:05:57+00:00</requestdate> <vehicle interest="buy" status="new"> <year>0</year> <make>Alumacraft</make> <model>Uncategorized</model> </vehicle> <customer> <contact primarycontact="1"> <name part="first" type="individual">Jason</name> <name part="last" type="individual">Chaffin</name> <address type="home"> <street lin
I am trying to build an inspection checklist app, where an inspection checklist appears after selecting that equipment from a dropdown list. I am pretty new to building apps in Quickbase, and I have the dropdown list of all the equipment created (I used the multiple choice form). Once a specific machine is selected on that list, I want to somehow display a checklist that is specific to that machine. Any thoughts or help would be appreciated.
Hi there,I'm still relatively new to Quick Base, but I was wondering if there is a way to filter a report based on the user role. We have two different levels of staff - Reviewers and Team Leads, and I've created roles for each. There's also a field for each in our reviews table. Each review has both assigned to it. However, Team Leads can also be assigned as a Reviewer, with someone else as the Team Lead. I want to create a report that excludes anyone from the Team Lead level. I know you can use filters such as where Reviewer <> the user listed in Team Lead, but as I mentioned above, a Team Lead could be assigned as the Reviewer with someone else as the Team Lead, so that wouldn't work. Is there any way to filter based on their role? Thanks!!------------------------------Brittany Zane------------------------------
Hello everyone,I recently re-created one of my legacy forms to new forms. One subtle difference is that new forms forces line breaks between log entries while legacy forms does not. Unfortunately, this is impacting the form factor of my reports.Is there any way I can remove these line breaks from the rich text log? I have found this script as a report formula, but it does not work as intended.SearchAndReplace([RichTextField],"\n"," ")
I have an image table where we have uploaded all of our clients logos so they are stored within our APP. I would like to automatically have the company logo placed on certain forms in several different tables. Any suggestions as to how to do this?
Hello All - Here's my situation: I have a community app that captures Parents in the Parents Table (name, email, cell). I then have a Parent/Child relationship (no pun intended) to the Child table [Child 1 (name, age, dob), Child 2 (name, age, dob), Child 3 (name,age dob)]. I would like my workflow to look like this:EOTI audience visits my registration linkParent registers by entering their initial information (regular html form to parent table)Parent receives email confirmation of registration (pipeline to mail chimp)In the body of the email, there's a series of welcome text and other information. At the bottom, there will be a link that says "Click here to complete registration and add children." The link will allow them to add 1 or many records to the Child table.The only way I can think of to achieve this is to create a Pipeline:Trigger - QB Record CreatedAction - Outlook Email - where the body of the email contains the Add Record API URL linked to the
I have a number of pipelines I use to sync two quickbase tables. Basically, quickbase sync but it runs in real time as opposed to hourly among other benefits. No issues building the pipeline, but curious if I can save myself some time. I have multiple copies of the same table in multiple apps. They all have a single source table in a single app that acts as the source. These pipelines sync the records from the source table to a number of different tables in different apps with the only difference being the filters that determine which records are synced to which apps. (umbrella company has a number of independent business units that operate differently / separately sharing a single shared financial / accounting system) Each of these synced tables has additional fields that are unique to those tables, but those fields aren't part of the sync process (most are formula or relationship fields)The field NAMES are always the same in the s
This is purely for me to test notifications on my account. I am logging in under different accounts and using this dummy discussion so I don't flood another email string with test notifications. Thanks all :)
Hello all,I am currently building out a series of pipelines for notificiations for specific departments based on activity happening within our quickbase database. I have a user requesting to be mentioned or tagged in notifications that we send through pipelines to our microsoft teams channels.I have attempted to use @ as i would in teams, and with the simple text, it has not worked. Is there a way to mention / tag people in automated messages that are coming from the pipelines / microsoft teams integration?Thanks,Ben------------------------------Ben Dellsperger------------------------------
Hi allI am creating an interest calculator report for our finance folks. I have a duration field to count the number of days between key dates for interest calculations but am running into 2 challenges:The number of days between dates comes back as duration (# of days) and not a numeric value. I need it as a numeric value to complete interest calculations.There are hundreds of loans and we need to be able to fill in the date interest is applied for all of them at once for the calculation. Ideas or is grid edit the best option?Thanks!Jesse
I have a webhook that takes a formula list field, and enters into a scalar multi-select list field.It works perfect unless the formula field is blank. Then it doesn't clear out the scalar field. I tried setting the formula to 'null' but it didn't like that syntax. Anyone know how to make this work?
Hi, What I want to do:I want the "Year" fields to derive which year it is based on the Business Case Start Date. but I don't want the year to be static.The fields I feel are important:[YEAR 1][YEAR 2][YEAR 3][YEAR 4][YEAR 5][BUSINESS CASE START DATE] - The "YEAR" fields are called just that. They are Formula-Numeric (currency) to let us know how much an employee will cost for that year. The Business case can start at any time during the year, and they go on for 5 years. So really I would need to know the Year of [YEAR 1], and then need to know how I add 1 year for each year after.
Hello,I have a form with a Text - Multiple Choice input element which has a list of states I wish my users to select from:ArizonaCaliforniaTexasThe value from this Multiple Choice input writes a value to a field named STATE in the table:[STATE]ArizonaArizonaTexasCaliforniaTexas What I want the form to do is write the abbreviated name of each state into the STATE field: [STATE]AZAZTXCATXI know with HTML forms, you can use values in your tag for each option (see below); how do I achieve the same in Quickbase?<form action="/action_page.php"> <label for="state">Choose a State:</label> <select id="state" name="state"> <option value="AZ">Arizona</option> <option value="CA">California</option> <option value="TX">Texas</option> </select> <input type="submit"></form>Thanks
is there any way to link a calendar report to default to show day or week vs month, and then to go to the specific day or week you are looking at?
Is there a way to "turn off" the legend? For example, these two charts don't need the superfluous "# of projects" on the bottom. Is there a best practice here?
I'm trying to figure out how to work an exclusion in my formula. I am trying to calculate the sum of all records cost for a certain director but only for trips where the member actually traveled. If the member did not travel, a checkbox will be checked to exclude those records from the total cost.This formula almost works but once I check a "Did not travel" box, it excludes all costs when I just want it to exclude the records that the "Did not travel" box were checked and calculate the sum of all others. If((([L3]="Caty")and([Did not Travel]=null)),(SumValues(GetRecords("{33.GT.01-01-2024 and LT.12-31-2024}"),55)),0)
We have a checklist that's being used on mobile. Right now you click the record, which opens the 30 or so "check list" items, and then you have to click each one to open it, and then click the pencil to edit it.Hoping to cut down on clicks and potentially open the record in edit mode on mobile, but I can't figure out how to do that!
Hello:I have one application with many tables. The two tables in question are:ApplicationsStudent Demographics.Applications Table Fields and Types:Name (formula-text)Phone Number (formula-text)Email (formula-text)Student Demographics Table Fields and Types:Name (text)Phone Number (number)Email (email)ValuesName Field ID: 7Table Alias: [_DBID_STUDENT_DEMOGRAPHICS])Table ID: btn82xxxxGoal: I am trying to look up the name, phone, and email fields in the Student Demographics table and transfer the data to the Applications table (without a relationship) using a formula.Challenge: I am receiving different error messages."Expecting text but found number.""Expecting text but found record list."GetRecord(7,[_DBID_STUDENT_DEMOGRAPHICS])GetRecord(7,"btn82xxxx")Questions:Am I using the correct function?Is the Record ID the same as the Field ID?Am I correct in selecting a formula-text field type for the phone number and email fields?Thank you,Roula
If I change the list of drop-down value selections in a field, will historical records with values that are no longer offered in the list be preserved? I'd like to change the available values for my team, and then go into the table and do a batch edit to change all of the historical records.
Greetings,In order to populate one of the tables in an application, a user is downloading a large CSV (over a million rows) from a database, and loading that CSV into google drive, so that it can be imported into QuickBase daily. It is on replace mode.This means that records are only added/removed once a day - and not on a steady state. Because of that, there is a delay throughout the day.We have an opportunity to have the records updated from this service in the json format - which would reduce manual effort, and give us a near real time view.We attempted a test, but the response was: { "data": [], "metadata": { "createdRecordIds": [], "lineErrors": { "1": [ "You don't have permission to add records to this table." ] }, "totalNumberOfRecordsProcessed": 1, "unchangedRecordIds": [], "updatedRecordIds": [] } } Authentication was checked out, and service was able to add records to a non-connected table with the same authe
Summary: Does anyone know how/if I could capture the responses to an Outlook Event that was built from my app? Using pipelines, I can retrieve the Event, but I'm having trouble getting it to recognize the individual attendees and match them to a Participant record in the app. Details: I have a Meetings table that can, if requested, trigger a Pipeline to create a corresponding Outlook Event and retain the Outlook ID on the Meeting record. The Meeting record is parent to the records in a Meeting Participants table. When the Outlook Event is created, it uses a combined field to grab the email addresses of the Outlook attendees. In the list of Outlook Event fields that I can be referencing, I see that Attendee is one, with email address and response. So my goal is to have each attendee matched to the Participant record. But I believe I need another step to separate out all the attendees. I tried asking the pipeline to dump all the attendee data ({{b.attendees}} into new field on the tabl
What is the best way to generate technical documentation for my Quickbase app so that a future administrator will understand how it works? For context, I am self-taught in QB and not a programmer so I have no experience in this area.------------------------------Terri Bruce------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.