Checkbox formula with multiple dates to refrence
Hello, I need to have three date fields Sunday date Departure Date Arrival Date I need a checkbox to be true if the Sunday date is within the Arrival and Departure even if Arrival or departure is null. And False if the Sunday date is prior to Arrival or after Departure Any thoughts on the formula? Thanks, Tara ------------------------------ Tara Stroup ------------------------------13Views0likes5CommentsRouting User to Different Form Based on Field Value
Hello, I have a process where users view a case file and work the file. We have grown so now we have several different types of case file and need to use a different form for each file type. I can imagine several ways to do this, but none are clean. Below is a list of what we tried. We tried using an iframe that linked to a formula url field, this worked except is displays the QB header twice and limits the screen size (iframes are apparently not responsive in QB). We tried using one "mega-form" with conditionals, but we hit the embedded report limit and certain fields need to be on multiple forms which QB disallows. We tried creating a different table for each file type but that breaks QB search widget (search widget can only search 1 table at a time). The best solution we found was to create a rich text field that displayed a link to the various case type forms, but then we lose the functionality of the edit and view buttons that display on every report and the search widget. Are there any other solutions to this issue? Edit: The real issue seems to be QB does not support building code at the routing stage of the application. Is this common web application functionality being considered for a future update? ------------------------------ Justin Ferris ------------------------------75Views0likes4CommentsConverting Multi-Line Text to Formula - Rich Text, Issue with Line Breaks
I have read every single post on this board regarding this subject, and have tried every suggestion and nothing is working. Please help! I'm trying to take a user input Multi-Line Text field and convert it into a Rich Text field. When converting it directly to RT, it takes out line breaks. When I do SearchAndReplace, nothing: SearchAndReplace([Schedule],"\n","<br>") I've tried the following codes for line breaks / carriage returns, and none of them have worked: \n \r \\ \\n \\r <br> <cr> <enter> <return> <crlf> <nl> <newline> &nsbp; ↵ I even set up a debug field to display "this one" if the [Schedule] field contained any of the code/characters above. I'm completely at a loss, can someone help? ------------------------------ Danielle Wilczewski ------------------------------107Views0likes4CommentsCombine Formula List-User with List-User field
Can we combine a Formula - List-User field with a List-User field? I'd like to use the field as the 'Notify Whom' value in notifications and avoid creating a set of notifications for each field. Thanks! ------------------------------ Heather Bryant ------------------------------41Views0likes4Commentshow to count the number of specific characters
Hi All, Can you please help me with a function/code to count the number of specific characters in a string I would like to find the number of semicolon (;) in the string "hi;how;are;you;" thanks Pushpakumar ------------------------------ Pushpakumar Gnanadurai ------------------------------Solved146Views0likes7CommentsURL button to populate a field with the current user
Hi There, I currently have a url button that populates a certain field with the user that last modified the record. I need some help to change it from the user the last modified the record to the current user that pushes the button. is there anyway to modify the below for the above requirement? var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_30=" & URLEncode([Last Modified By]); "javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);"122Views1like12CommentsURL button to edit then refresh page
I put the following code into a Formula URL field. The purpose is to change the status to completed by clicking the button. URLRoot() & "db/" & [_DBID_LOTO] & "?a=API_EditRecord&rid="&[Record ID#]&"&_fid_37=Completed" Works great, but it then goes to the response page below. Which I don't want. How do I modify the code above to simply change the status and refresh the page. ------------------------------ Steven Nelson ------------------------------225Views0likes10CommentsFilter Report Based on User Role
Hi there, I'm still relatively new to Quick Base, but I was wondering if there is a way to filter a report based on the user role. We have two different levels of staff - Reviewers and Team Leads, and I've created roles for each. There's also a field for each in our reviews table. Each review has both assigned to it. However, Team Leads can also be assigned as a Reviewer, with someone else as the Team Lead. I want to create a report that excludes anyone from the Team Lead level. I know you can use filters such as where Reviewer <> the user listed in Team Lead, but as I mentioned above, a Team Lead could be assigned as the Reviewer with someone else as the Team Lead, so that wouldn't work. Is there any way to filter based on their role? Thanks!! ------------------------------ Brittany Zane ------------------------------70Views0likes8CommentsFormula Builder Cursor Position Incorrect
When editing a formula in the new formula builder, for example in a rich text field, where you position the cursor and where the edit takes places is not correct. For example I can position my cursor after a field name such as [fieldname] and start typing, but the text I type appears about 4 - 5 characters to the right in the middle of another part of my formula. Is anyone else having this problem? It's the same in both Safari and Chrome43Views1like5CommentsQR Code to access record in QB App
I'd like to create a QR code that pulls up a record in the QB app on a tablet when scanned with the tablet's camera app. This QR code would be a field in my Packing List table. When the packing list is printed out by our office staff, the QR code will be printed as well. Our warehouse team would like to scan the QR code and be taken straight to the record of the packing list in the QB app on their tablet instead of looking for the record in the app. I've had some success generating QR codes but having trouble directing to a record. Here's my code for the QR code. "<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=120x120&chl="&[QR Code URL]&"\"alt=\"\"/>" where [QR Code URL] is 'https://cfkent.quickbase.com/db/bpc9xkysz?a=dr&rid=[Record ID#] ------------------------------ Howard Fu ------------------------------111Views0likes18Comments