Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am using Gant Plugin template and after some time I started to face problem with Saving any change I do in Plugin. I receive below Error.Any Idea how to solve it?------------------------------Adam Krzyzanek------------------------------
I am checking with customer support, but thought I would see if anyone can make sense of this.In one of my apps, one single user cannot add records or view calendars. In both instances the webpage just loads and is blank. It is only happening to this one user, and only in one app. We tried in other apps and it works fine. She can navigate through records and edit them. She cannot add a record (well, to be more specific she just gets a blank white screen) whether it is the Gen Add Record API or the =nwr add of a record. Same behavior across all browsers.The user is in the same role as a number of other people, none of which have issues. I also switched the user briefly to an admin role with full rights as a test, and the same thing happened.I cannot figure out how it can be possible to only have this happen in one app. Thoughts?------------------------------Mike Tamoush------------------------------
I have an Auto Numbering set up and used two of them in a test record. Is there anyway to reset to get those two numbers back?------------------------------Steve Venne------------------------------
Okay...completely new here so bear with me...We have a construction company focused on roofing and siding and I'm trying to setup our apps for customers > opportunities & tasks > work orders, tasks and expenses...So I created three different opps...I noted some overlap with work orders and opportunities under the customer manager tabs...and the fact that none of these are related to each other and sharing information and I can't figure out how to connect them...cuz help please?? I considered just working with the customer manager because it does have work orders/opportunities but I am not seeing more in depth use besides the form...no area for tasks or expenses so I'm lost here...Sure there is something very obvious that I am missing...please help. Thanks! ------------------------------Alicia Crews------------------------------
We need to be able to send multiple documents, if they are attached or not. I have this working, but if the middle document is blank, it will error out. If the first two have attachments but the 3rd doesn't, it's fine. Any thoughts?Attachment Name:{% if a.well_report_document.file_name is not none %}{{a.well_report_document.file_name}}{% endif %}{% if a.mud_report_attachment.file_name is not none %}{{a.mud_report_attachment.file_name}}{% endif %}{% if a.survey_attachment.file_name is not none %}{{a.survey_attachment.file_name}}{% endif %}{% if a.additional_attachment.file_name is not none %}{{a.additional_attachment.file_name}}{% endif %}URL:{% if a.well_report_document.file_transfer_handle is not none %}{{a.well_report_document.file_transfer_handle}}{% endif %}{% if a.mud_report_attachment.file_transfer_handle is not none %}{{a.mud_report_attachment.file_transfer_handle}}{% endif %}{% if a.survey_attachment.file_transfer_handle is not none %}{{a.survey_at
I am exploring Code Pages, doing some general learning about them and what you can do with them. I am wondering if Code Pages can display a value(s) from a specific table in the app based on a query formula or some kind of lookup value. Can this be done? If so, how? ------------------------------James Carr------------------------------
Hi All,I have an app with 4 tables. Projects contains basic project information, such as Name, Address, Size, etc. Three other tables contain details regarding milestones for project completion. MS1, MS2 and MS3 each contain details about the milestones to include a completion date for each one. How do I generate a report showing the Project Name, MS1 Completion Date, MS2 Completion Date and MS3 Completion Date. Thanks for your help.------------------------------Mike Sanders------------------------------
I'm trying to set up a formula field that will calculate the # of hours remaining needed for each employee to hit their target hours for the year. I have a static field w/ their goal target (e.g. 2000 hours for the year), & a field that calculates the # of hours already worked for the current year.I need to take the # of hours remaining needed (eg. 2000 goal - 500 worked = 1500 remaining) divided by the # of working days left in the year (# of days remaining in the year - weekends - holidays).I have a calendar table that contains a list of records designated as company holidays (4th of July, New Years, etc.) so I can use the start/end date for those records to count the number of holiday days remaining, but I'm not sure how to count the number of weekend days remaining, or how to put it all together. I'll also need this to be dynamic, so doing ToDays(Today - 12/31/23) to get the raw number of days left won't work. Is there a non-static way to code for the last day of the year?
Are Reminder Notifications from a specific report? If I create a specific report can I have that report in the reminder? The info that comes in the reminder is way too much information.------------------------------Steve Venne------------------------------
Hello,I am trying to figure out how to change dates on bulk records. Example: Software deployment over 10 days with 10,000 clients total with 1,000 clients per night. Say it was scheduled to start this past Monday 5/22 and run Mon-Fri through 6/2 (10 business days). Sometime before the start this deployment needed to be postponed by two weeks and it now needs to start on 6/5. How do make the changes. I have suggestions below from my Support case and I have done some Pipe line training but I cannot figure it out. Any help would be appreciated.Grid Edit:You can enter grid edit on an existing report and update the dates much faster. You also have the ability to copy and paste (Ctrl + C to copy and then Ctrl + V to paste on Windows) from one cell into another. So if you wish to update every date on the report (at least on that page of the report, you may have to go through multiple pages and update them), you can click one cell that has the date you wish to copy, copy it, then click on the
I'm not quite sure where to start with this one.I need to have an auto number added, but it has to be in text format to hold leading zeros, when a new record is added when a formula field changes to yes.Technically I'm creating a dummy tin that I need to start with 000000150So when a child record is added and the formula field on the parent record changes to yes, then I need to add this dummy TIN on the parent record. I need it to go to the next dummy TIN on the next record when the same situation happens. 150, 151, 152, etc.I'm thinking I might need a table that has a bunch of Dummy TINs and a field to be checked of when used but that is just my guess.Any Ideas?------------------------------Carol Mcconnell------------------------------
I have a situation where there are two tables and the parent table has two formula fields. One counts the number of child records and when that number is 10 or above the other formula field changes from No to Yes. What I need to when a user creates a new child record and the number of child records goes from 9 or below to 10 or above and the formula field on the parent record changes from No to Yes, I want a pop up to alert the user who created the child record.Not sure where I should start on this? ------------------------------Carol Mcconnell------------------------------
Hello, I am new on QB. I need to create a few fields related to timestamp. I have column called weight which is being filled in table. I need to create a column next to it which would record the date and time when the weight for that particular record was changed. I tried following in report formula, but it gives current time not just the time it was updated. If ([Weight] > 0, Now())Please help. I have multiple columns where I need to do this. Thank you. ------------------------------Imran Bijapure------------------------------
I have a table report that shows all the claims that we closed for the month prior. Sometimes we have numerous claims that share a customer name and order number because the customer may have a large number of items or they may be different claim types. We already have fields that provide the totals across all the customer's claims that have matching order numbers and those are the fields the report is pulling in. As such, I need the report to leave off duplicate claims with matching order numbers and only provide the information for the claim with the earliest record ID. That way, each customer will show only once on the report so that the totals on the report are correct. Is this possible using a report formula or some filtering setup I am not seeing. Thanks so much!------------------------------Rhonda Jones------------------------------
I have a table (Table 1) called activities where there is a column called activity. This is in effect the name of a collection of components. On another table (Table 2), i have the components that make up that activity. Table 2 has a column that references the activity from table 1 and a second column showing the component of that activity. There will be 2 or more components to each activity, each as a separate recordThen, on a 3rd table called orders, i need to be able to select the activity (dropdown via relationship from table 1) and then QB copy all of the components from table 3 into seperate rows. I can do this with pipelines but im afraid it may lose the connection to be able to be modified
Ok,I have been trying to build a report formula and am struggling to find the right "formula".I feel it's a unique situation as google, the formula builder and support haven't been much help. I have created a report that has "if the name is ABC and the Quantity is XYZ, then show it. However, I've run out of filter options.I need to do this for roughly 100 filter parameters.We use THOUSANDS of parts. But I only need to see the most commonly used. Example:"Sku is equal to the value P80U114 AND the Quantity on hand is equal to or less than 5"or"Sku is equal to the value P80TUBV1 AND the quantity on hand is equal to or less than 3"etc... we have many many skus we need data on. But the only formulas I can find is "If ABC is XYZ AND DEF is UVW then CHANGE Value to LMNOP"I don't need to change values, I just need to see them. Attached is a screenshot of what the type of report I am needing is.------------------------------Newman, Savi------------------------------
On one of my tables I have records that have fields that are not necessarily unique but the combination of 2 fields is unique. I have a field Requisition # and a field called Candidate Ref Num. Neither is unique on their own, but the 2 values combined create a unique value. I created a formula text field to combine these and marked it Unique. I hoped to use it as the Merge Field to import additional data to the record. Unfortunately it's not listed as a merge field (probably because it's a formula field). Does anyone have any insight into how I handle this particular problem? ------------------------------Thanks,Sheila Allas------------------------------
I'm trying to set up a formula field that will calculate the # of hours remaining needed for each employee to hit their target hours for the year. I have a static field w/ their goal target (e.g. 2000 hours for the year), & a field that calculates the # of hours already worked for the current year. I need to take the # of hours remaining needed (eg. 2000 goal - 500 worked = 1500 remaining) divided by the # of working days left in the year (# of days remaining in the year - weekends - holidays). I have a calendar table that contains a list of records designated as company holidays (4th of July, New Years, etc.) so I can use the start/end date for those records to count the number of holiday days remaining, but I'm not sure how to count the number of weekend days remaining, or how to put it all together. I'll also need this to be dynamic, so doing ToDays(Today - 12/31/23) to get the raw number of days left won't work. Is there a non-static way to code for the last day of the yea
I want to make a custom data rule that would allow only field to be edited based on my condition.I can't use a dynamic form rule because I need the rule to apply for Grid Edit.How can I do that?------------------------------Miriam Klugman------------------------------
I know this is probably answered in previous discussions, but I can not find it.I want to add an "Approve" or "Deny" button to the email that gets sent out via notification to their manager for a request of ETO. How do I do it?I have added a screen shot of the notification set up.------------------------------Jennifer Meyer------------------------------
Has anyone else experienced this? And, if so, did you/how did you fix it?Scenario: Three tabs within a section in a form. Three rules to show/hide the tabs based on a selection in "type of request". Problem: First two tabs show/hide tabs (and the fields in the tab) correctly with no issues. Third tab shows the tab, but doesn't show the fields within the tab until I click on the tab. Troubleshooting I've done so far... If I swap the third tab/fields in the form element order, it will display correctly. I re-arranged the form elements and it is always the third tab/rule that has the issue. I tried adding the fields into the rule, so show tab, show field, show field, show field..., but that didn't change anything. I am stumped. Thanks in advance for any suggestions/help.------------------------------Sherry Blackburn------------------------------
We are trying to consolidate the timecard from different applications into a single table (Aggregation) in a separate application.While doing that, we need to check whether the same employee has filled the timecard on the same day, for the same project, and for the same timecard type or not. If yes, the duration should be added against the existing project for the same day under the timecard type under the table (Aggregation). Otherwise, it should create a new entry to the table.How can we add a duration (from another field from another application) to a field (duration in Aggregated table), with its current value by pipeline?Also, we would like to know, how many such pipelines can be triggered from the same application in a day and its performance. What will happen to a pipeline if more than 50 triggers happen in a minute from the same table?It would be great if you can provide some insight into the performance of the pipeline.Please let us know if further information is needed.------
Greetings,I need to use the same look-up field (reference proxy) multiple times in a relationship. Is the only way to do this is to create multiple relationships between the same tables?TABLE - EMPLOYEES; FIELD - EMPLOYEE NAME (reference proxy)RELATIONSHIP - EMPLOYEES to PROJECTSI need to use the EMPLOYEE NAME in PROJECTS to assign MANAGERI also need to use the EMPLOYEE NAME in PROJECTS to assign ASST MANAGER------------------------------BuildPro------------------------------
Hi - I thought this would be easy to find an answer to, but I can't seem to find anything. I've used the CSV Import action in pipelines to import CSVs, but now I'd like to do the same with an Excel file - but can't find a corresponding action for that. Any ideas?
So, I have a "Request Date" field and a "Request Submit Date" - and right now I have them set to set to the current day, except what I would prefer is that the request date be the date that the request is started, and then the submit date be the day that it's submitted, which could potentially be a different date. Is there a way to do that? - I feel like there is, I just cannot phrase it in a way that the school of google helps.------------------------------Michelle Craig------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.