Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
HelloI have a parent table - "Shifts" and a child table as "Shift Sign-Ups". How can I automatically mark the shift in the parent as "Full" - once there are two sign ups in the child table? I also want the "Shifts" parent table to automatically color coded to show shifts that are full vs those that are not full.Thanks,------------------------------Lashell Thomas------------------------------
Is there something which would cause an automation to turn itself off?I built a new automation that adds X child records when a button is clicked, where "X" is number field on the parent record. (I had posed a question last week on how to do this where it loops through the automation, counting down). I had tested this, and it worked fine. I put in quantities of 5-10 for testing. It looped through the automation the correct number of times, a little slow, but no problem.Today my colleague noticed it stopped working in the middle of adding records to a table. In this case, "X" was set at 108. It ran through 102 times creating 102 child records and then apparently the automation shut itself off. I know this because when I looked at it today I could see the automation was off. There are only two of us here with the admin rights to do this and neither of us did. I can see the countdown quantity is now at 6. Is there some
Hi, I submitted two questions yesterday and did not get answers yet. Do I need to re-post them?Lashell------------------------------Lashell Thomas------------------------------
I need a total time worked for the day. But not all employees take a lunch. Right now this formula comes up blank if the employee didn't take a lunch. Total Day Worked=[Time Worked Formula]-[Lunch Formula]I know I need an IF statement but not sure how to write it.------------------------------Cassie Hubble------------------------------
Hi all, wondering if someone can help with this. So we have some buttons in our apps that we use to quickly create an email. We use a combined text field that contains all of the email addresses and the button formula looks like this..."https://mail.google.com/mail/?view=cm&fs=1&to=" & [Emails of Project Team] & "&subject=" & URLEncode("Project Team Email: " &[Project Name] )This button opens a new gmail tab, adds all the email addresses into the "To" field and populates the subject line too]Now here's the question...Can we do the same thing for calendar invites? So could we have a button that opened a new google calendar tab, created a new event, populated the emails of the people into the "Attendees" and populated the event name with the project name. The date and time doesnt matter, the user can edit this. The point is we want to make it easier to create a calendar event with the project teamAny thoughts or help would be appreciatedThanks------------
I figured this would be easy but i can't get it to work, basically I'm looking to list numeric values possibly with a tag. Basically I have two fields, lets call them Boys and Girls both numeric valuesI want to show them in one field in a calendar view as: "Boys: 5, Girls: 2"I figured you could do some kind of List("," "Boys:"[Number of Boys], "Girls:" [Number of Girls]) but since they're numeric it doesnt work- is there anything similar to this that will do what i want?------------------------------Korrie Clark------------------------------
Hi All,I have received a notification "...approved by empty", even the person who provided his approval is a registered user and has inputted his name in the approval field, the same way it was done by the previous user.Anyone has similar situation? Is it probably connected with the User settings?Thank you.Iryna------------------------------Iryna Pylypenko------------------------------
Sometimes when I finally puzzle something out, I feel like celebrating by sharing -- in the hopes that it'll save someone else hours of forum trawling.Use Case -- using pipelines to create an audit log table of changes to a production record. Sometimes the record will have a date that will change, sometimes it'll have a date that was added. Think: Step A) customer ordered something, Step B) customer had the thing installed .. first time we get the record, there won't be an installed date, second time, there will.I can pull the original installed date from step a using $prev -- eg a.$prev.installed_date .. but if it's empty, pipelines will return an error 'Validation error: Invalid date/time value: 'If the date / datetime is empty, it has a string value of 'None'In the pipeline, I set a conditional to an advanced expression evaluating to TRUE: {% if a.$prev.installed_date|string != 'None' %} TRUE {% else %} FALSE {% endif %} I then know if the $prev date was set
When Quickbase announced they were going to support Multiple Roles per user a while back, I got very excited. I have SO MANY use cases for my app that NEED this feature.Unfortunately the way it was implemented has not worked for any of my use cases, and I am not able to use Multiple Roles in their current configuration in any of my Apps.Currently, Multiple Roles works like this: Role A: View Fields 5-8 on Records 1-10 Role A: Modify Fields 7-8 on Records 9-10Role B: View Fields 3-5 on ALL Records Role B: Modify Fields NONE on Records NONERole C: View Fields 1-2 on ALL Records Role C: Modify Field 1 on ALL RecordsLogically(at least to me) you would expect that someone assigned to all 3 of these Roles would be able to: View: Fields 1-5 on ALL Records, and Fields 6-8 on Records 9-10 Modify: Field 1 on ALL Records, and Fields 7-8 on Records 9-10But that's not how Quickbase Roles work. Instead:If you assign someone to Role A and Role B and Role C, they're new p
I want my formula checkbox "checked' when either Date1 or Date2 has an entry. What's wrong with the formula below?not IsNull([Date1]) or not IsNull([Date2])------------------------------Roth Hensley------------------------------
How can create multiple records based on a multi-select text field using pipeline?So I can get the easy of a drop-down with the power of a join table....If you can share the detailed solution that would be great.. Really need some helpLashell------------------------------Lashell Thomas------------------------------
Hi everyone,I've just begun with quickbase and i need help with this problem:When creating a new sale record classified with a specific sale type, i would want to automatically create a new record containing the same values of the first one but with the amount multiplied by '-1'.Example:Record ID: Costumer Sale Type Inovice nº Amount1 John CON 32 500$Record ID: Costumer Sale Type Inovice nº Amount2 John CON&nb
QB Update: Update: In late 2021 New and Updated Flags will be reach End of Life and will no longer be available, and this post includes information on this feature. Use report filters and formulas to dynamically filter and flag records you want your users to act on. Unlike new and updated flags, as an app builder you can rely on your reports and formulas to behave consistently for all your users.[Learn more about: Quick Base’s general approach to retiring features | New and Updated Flags retirement]I realize that many people don't want to see the new/updated flag, but I've got some people who LOVE it. In fact, I have created reports on all the tables in their app that shows only new/updated records so it can be displayed on their homepage, which is easy enough using the checkbox to do that at the bottom of the report definition. However, we have hit the 9 report limit on their homepage and they want more. It seems to me that these new/updated reports are largely wasted spac
I would like to have a pipeline run x# of times based on a [QTY] field in the Parent record.I have a Parent Record and turn "checkbox" true, the pipeline runs data and Creates a Child Record with pertinent data.I have field [QTY] in the Parent record, I would like the pipeline to run (n) times based on [Qty] output.Is this possible?------------------------------Rob G.------------------------------
Trying to determine if Pipelines has an option to: 1. Start a report manually by clicking a button or checking a check box 2. Send the output of that report (a .csv file) to a sftp server. George Romanowski Ops Change Mgmt – Sr. Securites Operations 571-382-5520 1551 Park Run Drive McLean, VA 22102 The information transmitted in this e-mail is for the exclusive use of the person or entity to which it is addressed and may contain legally privileged or confidential information. If you are not the intended recipient of this e-mail, you are prohibited from reading, printing, duplicating, disseminating or otherwise using or acting in reliance upon this information. If you have received this information in error, please notify the sender at Freddie Mac immediately, delete this information from your computer and destroy all copies of the information.
Hello, I really hope someone can help me with this. Here's the formula I tried:If([1099-NEC (Checkbox2)]=true,"<b>CONTRACTORS (1099-NEC)</b> <br>Company Name/Individual's Name:<br> Contractor's Address:<br> Contractor's EIN Number / Individual's SSN:<br> Amount Paid:", " ") Using the formula above, it auto-populates the field when checkbox is true but it won't allow me to input text on the field anymore. Basically, I just want to populate the Rich Text field with this format: CONTRACTORS (1099-NEC)Company Name/Individual's Name:Contractor's Address:Contractor's EIN Number / Individual's SSN:Amount Paid:I can achieve this if I use a regular Rich Text field and set <br> Contractor's Address:<br> Contractor's EIN Number / Individual's SSN:<br> Amount Paid: as the default value. The problem is that I have 12 of this field, and when I add those fields in the email body, it shows up like this:CONTRACTORS (1099-NEC)Company Name/Indiv
I have a webhook in one of my tables that creates a new record in another app's table when it is triggered and populates it with data from the current table. I am able to get the webhook to run but once it runs, the new record is not created and there are no errors that are populated. Has anybody else face this sort of issue? I am using JSON and have posted my request body below:{"to": "table-name","data": [{"42": {"value": [Merged Project - Source Record ID#]},"16": {"value": "[Additional Information]"},"40": {"value": [Client Contact Record ID#]},"44": {"value": [Form Reference #]},"11": {"value": "[Date Created]"},"35": {"value": "[Commercial Job Price]"},"9": {"value": "[Job #]"},"122": {"value": "[Ground Mount]"}}]}thank you in advance!------------------------------Automation------------------------------
I know that when you use cross app relationships, resources are shared, where as if something is populated via Pipelines or a Sync table, they are not shared resources.However, a table to table import may share resources, and I believe even something like a report link will share resources. My question is this:Are the resources only momentarily shared (so for example when someone is looking at the report link, or the table to table import is running at that moment in time the resource is tied up), or is it more significant than that?I've had it explained to me that in a sense, my app is being run in one of QuickBases' 'lanes', but if I have cross app relationships, now all my apps 'travel together'. If I have a table to table import, or just a report link, have I now tied all those apps together as well? Does having a single report link do as much damage as a full cross app relationship? Same question for table to table import, etc...------------------------------Mike Tamoush----------
We are uploading a ton of files daily. We got box so it would auto upload them there as mass downloads in Quickbase are not a thing (which sucks)We have a folder for each client. Then when we add a new car (we are an auto shop) it has an RO# associated with it. Box makes a new folder in the clients folder using that RO# ever time we add a new car to Quickbase (its a table) That in pipeline works perfect. Instant folder that is named after the RO# for that car. Awesome. But when I put in the pipeline to then upload the new documents that the user uploaded to that new folder... it fails. If we wait like a day or so, then upload they seems to work then. it's like pipeline and box talking to each other has an issue with files instantly created. If I tell pipeline just upload it to the client's folder it works. But then we have 100s of files not in their correct RO# folder. We have to manually move them and its sucking up a ton of time. we also cant wait a day, this needs to
Hi,I am trying to create an app that would track employee attendance daily. I want the supervisor of that employee to be able to open the record created for that employee and mark them as in office/out of office. Is there a way to put a calendar on a form so they can click the day's date and mark that employee present?Thank you------------------------------Fatima Khan------------------------------
As you continue building out your application, you may find that you are collecting/tracking a significant amount of data, and that not all users need access to all the data that is being collected. Some of the data collected may be sensitive or of no real use for the user. If a user has no use for the data, why should the user see the data or have the opportunity to accidently edit/erase data irrelevant to them? Have you ever worked in a shared document and have someone else accidently delete data you need? (I have been the culprit once or twice…) It can be an extremely frustrating and defeating problem to deal with! QuickBase once again, makes it easy to solve for this problem by allowing you to define who will have access to your data and how users can interact with the data. My Key Aha moment: What hit me about roles and permissions was about access to data; not everyone should be able to see, edit, or remove data from an app. So, when you start saying to yourself 'These pe
Hello, I am trying to figure out how/why my QB is doing this.I have 3 tables I am trying to work with. The main table is "Jobs", 2nd Table is Documents, 3rd is "Permits". The issue I am having is when I add a document via the Jobs table it links automatically (see attachment called linked id), however when I try and add a document via the permits table it does not automatically link... (See attachment ID not linked). When I look at all the field settings I can't find the issue.------------------------------Scott Hunter------------------------------
Hey everyone! I've got two issues in trying to finalize a pipeline with Formstack documents.1. Does anybody know how to insert an image within a table? I know how to get it working for inserting an image somewhere in the document from the main Quickbase record, but not for each line item of a child table. 2. And, I'm also trying to figure out how to get it set up to merge multiple child tables. For instance, currently I have it set up to loop through child records like invoice line items, but I also need it to be able to loop through items from a child schedule table. I've looked around quite a bit in the documentation on QB and in Formstack and haven't really found anything to help on either subject. I'd love some guidance. Thank you! #Formstack #Pipelines #mailmerge------------------------------Elena Larrabee------------------------------
Hi,I have a member table which is the parent table to reports. I also have a draw dates table that is a grandchild of member table and child to reports. What I need is a report that gives me the latest draw for the member and the result of that draw. Is there a way to get this information without making a direct relationship between member and the draw dates table?Thank you,Sandy------------------------------Sandralee Oster------------------------------
I'm trying to set a key on a table based on a Salesforce data that I'm syncing. However Salesforce, whilst having a unique key for the data is case sensitive, whereas QB isn'tExample - I'm importing the following rows of data from Salesforce, which is all unique (case sensitive). AABBAABbAAbbAaBB...however if I try and set these rows in QB it says there is duplicate data is QB isn't case sensitive.Question - is there a way to force Quickbase to see a field as case sensitive so that I can set this field as the primary key?------------------------------Peter Grant------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.