Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Links Banner
Main Content
Recent Content
June 2025 Qrew Meetup Event
Portland Qrew is meeting the forth Wednesday at 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned and alternative solutions. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on to higher heights. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation.
PDF Attchment View
I am trying to view a thumbnail of a PDF in a report or from file attachment. I have used the image preview in the Quicbase excahnge and have modified it to my corerct fields but I am unable to see the thumbnails. Any hlep is appreciated. https://ciclops.quickbase.com/nav/main/action/exchange/qb/library/image-preview My Formula - Rich Text field If( [Tear Sheet]<> "" , "<span style='width:400px; display:inline-block;'> <img style='max-height:400px; max-width:400px' src='" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID# - Company] & "/e75/v0' /></span>" )
Changing owner of notifications - role limits?
Hello! What drives the drop-down menu in the "change owner" email list in notifications and subscriptions? My list comprises of me (only person with app edit permissions), and my system office's realm manager (I think that's what their role is anyway). I need a middle-ground to change subscription ownership to my team members - including those who otherwise have full app access, just not app edit permissions - as well as a new role coming on board that will have more limited access, but will be crafting their own notifications. Thanks!
Reveal long multi-line text by clicking an ellipsis
I have multi-line text fields with unlimited length. In table reports I'd like them to function like social media comments where long strings of text are revealed by clicking the ellipsis ('...'). Wondering if this can be done in a Formula-Rich Text field. Currently my field displays the text up to the 30th space character followed by an ellipsis; the full text displays in the hover-over bubble. This works but I'd prefer the simplicity of click-to-reveal. My current Formula-Rich Text field is as follows: var text TitleText = SearchAndReplace([Text Field], "\"", "'"); If(Part([Text Field], 30, " ") != "", "<p title=\"" & $TitleText & "\">" & Part([Text Field], 1, " ") & " " & Part([Text Field], 2, " ") & " " & Part([Text Field], 3, " ") & " " & Part([Text Field], 4, " ") & " " & Part([Text Field], 5, " ") & " " & Part([Text Field], 6, " ") & " " & Part([Text Field], 7, " ") & " " & Part([Text Field], 8, " ") & " " & Part([Text Field], 9, " ") & " " & Part([Text Field], 10, " ") & " " & Part([Text Field], 11, " ") & " " & Part([Text Field], 12, " ") & " " & Part([Text Field], 13, " ") & " " & Part([Text Field], 14, " ") & " " & Part([Text Field], 15, " ") & " " & Part([Text Field], 16, " ") & " " & Part([Text Field], 17, " ") & " " & Part([Text Field], 18, " ") & " " & Part([Text Field], 19, " ") & " " & Part([Text Field], 20, " ") & " " & Part([Text Field], 21, " ") & " " & Part([Text Field], 22, " ") & " " & Part([Text Field], 23, " ") & " " & Part([Text Field], 24, " ") & " " & Part([Text Field], 25, " ") & " " & Part([Text Field], 26, " ") & " " & Part([Text Field], 27, " ") & " " & Part([Text Field], 28, " ") & " " & Part([Text Field], 29, " ") & " " & Part([Text Field], 30, " ") & "...</p>", [Text Field])
HTTP Request - Body
Hey Y'all. I have a question on how the Body works in the HTTP Pipelines Channel. Before I begin I have everything working and set up correctly (Was able to do it in Postman and was able to do GET Requests in Pipelines) I cannot figure out how to insert my body in HTTP node. I have tried a lot of things to get this to work. I double checked the encoding but maybe there is another option I need to use? I think my problem lies in the to__json Jinja function (If i even need to use it) Any tips are appreciated!! This body I was able to use in Postman and it worked!
Count days between 2 dates with a twist
I have a Start date and end date I am using the Weekdaysub(end date), (Start Date). but i want to add a IF statement like say to add saturdays to the mix. so if I was to set the date from 5/25/2025 and end on 5/30/2025 but if the saturdays check box was clicked it would also add the saturdays between those dates and return 6 (Monday-Saturday) and if the saturdays was not checked it would return 5 (Monday - Friday)
How to find no of Sundays in a Month
Hi, I want to find the count of how many Sundays are there in a month basis on which i would like to find out No of Days in a month - No of Sundays. I have created a daily data entry form in which the user will enter the date. I would like to find out how many sundays will occur in that given month for which the date is entered. For Example if the user enters the date as 15.03.2020 then March 2020 has 31 days and 5 Sundays so 31-5=26 should be my end result. Is there a way thru which the same can be achieved? Regards Gunsham ------------------------------ Gunsham Lakhiani ------------------------------Relationship Condition Dropdown stopped to work after formula update
Team, I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value. [SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO]. I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected. I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in. [QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form? What I tried: I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change). Tried to create new field [SMO_Predecessor_Keyv2] and update Conditional Value to it and back. But not working as well. This is how dependency of fields looks line (Blue changed to Green) Current workaround but not well seen by users 😢
