Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
If I am tracking a field for audit log purposes, is there a way for me to find the history of that field? To see who has modified it?Or can I only look at each individual and see what they have done?------------------------------Mike Tamoush------------------------------
When you send out subscriptions to users, it hard codes their email. Well, our company changed our email addresses, so we all changed our logins. Now I need to go find any subscriptions and change the hard coded email. Is there any way to do this on a global level?Or do I just need to go through each table and look for subscriptions?------------------------------Mike Tamoush------------------------------
If a user adds a new reecord on a table form - is there a way to have the record or field copy to another table?------------------------------Alycn Bjergo-Justen------------------------------
How can I make a text-formula field with conditions to return Text if another (Date) field is blank?Here is what I tried and have error:(IsNull [ETA Destination Port],"In-Transit"),IsNull [ATA Destination Port],"At Port"),IsNull [Port Pickup Date],"Picked-Up"),IsNull [Empty Return Date],"Empty Returned")------------------------------Alycn Bjergo-Justen------------------------------
We are trying to setup the ServiceNow pipeline. The ServiceNow admins have given us an admin user, which they have verified has UI access to the records in the table object we are looking for, but we cannot see the table in the dropdown in the pipeline. If we type the table name for a query, we are able to return results but with no field data other than ID, create and modify date. We can filter the data on additional fields, but we can't pull results from any other fields. Anyone have any experience with the ServiceNow channel who can help us ask for the right things from the SNOW team?Thanks------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com------------------------------
Is anyone else having caching issues with the new table report style?If I have a filtered report and look at it, then add to the filter in the report, I can tell it is 'technically working' (the number of results will show correctly), but it will actually show all the old results in the table list. I can tell the browser (only tested in Firefox so far) is just showing me a cached image (which is curious because the # of results shows correctly).If I switch to the old report style, boom, it's perfect. Wondering if others have this experience.------------------------------Mike Tamoush------------------------------
Hello,I am wondering if there is a solution for the following:If the qty entered is more than 1, Id like to make a duplicate record for the # of qty entered. Meaning, if someone enters a qty of 3, I want it to create 3 individual records with the qty of 1. Maybe this is possible through quickbase actions or pipelines?------------------------------Process Distillery------------------------------
Hello Smart QB Folks!I have a lengthy process tracking the status of a commission sale within Quickbase. The final step is to export (i hope!) t all the records into a csv or etc that meet some condition so the folks can get paid. I can write the report, no problem .. I can export the data using the button on the report .. easy! But have all that automated so that the records' status gets changed to 'paid' (for eg), without having a number of manual steps, I don't even know where to start.------------------------------Malcolm McDonald------------------------------
I'm using a connected table (Quickbase to Quickbase Sync) but a colleague of mine is the owner for the connection. We want to change the owner to be a service account a few people in the IT team have access to, that way we don't have to rely on 1 person to always be available as changes are needed, but I can't figure out how to transfer ownership from 1 account to the next. There has to be a way right? Otherwise my only option would be... deleting the connection & making a new one from scratch? And that would mean downtime for the connection, plus lost audit logs/history of the existing connection.------------------------------Harrison Smith------------------------------
Hey everyone, I have a kind of complicated situation I'm trying to address. I've seen others ask a similar question on the forum and I haven't yet seen an answer, but here goes:I need to create a text field that is a concatenated list of related/child records on a parent record, so that it shows up as a text field on that record within a report. Essentially I have a table called "pull list items" and each item has a unique set of "support items" that need to be visible on a report of all pull list items on a form. I'm still figuring out the best way to structure this whole relationship, but I know for sure I'll need a way to copy these records as a list into a text field. Any ideas? ------------------------------Elena Larrabee------------------------------
I am getting a 404 errorhttps://quickbase.uservoice.com/------------------------------Don Larson------------------------------
I'm brand new to Pipelines so here is my issue. Any guidance is appreciated. Multiple Coaches bid on multiple Event Sessions. Each session has a start time and end time (Date/Time field). A single coach can bid on multiple Event Sessions. It's possible that they might bid on another session where the date/time and duration of that session may "overlap" another session they have bid on but they have not yet been selected on any (Bid Selection field). The Coach Availability field defaults to "Available." When a Bid Selection for that session is modified (particular dropdown choices are selected) for the related coach I want the pipeline to search for all other possible sessions that they have bid on that may overlap the time on that particular session and change that Coach Availability field for that session to "Booked" and change the Coach Availability field for all other sessions that overlap for that coach and that Session Bid date/time/duration to Unavailable. I have the first part o
We have created an app to gather data from several tables to provide consolidated reporting. I would like to be able to create a link from each line of the table back to it's original database. I can create the link, but it links all lines in my reporting table to a single original database, not the one specific to each line.For example Reporting table contains lines from Table A, Table B & Table C.If I create a link to table A as one of the fields in the reporting table, it points all lines to Table A. Lines from Table B are obviously not found in Table A. I don't want to have to create a different field for each Table, as this creates these extra fields on every line.A,B,C is a simplified explanation...we are using upwards of 20 tables to combine the reporting data.Any solution for this??ThanksVonda
These are the fields that I have: Checkbox Formula Field: Mod Finalized Required Case(false, ToText([Event Modification(s)])="", true) Checkbox Formula Field: Materials Finalized Checkbox If([materials_finalized]<Now(), true, false) Date Formula Field: Session Date ToDate([session_start_time]) Date Formula Field: Materials Finalized Date ToDate([materials_finalized]) Those all work fine. What doesn't work is the following formula Checkbox field: Materials Finalized on Time If([Mod Finalized Required]=true and [Modifications Finalized Checkbox]=false, false, (WeekdaySub([Session Date], [Materials Finalized Date])>=2), true) This field should have the following outcomes: If the Mod Finalized Required is checked and the Materials Finalized Checkbox is not checked: not checked If the Mod Finalized Required is not checked and the Materials Finalized Checkbox field is checked: checked and If the Materials Finalized Date is equal to
First time trying to connect to a Google Drive.I was pleased with myself that I got a pipeline to Search Google Drive and return a file name (yay!) and an ID (yay!) and then I was able to make this formula "https://drive.google.com/open?id=" & [ID] and lo and behold the file opened up.But how do I limit the search to a particular folder? Right now its searching every file which I have access to in Google Drive. I see a box to enter a folder but I don't know what syntax to use in that box. ------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------
I am trying to come up with a creative way to come up with the following:I have a list of costs in a table. The costs are broken down and could be an employee charging 4 hours, could be a hotel receipt, maybe it is a forklift rental. I want to show a report of these costs. However, when showing the employees, I want people to be able to see how many hours they billed, AND I want them to be able to see how much total labor costs there are, but I don't want it to be visible how much cost goes with each specific employee (essentially, I'm hiding employees rates).All I can think of is using a formula text field to show either hours or cost and then ALSO having a formula query go find the total labor cost and have that as yet another field. But then the report isn't that nice because the total under that formula field will not be correct.Any creative ideas?------------------------------Mike Tamoush------------------------------
Hi everyone,I'm not sure if it's possible, but it's what my boss wants for a particular report.I currently have a report for # of people registered for events, organized by health regions, and then by community. It looks like this (but with around 80 communities - so long and hard to read in this default format): Health Region 1 | Health Region 2 | Health Region 3Community 1 - 5Community 2 - 10Community 3 -
I am looking for assistance with a formula URL button to copy master details from a template record id. I can make the button work when I input the specific number of the sourceRID, but I want to be able to base the sourceRID on a variable template id. Is there a way to make this work? See below. "javascript:void(copyMasterDetailButtonHandler('&relfids=41&recurse=false&sourceRID=[Variable Record ID]\n\n\n&destrid=[Variable Template Record ID]" & [Record ID#] & "', 'bm8s38rgt'))" I'd also love the ability to have the button land me on another form where I have the parent record with this button on an embedded report. Is this possible?------------------------------Luke Furuto------------------------------
What the heck does this mean? I can't seem to figure it out.("1170 Martingale" is the name of the record being modified to trigger the pipeline)I have no idea what the export fields are referring to either. I can't even seem to locate a discussion on here similar to this. Any ideas out there? The pipeline fails to produce the action because of this error. Validation error: Invalid literal for Decimal: u'1170 Martingale' Input (Options) table:"bkcuzgpzg" export_fields:Array[6] 0:"112" 1:"7" 2:"159" 3:"148" 4:"157" 5:"177" Input (Mapping) related_opportunity:"{{a.opportunity}}" related_customer:"{{a.opportunity_contact_full_name}}" scheduled_for:"amanda@getnewclosets.com" schedule_status:"Scheduled" scheduled_date_time:"{{a.updated_at}}" related_company:"{{a.opportunity_company_name}}" activity_type:"Schedule LE"------------------------------Thanks,Chris Newsome------------------------------
I have an excel file with just under 11,000 rows of data. When I do a copy/paste to import, it works without issues. If I try to upload the file, the first 8000 rows or so seem to upload without issue. Then the last 3000 are missing a bunch of data. Anyone ever run into this and know what is going on?Screenshot of my excel data (notice there is data in all columns and all rows):Screenshot of import from file (suddenly the data in most rows is not there. Curiously, the Period is still there)------------------------------Mike Tamoush------------------------------
Hi, Considering I've a field "name" and number "rid" , I wanted to append "name" to Name+RID Currently I can create a new field and use {a.name}-{b.rid} , but can I update value directly inside a.name using pipeline ?------------------------------Prashant Maheshwari------------------------------
I have a text field titled Building Name and I would like to identify duplicate values in the Building Name field. I also would like to know how many for each - particularly in a summary report. Do I perform this with a formula query? If so , how?------------------------------Jason Tommy------------------------------
OK backstory how on this works to see the issue.... We have several Collision shops as clients. We track the cars they have on the lots to know what cars we will have to take and calibrate. We have a table for Vehicles we track. we have a field for RO# per car. The RO# is the # that the client uses in their shop. Works great. easy to find and look up. All our records match theirs and its smooth. We do not let them be Unique as different clients could use the same number. Super rare and not an issue as the car to the client and the VIN are unique. We add car. Pipline adds a folder with the RO# as its title under the client folder in BOX to store the photos. ALL GOOD.but.... 1 client. only 1 of our clients (the only collision shop in the area that does this as we server them all.) They just use the last name of the client. So now what gums it all up is same last names.. Smith, Anderson, Kim, Whatever... It has become an issue. They will not change as they don't care.&nb
I am looking for a way to automatically assign a task to a user when it is created. I would like to do this round robin style with a group of user.------------------------------Chris Curtis------------------------------
Hi,When I type it out, it seems simple but I can't figure it out.Background: I work for a real estate company where we often take on projects that have multiple units on the same area of land- think of townhomes.If I'm in a project record with "Units= X", I'd like to create X number of new property records in the properties table. I'm trying to achieve this with a pipeline, but I can't figure out how to iterate through a loop X number of times based on the value of a record. Please help! Thank you in advance!------------------------------Karah Weber------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.