Forum Widgets
Recent Discussions
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)
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 ------------------------------
