Pinned Discussions
Forum Widgets
Recent Discussions
Avoid Login Mix-Ups: Check the Qrew Meet Up Times
Hi Qrew! We’ve noticed some confusion recently with members logging in at the wrong times for Qrew Meet Ups. This is likely due to shifting schedules for Empower happening the first week of April. To avoid any scheduling mix-ups, we want to remind everyone to visit the Quickbase Events Page for the most up-to-date information on upcoming sessions. As of Jan 2025, we are no longer sending out calendar invites and making the events page the source of truth for all Qrew events and registration information. Remaining April Qrew Meet Up Schedule: App Builder Qrew Meetup: Tuesday April 15th, 12pm EST Pipelines Qrew Meet Up: April 16th, 12pm EST May Qrew Meet Up Schedule: App Builder Qrew Meetup: May 13th, 12pm EST Pipelines Qrew Meet Up: May 14th at 12pm EST (FYI: Final agenda for Pipelines Qrew will be finalized by next Friday, May 18th) * Realm Admin, Solutions Spotlight, and Mobile Qrew Meet Ups will be cancelled for May 2025. With plans to incorporate more webinars into Qrew events, we will be prioritizing webinars and scheduling our Qrew meet ups around it. Please be sure to review the schedule on the events page and mark or change your personal work calendar so you don’t miss these valuable opportunities to connect and learn. Let the community know if you have any questions or feedback by reaching out directly to ben_simon or me. Thank you for your attention, and we look forward to seeing you at this month’s meet ups!0likes0CommentsOpening form in edit mode
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 ------------------------------0likes9CommentsDynamic form rule inconsistency- (display message on open)
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.Solved0likes7CommentsDynamic Form Rule Not Firing
I have the following form rule set up but only the first 2 actions are firing, the 3rd only fires after I save and then re-open the record. The only time the 3rd action works right away is if I have the "Material Description - Formula" field still on the form, but I was trying to hide that. Do I just need to keep that field on the form somewhere? ------------------------------ Chris Swirtz ------------------------------0likes3CommentsQrew Meetups all Cancelled
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.0likes1CommentDuplicate Values Between Two Tables
Hi Everyone, I will preface this with formulas are new to me. I have two tables Table 1 (Preferred Provider): This is the master table of only the preferred providers identified by Provider ID Table 2 (Member Assignments by Provider): This table is the universe of all member assignments-both preferred and non preferred. Providers are identified by Provider ID What formula (and formula field) do I use in Table 2 that will look for a Provider ID match in Table 1 that will populate the new field in Table 2 as yes or no? This app won't have user entries so I don't think I need a relationship. I just need to be able to match the preffered providers assigned in Table 2 to the master preferred provider list in Table 1. I tried something super simple which, as you likely know, didn't work. IF(Size(GetFieldValues(GetRecords("_DBID_ASC_PREFERRED_PROVIDERS.PROV_ID = _DBID_MEMBER_ASSIGNMENTS_BY_PROVIDER.PROV_ID")) 0,"Yes","No")0likes9CommentsPosting from an HTML form directly to Quickbase
I would like to make a very simple HTML form (i.e., first name, last name, phone number, email address) that posts directly to a non-sensitive QB app. I am doing this in lieu of a mobile form in order to make it appear seamless on the related website, vs the more clunky mobile form link or iFrame window. I have no access to server-side configurations, so I am prepared to expose a user token in the HTML. Does anyone have any code that they could share that would give me an example of how to do this? Thank you in advance for your assistance.Solved0likes4CommentsExchange a SAML assertion for a Quickbase token
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/exchangeSsoToken The 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. (Minus any secure pieces you need to obscure.)0likes0CommentsIdentifying identical values between two table
Hi Everyone, It's been a while since using QB and my brain appears to have lost QB memory! I have two tables: Preferred Providers eligible for auto-assignment All Providers that have been auto-assigned (regardless of preferred designation) I am looking for a formula that will look for a TIN match between both tables and pull into table 2 under new field "Preferred Provider" Ultimately, I need to identify the auto assigned preferred providers without scrubbing a list of thousands of TINs. Any help is greatly appreciated!0likes3Comments