Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi All,I have a multiple choice text field with the below options for users:15 min30 min45 min60 min90 minWhat function can I use to obtain a Duration Value that corresponds with the user selection? I need to be able to determine things like averages and totals using the duration value.Thanks in advance------------------------------Troy MacPherson------------------------------
We are creating a public form with multiple sections. Using the new tab section makes the form looks a lot neater, which is great, but there doesn't seem to be a way for us to indicate to the user where they are in the form and direct them to the next tab. Does anyone know how to create a button where the user can be redirected to the next tab? Or save and redirect to the next tab, or a field that is in the next tab? Also, this is a very noob question, but where can I find the url for my form which removes the Quickbase header and tabs? And how do I embedd the form into an iframe? If it's embedded in an iframe, when I look at it on a mobile, does it default to the QB mobile view? Thanks in advance
Hello~When I copy and paste the lines end up with too much space between them. I have a screen shot showing what I typed and it was fine compared to what I copy and pasted into QB. I need it to be like the top part. ------------------------------Brenda SchafferBschaffer@jjkeller.com------------------------------
I have a multi-select field called [food] that can have any or all values of things like peas, corn, bread, pasta, chicken, etc. I want to run a pipeline that copies records from a template table into the today's menu table. I am using a search records step that has {23.HAS.{{a.food}}} in it. Field 23 is the field to match in the template table and it has only one value in it (like peas, or corn, or bread). It is now a text field, but I can change it to a different kind of field if it helps.The search works great when there is only one value in {{a.food}}, but if I have multiple values (like peas;corn), it fails because there is nothing in the template table that has peas AND corn in it.How can I find all the records in the template table where field 23 matches ANY of the entries in {{a.food}}? On a whim, I tried doing the query backwards {{{a.food}}.HAS.23}, but that failed even when field 23 was a mutli-select field.------------------------------Edward Hefter-------------------------
If anyone is looking for a position, I'm hiring a Specialist, School Planning in DC Government. Full-time, based in DC, option to work remotely 2 days per week (with lots of flexibility), and salary range is $83-$94K. Work with the School Planning team for DC Public Schools (one of the fastest improving districts in the country!) as we do long-term planning. The Specialist, School Planning will have three core tasks: (1) Lead the development of 5-year enrollment projections for long-term planning and annual enrollment projections to inform school budgets. (2) Manage an application (QuickBase) used by district leadership and school principals to review and petition enrollment projections (3) Assess the impact of school choice initiatives.I'd love to find someone already familiar with QuickBase, but am also very willing to help someone grow in that area. More than anything, I'm looking for someone who may be motivated by a position with immediate impact - enrollment projections are
Is this possible to do? Even just stopping the email change would work if the name change cannot be prevented.Right now a user is able to go to the dropdown in the top right of Quickbase and select "My Preferences" where they are able to change their name and email in Quickbase.Is there any way to completely remove this as an option or somehow prevent users from doing changes here? A user can change their email and cause issues downstream where they do not receive emails any longer, not a Quickbase issue but the issue spawns from a change in Quickbase.
Hey guys,I am looking for a way to create a button that creates and saves a child record in another table and then opens it in edit mode in a specific form. So far I've managed to create a button that creates and saves the record but opens it in view mode. That's the field code: "<a class='Vibrant Success' href='" & "my foreign table ID" & "?a=API_AddRecord&apptoken=myapptoken&_fid_9=" & [Record ID#] & "&disprec=1" & "'>Continue</a>" I played around with the disprec parameter with values different than 1 but to no success.I am trying to do this possibly without code pages as I am trying not to use JS.Your inputs will be greatly appreciated!Regards,Yordan------------------------------Yordan Petrov------------------------------
What is the best way to accomplish the following:When a record is completed and status is closed, only the record owner can edit?------------------------------Blanca Anderson------------------------------
1. Okay, I have a table and there is a UserList field of users that need to approve this record. I used the approval workflow from the Magic Buttons app. I would like to add a field that displays users that Have NOT yet approved the record.Any ideas? Is it possible? If it helps, I also have an activity log that logs the approvals.2. What is the best way to "lock" a field or group of fields to where only the creator of the record can edit?------------------------------Blanca Anderson------------------------------
I am trying to create a field (Distribution List) that combines the names listed in several User ListsToUserList([userlist 1],[userlist 2])It is not working. I'm using Field Type : Formula UserThe error message is expecting user but found user list.Help...------------------------------Blanca Anderson------------------------------
I am unable to figure this out. I was able to create the button itself, but not sure what code is needed to open a pop up message box. Here is what I have so far: "<a style=\"background: #4285f4; border-radius: 5px; padding: 8px 20px; color: white; display: inline-block; font: normal 700 24px; text-decoration: none;\">Confirm</a>"I need the button to also open a pop up box to display a message before the user actually saves the record. The button does not need to actually save the record, just display a message and have an 'OK' box to click.All I can find is Javascript and I know that can't be used anymore.------------------------------Amy Gosz------------------------------
Hello,I have a few buttons that at the end redirect the user after execution the action to the "default" form for the table. How do I change this so the redirect goes to the current form the user is on? The button is on multiple forms and I want to redirect them back where they came from.Thanks!------------------------------Ivan Weiss------------------------------
I obtained the 64-bit version of the QB Exact Form template and I edited the template with my form fields, etc. But when I select the "Save to QuickBase" option under add ins, I am prompted for my QB domain, Application Token, Username, and Password. It is not accepting my login because, I believe, my organization has SSO enabled. Is there anyway to get the Exact Form to work with SSO access? Or can I manually create the HTML files?In short are there any workarounds or am I not able to use Exact Forms if QB is set up to use SSO for access?I've opened a support ticket, but thought I would post to the community to see if anyone has encountered this and found a work around. Also, interested in suggestions for other options. Basically, I need to generate a simple memo that inserts values from certain fields (including items from a Report Link field). If I can do this using a Code Page in QB and just print from the browser, that should be fine. I don't need per
Hi all, Is there a way to hide a field based on the status of another field (not using dynamic form rules), using a formula?I have a multi-select field that shows the status of an estimate.I want to hide the "estimate follow up date" field when my estimate status field is NOT equal to any of these:Closed - Not DeniedClosed - See estimate notesClosed - Unable to authorizeClosed - CancelledClosed - Insufficient CoverageClosed - moved to different facility/locationClosed - Tx completed in officeCanceled - non patientDuplicate/VoidDocumentation onlyClosed (CC has closed)Canceled/Closed - Using different DoctorClosed - Created in ErrorCanceled on DOS - ClosedClosed - Duplicate est created Otherwise I want this field to be displayed on my form.Any ideas?------------------------------Kelly Lyons------------------------------
Hello all! I'm trying to trigger an email notification that sends each of our users/employees an email just before midnight containing all of their Time Cards back to the beginning of the current payroll period. I want this to happen at a certain time, so I thought I would use a pipeline to edit a field at 11:30 pm each night and that record modification would trigger an email notification. The modified record is a parent record and the email notification should contain all child records related to that parent that meets the criteria (pertaining to the current payroll period).The form I'm using in the notification contains two reports displaying the child records. I'm using a lookup field from the employee record to determine which of these two reports is shown in the email.All of this works to an extent. Where it breaks down is that each employee should only see their own records and when my pipeline edits the records and triggers the notifications, the emails that get sent do show th
I have a table that has, for simplicity, a client name, related agency, related product and price. One client can have many related agencies, and the agencies may have 1 to 5 products (all 5 are the same) . I want to create a table report that basically ignores the agency but brings back only one occurrence of the client/product/price combination. example: client-a agency-a prod-a price 5.00 client-a agency-b prod-a price 5.00 client -b agency-c prod-a price 8.00 I would like the table report to show only one client-product-price combination. Reason is each product has a related price, but the price is set at the client level so I really don't care about the agency. I want the report to tell me for each client, show me one occurrence of the p
hi,I am trying to write a API query to pull all data for a given Quickbase table. Is there a way to pull the fields without having to list each field individually? I saw there a 'clist' parameter that can be used but I'm not sure how to use that one.thanks,Sangeeta------------------------------Sangeeta Ram------------------------------
Hello,On Friday June 10th 2022 several of my pipelines which had worked fine for some time started erroring out. All with no alteration on our side to the pipelines. These particular pipelines use the webhook channel and examine API response content. So it is possible that something to do with API response codes changed?? The Pipelines are used to auto create users in apps if needed if an email in a specific field does not belong to a provisioned user. They use API_ProvisionUser, API_GetUserInfo, and API_AddUserToRole.Has anyone else noticed issues since Friday? Anyone aware of changes to API_ProvisionUser, API_GetUserInfo, or API_AddUserToRole?------------------------------Biff Stockdale------------------------------
I need some help with this formula. Using two tables, the formula field (PC Assigned ((User field)) ) lives in the customers table.Lead - Region is multiple choice fieldEC is a user reference fieldHere's the logic:If the (Lead - Region) = x then result aif the (Lead - Region) = y then result bIf the (Lead - Region) = z AND the (EC) = specific user, then cThe last case is because we have a region that is split with two people.I've tried a few different ways to write this and am getting errors in different spots no matter what way I try. Any insight is helpful!------------------------------Darian Vigil------------------------------
I am looking for a way to round a date field to a specific day of the week. I.e., my date falls on a Monday or a Friday, but I want the date field to show the upcoming Wednesday date. Any solutions?------------------------------Courtney Law------------------------------
Okay, this isn't too difficult for me to do if I were to copy and paste, I don't think.That said, our company has decided to have a Feedback App with a table called Tickets. The Tickets table has numerous fields that have been added since using Feedback tables in various Apps.There are about half a dozen Apps that we have added Feedback too. Now they are still on the different Apps, but all Apps have a new Feedback Submit Button, which will take the Feedback submitted and place it in a separate App called Feedback. The Feedback App table is called Tickets and it has many fields. Some of the added fields include Business Objective, Resource Assigned, several fields of Completed by. This is working well, but I need to move the old Feedback records from each of the other half a dozen or so Apps into the new Tickets Table in the Feedback Application.Fortunately all the fields, of which there are 12 (including the built in QB fields), so that only 4 to 7 fields are populated with
Hello,I have a table in Quickbase. And I have data coming from multiple sites(100's of sites). The data should get fetched every Monday automatically, from all the sites and execute an appropriate action(ex. add/update/delete record) in Quickbase.Is it possible to do?Thanks & regards,Aishwarya Jinde------------------------------Aishwarya Jinde------------------------------
Hi,"Add vote" button is getting used in the 2 rules and both rule conditions are different.First rule is to show the "Add vote" button to the specific group membersSecond rule is to hide the "Add vote" button whenever proposal status changesNot sure why QuickBase showing the below warning. Please advise how to resolve this rule conflict. ------------------------------Mrunali Kadam------------------------------
Hello fellow Quick Base Conquerers. I have our HR app set up in one application and I want all employees to be able to see only their file. I can do this with the restrictions in place only allowing then to see if they are a QB user assigned to the file. I WANT them to be able to see Name, Title, Company (We have a few companies but want one company directory) company phone number, company email, and tenure of time. The only way I can see doing this is allowing full access in one app and *see above access* for the HR app. Outside of doing double data entry I can not seem to figure out if this is possible. I created a pipeline to create a new record in the new app but I think the restrictions are carrying over. I also tried it in zapier. Any thoughts?------------------------------Jennifer Meyer------------------------------
Hi All, Not 100 on where to start with this question - please let me know what additional info is needed - if there is a solution to this. I have a separate app (Master Staff List) - that contains employee details. I've built a separate app (Equipment Master) - that contains information about company-owned assets that our employees have. This app (Equipment) has a linked/synced table for employee name/ID - and I've set up the Multiple File Attachment functionality from Kirk T's posted video/post. However, when I go to execute - the files will get added, but not to any employee. All the related employee information is blank. Am I doing something wrong - or is this just not possible with a synced table? Thanks in advance, Allissa------------------------------Allissa Weber------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.