Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Good day,I have created a ticketing system that has multiple field such as "Applicable Sites", "Description", "Title" etc. that's important to each ticket and to do RCA from the statistics. Is there anyway to generate such a ticket/record from an email? As in, I send an email to some QuickBase email or so that can forward to QuickBase and automatically generate a record?I know this would have somehow have to identify which information is going into which field, but is there a way to have something embedded into email like a form or what that can be used to identify the fields?So I guess this question goes further than just QuickBase, but I would like to hear if it's even possible to generate something from an email.Thanks in advance!------------------------------Aylana Vorster------------------------------
I have two tables: "Projects" and "Cost Centers"In the project-table record there is a cost center section where one or more cost center records can be added. The cost center table has a "Budget/Cost Center Owner E-mail" field, which is an e‑mail field type. There is only one e‑mail address per cost center. When a Cost Center is added to a Project record, I would like an e‑mail notification sent to the e‑mail address in the Cost Center record, but I want it to provide in the e‑mail body, information from the Project record. The owners of the e‑mail addresses may not be users of the app, which is why I'm not using a user field. The purpose is that we want the budget/cost center owners to be alerted when the cost centers they are responsible for are linked to a project. Is there a way to do this in QuickBase? Also, this app is still in development so if there is a better way to accomplish our objectives, I can restructure things. For example, if using user field
Hello Quickbase Community, I need to create a button where I can edit a record from another table [_DBID_CLIENTES] related to my current table [_DBID_AUTOS] and return to the previous site. Example: I am associating a car to a customer but I need to edit the data of that customer and come back.Regards,------------------------------Herberth Solano------------------------------
Say I have an Inventory table of units of different materials where each unit of material is it's own record containing details about the material in that unit. And say I get 22 boxes of the same material in on a shipment with identical details. Is there a way to say enter all the information once and then have it created 22 times?------------------------------Chris Swirtz------------------------------
Hello!I have created an application to track employees leaving the company. I currently have a reminder email being sent out 3 days before the employee's last day at the company. The problem is sometimes the when the entry into the QB table is completed, it's already less than 3 days away, which won't trigger the reminder email. Is there a way to set up a reminder email that will capture those that were entered with only 2, 1, or 0 days remaining, without sending multiple emails for the same entry? I had thought about creating 4 different reminder emails to capture 3, 2, 1, and 0 days away, but I don't want to end up having 4 emails regarding the same employee. The only other thing I can think of is if I do a report instead, but again I'd have to send that out daily to capture any possible date an employee is leaving the company.Thank you!------------------------------V W------------------------------
How can I manage reports created by denied users?This is a long string of if > thens, and the above question may not even be the correct question. I need to remove some fields from my table, but they are used in many reports. I've instructed users to update the fields on their reports, but, of course, people don't do what they're told. If I go ahead and delete the field (or make it un-reportable), current users will receive an error saying that the report doesn't work. Either the field is being displayed or used in a filter or some other configuration option. When I look at the fields' "usage", the fields are still being used on many reports (in some cases, over 700 reports). I found out that some of the reports are created by denied users, but some are still current users. I cannot see the "Owner" of the report on the Field Usage screen (is this a separate issue?). I think if I can at least remove the reports created by denied users, it will be easier to figure out whose reports
it is possible to change the type of data to a field of a table that is generated automatically by QuickBase?------------------------------Maria Del Carmen Ortiz Garcia------------------------------
Good Afternoon All,A little context before I ask my question: I am putting together a report for a customer that is requesting some information (date, departure location, passengers, etc.). She is requesting to be able to see all of the passengers that were on a certain trip. I have most of the data I need available in one table, while the passenger names are stored in a different table.I have created a report link field that will pull the relevant passenger names in accordance to the trip number, but cannot figure out how I can get the passenger names to display on the report. As of right now, the report link only displays the trip number, and not the passenger names.Does anyone have experience dealing with this kind of a situation?------------------------------Aidon Olligschlager------------------------------
Hi,I have created a many-to-many relationship table between 3 different tables and need to create a report link in one of the parent tables that will filter records based on matching 2 different sets of fields in the child table.Is this possible, and if so, how can this be done?For context, I have a table of assets, a table of countries and a table of contracts as parent tables. The approvals table contains records of which person is approved to work on a contract in a certain country.I am looking to pull a list of approvals onto the asset form which will only include approvals that match both the country the asset is linked to and the contract the asset is linked to. The report link currently will filter either on the related contract or the related country, but not on both.Has anyone ever done something similar, or have any suggestions for how this can be achieved?Thanks in advance!------------------------------Orla O'Reilly------------------------------
Hello,I have a field which is rich text and stores the Names in Chinese Language of members. But when I am extracting the report, the values of the field are coming up with some encoding. Below is the screenshot. The column B with Phonetic Name is getting extracted in encoded format. I need the actual value (Chinese format) that is stored in the rich text field when extracted.------------------------------Sam Shah------------------------------
I have two tables, a source table that receives a CSV daily, and a destination table that is interacted with by users. The source table drops in multiple records with the same order number. The difference between each record is that in this other program (the source of the CSVs) is listing any notes/messages on the order as a separate line. I want to concatenate them in a text field in order of their posting. How would I go about doing that?------------------------------Davis Ward------------------------------
I am trying to assign a category ("On Time", "Past Due", "Exclude", and "Error") based on specific criteria (Installation Stage and dates). After which, I will create a pie chart showing the number of On Time Installations v. Past Due Installations.Exclude Return "Exclude" if the Installation stage equals "Refused", "Cancelled", "Remove from Scope", "Pending", and "3rd Party Pending" Errors Return "Error - No Target Date" if the Installation Stage equals "Installed" or "Planned" and the Target Date is blank On Time v. Past Due If Installation Stage equals Planned Return "On Time" if Today() is less than or equal to than Target Date Return "Past Due" if Today() is greater than (Target Date + 3 days) If Installation Stage equals Installed Return "On Time" if Actual Install Date is less than or equal to Target Date Return "Past Due" if Actual Install date is greater than Target Date + 3 days) ------------------------------Jennifer Hall------------------------------
I have a project number field and it can be listed multiple times. I need to first group the project numbers to be counted as one record, then a count of the number of projects. Having a brain fart, need some assistance.------------------------------Marjorie McKenna------------------------------
I've setup a pipeline to upload a completed Docusign document when a Prospect electronically signs the document.It's working fine, but it uploads 2 documents separately each time. One of the uploads is the document, and the other is all the Certificate info about the doc. This isn't needed.Is there a way to make it only upload the document, and NOT also upload the Certificate as well? In the pipeline, I'm using this jinja for the upload: {{b.file_transfer_handle}}Thank you for any advice!------------------------------Dana Hauser------------------------------
Good morning. In a relationship there is table A(parents) and table B (childs) .Since my beginnings in quickbase I have question... ¿Why does quickbase allow you to delete records from table A regardless of whether it has a related child in table B?Marcelo Benavides Torres------------------------------Marcelo Benavides------------------------------
I had an interesting use case where I needed to create a single Parent Parent RMA when child Parts Returned were created on a Service Report.So One Service Report has many Parts Returned.One RMA has many Parts Returned.The issue I ran into was that Parts Returned are entered in Grid Edit mode as Children to the Service Report. When I set up the Pipeline I encountered what i believe to be a "race" condition where by multiple Children were creating a an RMA parent. I have a search step to check for the existence of the correct RMA Parent, but since the children were all created at almost the same time when the grid edit was saved, I was getting duplicate RMA parent created.My solution was to introduce a random pause step using the clock channel with a delay of{{ [0, 1, 2, 3, 4, 5, 6, 7, 8 , 9, 10,11,12,13,14,15,16,17,18,19,20]| random /2}}secondsThis, I believe is causing a delay of between 1 and 10 secondsThis also worked, o probably a better option. It causes a
Hello, Is there a way to copy an existing App to duplicate to a new app. Then minor modifications can be made to the copy.------------------------------Kerri McKean------------------------------
Hi all,Anyone know of a qay to edit kanban report fields on the fly? I use the kanban report for a priority tool for workload. I have a field, priority, that is set to color code the cards Red = High, yellow = medium, low=green. My users get frustrated having to hit the pencil to edit, change priority dropdown, save, wait for screen to reload etc.------------------------------Ivan Weiss------------------------------
Hello Community,I need to be able to have different versions of parameters in a dimension table, depending on a given time period. I wonder how to solve this in Quickbase.Simplified example:T_PRODUCT_PRICESID, NAME, PRICE, VALID_FROM, VALID_TO1, Milk, 2.00$, 2022-01-01, 2022-03-311, Milk, 2.50$, 2022-04-01, 2022-09-301, Milk, 3.00$, 2022-10-01, <<null>>T_ORDERPRODUCT_ID, PRICE1, 2.50$=> How can I get the currently valid price and use it in a relationship with a facts table?Are there any best practices in Quickbase?Kind regards,Martin------------------------------Martin Suske------------------------------
Hello, I would like to freeze the first few fields (columns) in table view. We have tables with many fields and when we scroll we'd like the first four to scroll with us. How can I do this? ------------------------------Meagan McOlin------------------------------
I have an application where employees can request vacation using a start and end date. I have a duration field that calculates how many weekdays are in the range. I need a pipeline to create a timecard record for each of the days requested once the PTO request is approved by HR, but not sure how to create multiple records based on start date and duration fields. Ex: Vacation Start Date: 11/3 Return to Work Date: 11/8 # of Days off: 3 (weekend in between). Now I need to create 3 timecards for 11/3, 11/4, and 11/7 for payroll.Any help/guidance would be appreciated!------------------------------Curtis England, Trinity------------------------------
First post here! Been working with QB for awhile. We have a table, call it table A with some costs. Table A has a child table, table B. Costs are entered in table A. There's another table, table C that has costs for the items in table B. I'm racking my brain trying to figure how to build a pipeline (I assume this is what it needs to be, because we need table C to be the final "source" for costs) that will take the costs in table A, divide by how many child records are in table B and linked, and then create new records in table C.Example, I put $100 in an allocation group (table A). There are three sub items in that allocation group (table B). I need my user to be able to pull an item report with costs that shows $33.33 (okay bad example with the repeating) per item. ------------------------------Jeff HughesFounderpointflow.co------------------------------
I have a complex multi-table App used as a Project Management System that supports our End-to-End process from Intake, Governance, Prioritization, Resource Assignments, Status Updates, Multiple Releases, Risks/Issues, Actions, Decisions, Change Requests, etc. Our main Project Table has 17 traditional Parent/Child relationships.We now need to create a 'Same-Table Relationship' to associate numerous projects that are funded under a Big Brother (sibling) project.Use Case: Some projects are funded uniquely and do not have associated sibling projects that are associated. Some projects are Big Brother Projects that are managed as a big complex project and also provide funding for Little Sibling Projects (that are not uniquely funded). All Projects that will be funded have a Yes/No condition whether or not the project is a Funded project which also means that it is eligible to be a Big Brother project from a funding perspective. The creation of the funding relationshi
On my parent table, Accounts, I have a rich text field where we add account related notes. Is there a way to add this field to several child tables so that we can add notes related to the child record and then have it displayed on both tables?For example, if I want to add a note to an Invoice (child table) and have that note "logged" into the Account notes field on the parent table as well how would I set that up? And one step beyond, how can I show that the specific note is related to that specific child record? I feel like it has something to do with report links, but can't seem to get it right. The screen shot below is on the parent table, we can enter notes into either field, the Account notes on top is a rich text field and below is the report link field which I am displaying directly on the form and it editable. Ideally I just want to have the report link field show up on all the child tables to make is standard across the board. We currently go
Good Afternoon,I am looking to come up with a formula query, in a formula numbers field, that can calculate a score but also react to filters when placed on a KPI (gauge) report or dashboard. I created a simple query that gives me the correct value but if I add field references and in this case they refer to each other, waiting for input from the user the calculations are off.Is it possible to add references to the query below that would allow a user to edit it on a report? I am basically looking to recreate a version of SUMPRODUCT from Excel. (I know that I could have done this differently but with the order of operations in QB this is what worked from an expected value standpoint)var number INVYES = Size(GetRecords("{31.EX.'Yes'}"));var number INVNO = Size(GetRecords("{31.EX.'No'}"));var number POLYYES = Size(GetRecords("{32.EX.'Yes'}"));var number POLYNO = Size(GetRecords("{32.EX.'No'}"));var number RORYES = Size(GetRecords("{82.EX.'Yes'}"));var number RORNO = Size(GetRecords("{82.E
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.