Forum Widgets
Recent Discussions
How to create a pipeline to count records in a table
I want a pipeline to do the following: Go to a table in an application A Search for records meeting a certain criteria in that table (specifically, the number of records that were completed in the previous month) Count the number of records found Go to application B Create a record in a table in application B Put the count of the records found in application A in a field on the form (fields: 1 application A name, 2 is count of records found, 3 date the pipeline ran) I want the pipeline to run this monthly on a scheduled date. Can someone kindly tell me the steps I would need to include in the pipeline to make this work? High-level is all I'm looking for. Thank you!
Pipeline after import (heavy traffic/transient error)
I am trying to improve pipeline performance and need guidance on the best approach please. When approx 1000 records are created from csv import using ImportExport action in TABLE A, the pipeline should look for TABLE B ID based on a text field in TABLE A and relate. Attached sample pipeline. When records are imported, the pipeline runs, but noticed the traffic warning. Bulk upsert may not work as each pipeline trigger is on single record update.
Dropdown Choice Update force reselection
Hi all, I have a drop down field with choices for a 'job status'. I've recently refined the list of choices, and I want to know if there's a way to force a user to have to select one of these new choices next time they update the job record. Currently, they can leave the existing status in place and save the record anyway, with the choice highlighting in red in the report. Is there a way to do this? Thanks in advance.Freelance/Job Quickbase Developer and Admin Full stack developer
Hi All, I Have 6 yrs of experience in quickbase development, Optimization, Automations and integrations I have integrated different applications like asana, salesforce, GCP and procore with quickbase. I have implemented few integrations to fetch the data from Google forms/Google sheets and to update the data in Quickbase table with quickbase APIs. mailto:vkamala.upw@gmail.com Regards, Kamal.
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)
