Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Ready for a chance to win and boost your Quickbase skills? The App Builder Qrew is hosting a raffle giveaway—simply download Mark Shnier’s app from the Quickbase Exchange and show proof (a screenshot or confirmation in the thread or email elavielle@quickbase.com) to be entered for a chance to win prizes. Link to the app in the exchange: https://www.quickbase.com/db/main?a=UniversalLink&entityId=qbredir&asset=user-focus-examples Mark’s app is a powerful tool that’s helped many builders streamline their workflows and solve real-world challenges. The raffle contest will be open until Tuesday April 22nd. Don’t miss out—download the app, share your proof in this thread, and enter the raffle today!
Hello, I want to add 25 business days to a starting date and get an end date. I know how to do it with all days but I need business days.Please help!ToDate([Date Requested]) + Days(25)
Hi,I have 4 tablesSite table - houses all site info including site ID# which is the unique identifier to be used to relate/connect all tables.Risk table - houses all the risks. 1 site can have many risksMilestone table - Each risk can have many milestonesSite Risk Register - Joining table that has all the risks and milestones relating to each site on one tableI'm struggling to figure out how to connect these tables. I figured all tables need to have that site id# field in order to connect. So I created a one to many relationship with the Site table and the other 3 tables so all 3 tables have a site id# lookup field.Then I created more relationships. One Site Risk Register has many Risks, One Site Risk register has many Milestones and then I also made One risk table has many milestones. I added dummy data in the tables but it is not reflecting in the Risk Register join table. Can I get help on what I did wrong and how to properly set up these table relationships
Hi there! I am trying to turn away from using connected tables and into using pipelines to bring my data from one app to another. I am using the bulk copy records action in pipelines to do so! It is a super simple pipeline but whenever run it my table does not get update with the records. I do not receive any errors on the pipeline itself but the table remains empty....Help! Thank you :)
Hello, I am looking to use a SAML assertion for authentication of a custom web app that uses the QB JSON API. In the linked documentation, it is described that you can use an API endpoint to do this, thereby authenticating your app using the currently logged in user with a SAML assertion exchange.But the documentation is super vague and provides little for one to go off if you are not a SAML expert.https://developer.quickbase.com/operation/exchangeSsoTokenThe line from this documentation I linked to that I am focusing on, is this:You must be able to create a SAML assertion in your code to use this endpoint.Does anybody have documentation or advice on how to put the SAML assertion together? I want to link to my app from Quickbase using a Formula URL. Then I want my app to authenticate the current user so they can perform some tasks in my custom app under the same identity they were using in the QB app.I would love to see a full example, code and all, to help with this.
I do not want users assigned a "viewer" role or "participant" role to be able to have access to the Admin Console. *My Apps - Account Admin Manage my account - Admin ConsoleI would like "admin" role to be able to share app with users but also not be able to access the Admin Console.I do not want to "Deny" users because I want them to have access to log in to the app and use it, I just do not want everyone seeing the Admin Console information.Is this possible?
Anyone experience system rollbacks/ reversions between 4-10-25 and today 4-11-25? Team made several large updates to the system yesterday, 4-10-25, to only find them not there today. Like the changes were never made.
Hi i table 1 app - 3 tables, table 1, table 2, table 3now i have relation of one to many from table 1 to table 3. this relationship is old and has been working fine but suddenly i cant see the associated records from table 3 at the end of the record in table 1. they use to populate properly earlier. i have not changed anything in the relationship, cant understand why getting this error, it says "sorry...error retreiving data Attached the image as well. Only thing i can think of is another admin, was asked to delete all the unwanted reports so he may have deleted the associated report from table 3. if yes, how can i recreate the same. ? or any other reason for this problem.
I have a 1 app - and 1 table. there are 5 usersall the users have access to all the fields on the form on the table to view or edit the fields in the own record. So permission is view and modify all fields. and record level restriction is where owner is the logged in user. There is record level resctriction so user 1 cannot see user 2 records.i want to make a report where all the users can view all the records 5 particular fields. but cant view or modify the record of other users.However i want to create a visibility report to show all records from today to all the users but only a few limited fields. I have created the report, disable view and edit to the records and given all records access to the user. But the problem is if the user 1 will do advance search randomly, they can view all records from default search results. If I restrict that then no user will be able to open the records from the search which will be a blocker. how do i get past this ?if i restrict field level the
I want to display a link on my form. It needs to be displayed always. The code I used in the older form was:var text Words = "Core Rules";var text URL = URLRoot() & "up/" & [_DBID_Documents] & "/a/r" & "5974" & "/e6/v0";"<a href=" & $URL & ">" & $Words & "</a>"i.e: Name of link, and the url to the document already stored in quickbase from another table. Flipping from the older form, it works, and moving it to the new legacy form, it shows the following error:"400 Error Invalid field type"The specified field was not a File Attachment fieldIf the problem persists, reach out to your app admin, check the Quickbase service page. or open a support case" How can I fix this for the new legacy form? The link works, but clicking on it, I get that error. Below is how it looks on every employee's portal. The links just don't work now. HELP! I created a new field, and typed in the code, and it displays the same behavior.&
Hi, I'm using a formula rich text button to add record in a different table when click. The button includes the action of copying multiple field values into the newly added record. I have one field that is a file upload field and need to copy this file into the corresponding field on the newly added record as well. Can this be done in the rich text formula? If not, how might you do this?Example:Approval Record:Name DateAmountJPG (image of the agreed terms)When clicking 'Approve' button, a new Transaction Record is created with all of the approved info:NameDateAmountJPG (***Need to duplicate this file to the newly created record)Thank You!Chris------------------------------Chris------------------------------
Drawing a blank on this one. Trying to add this code to formula rich text field, pointing to the record in which the button is pressed. "<a href=\"http://quickbase.com/webinars/\"><img src=\"https://images.quickbase.com/si/32/128-link.png\"></a>"------------------------------ProjectsForce------------------------------
Hey folx!Is there a way to set up roles to give others the ability to edit a dashboard page without allowing them full ability to edit app structure and permissions?We're using a dashboard page, and a text block in one section that we regularly lock/unlock to update on our daily huddles. I want folx to be able to do that in my absence, but also, not have the ability to be on the back end.Thanks!
Happy Monday ladies :) Now that we've all had a couple weeks to digest from Empower, I would love to start a discussion around the event and start to gather feedback from the team. I personally was not able to attend, but I heard a lot of great things from the folks that were able to get together for the first time in 5 years!I would love to hear from some of the folks who either went in person or watched the Keynote live - what was your favorite part? Are you excited about a certain new feature? What could use improvement from either an engagement or rollout standpoint? Based on some of the feedback we gather from the group, this will inform our discussions moving forward and which Quickbase or developer resources we can help tap in for further discussion. While we did not have the opportunity to do a Qrew-specific event for Empower this year, that is certainly the goal for next year's. I hope some of you had the opportunity to meet with other members of the Qrew and join some of
Just a heads up that I will be doing a demo of the User Focus Technique on Tuesday April 15th. Register to attend or at least to get access to the recording after the session.https://community.quickbase.com/discussions/app-builder-discussion/aprils-app-builder-agenda-for-april-15th-2025/90452Register HereAgenda for the App Builders Qrew Meet Up Tuesday April 15th at 12pm EST:Mark Shnier, owner and developer of Your Quickbase Coach, who will present some use cases solved with the User Focus Technique, including calculating distances between addresses and quickly assigning team members to a project. This Technique should be in your toolkit as it's really useful and provides a great End User experience. This session will include an app by Mark that is now available in the Exchange that you can download and apply what you learned from this session right away.
Is anyone aware of a way to hide the default edit (displays a pencil) and save buttons on new forms? I have added ifv=1 to my URL to open the record and built my own buttons to mimic the default set of buttons (with some of my own enhancements), but I still get the default edit and save buttons.------------------------------John Jordan------------------------------
Hello, I have a multi-select text field with employee name choices that is going to be archived and no longer used. In that fields place I will be adding fields that relate back to a connected employee roster table for the user to locate and pull the info from, however, I'm wondering if there is a way to have the new field populate based off the names that are currently already in the multi-select field?
I have a code page in a dashboard which works fine in desktop, but on mobile app, the page is blocked with the attached message (Please enable cookies). The steps are not available in the mobile app. Can anyone provide alternate solution please.There is no option to accept or enable cookies.
Any options/tricks for minimizing the side menu when opening a pop up from a rich text button? What I notice is if the side menu is expanded in my parent page it will also be expanded in the pop up... ideally I want to always minimize the side menu in a pop up
Jim! ToText(UserToId( [QB Username]))Is anyone using a QB Formula field to display the user id to users in a report? The User Id looks like this "51817980.d2k9" (I changed this to something madeup, apologies if its your id.)I have the admin console connected table and can sync the used id value to any app I want, which is my backup plan. Before I make that change I am checking to see if there is something I missed.Use case:We have users added to an App via a default role in a Group provisioned via SCIM. Some users may need to have an elevated Role other than the default Role. Currently the elevation is indicated by app data managers checking a box on a record. The check box indicates these users require an elevated role change.When users requiring access to the elevated role are indicated, someone has to compare the record in the table and the role in the users table and align or normalize the values ~ that someone also has to be knowledgeable about the process.I have found several Giv
EstherLaVielle bsimon_personal Second day in a row, I opened the calendar event in Outlook and logged on to the Zoom meeting. There were about 10 people in the room waiting for the meeting to start. Since it just happened yesterday I asked, "is Esther on this meeting?" LauraT said "no" and so I did what Esther said and went to the Events page and looked for Pipelines. I did not notice the date had changed, it took me back to the same event. Oh I guess the event date changed.I have now deleted all my Outlook calendar events. I guess this means I have to come to the Events page on a regular basis and check to see if anything has changed.IMO this new Meeting method adds Grey work and reduces value for the customer. My advice, if there is interest, is to make a plan and stick to it.
Is there a way I can make text entered into a text box convert to Proper Case before saving?This sounds like it should be a very easy thing to do, but I searched and didn't find anything about it. I did see where functions for Upper and Lower can be applied, but not Proper Case.
I have a user that is active for 3 apps in my realm but when she logs in she only sees one. I have resent invitations but that didn't work either. Looked at her user access and she has all 3 apps in her profile. Any ideas?
Hello!Does anyone know how/if you can have a form always be in edit mode? Most of our users are in and out of forms all day for the purposes of editing, so ridding the extra Edit mouse click would be a win.Thanks :)R------------------------------Rick Satenstein------------------------------
Hi -- I'm trying to create what I thought would be a simple rule to display a message when a record is opened, if a field is set to a certain value. I can't get the rule to work, but as I have been troubleshooting, I have found certain field types work and others don't. So far, I see that checkbox fields seem to work, but formula-based checkboxes and multiple choice text fields don't. Can someone explain why this is, and if there is a work-around? I would like my message to be based on the a formula-based checkbox being checked.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.