how 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 ------------------------------Solved30Views0likes7CommentsURL 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);"42Views1like12CommentsURL 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 ------------------------------98Views0likes10CommentsFilter 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 ------------------------------17Views0likes8CommentsFormula 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 Chrome14Views1like5CommentsQR 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 ------------------------------62Views0likes18CommentsI need to use the following field in a date range
I need to use the following field in a date range [cln enc date - date] It's a date-formula field. I am trying to check for current dates, within last week (7 days) last week 8-14 days and then 15-21 days. I try Boolean logic with AND and use ToDate, Today, etc but getting errors, such as mixing date and time. I just want date calculations and don't care about time of day. I have image of the date fields there are. There are a lot of date fields, but I didn't create most of these. The [cln enc date - date] is the field that is used to match encounter records. ------------------------------ Bob T. ------------------------------62Views0likes11CommentsI would like to list the attachments in a single field, to be referenced using a relationship in another form?
I have attachments within Table A, called Publication Tracker, and I would like to quickly access these attachments via single field, both for a report and so I can ideally pull this info into another Table B, called Project Tracker. I have used the List formula field which would be perfect except it just lists the attachments from the selected fields as text, rather than links to the documents. Is this possible to do, and how?12Views1like12CommentsNeed to transform data into a new field: State name = State abbreviation
When a new 'Lead' entry is created in my app, the field for Address: State/Region is fully spelled out (i.e. Alabama). We've set it up this way and this part can't be changed. What I want to happen is this: Anytime a new 'Lead' entry is created, I want to create an action or formula that creates a separate field for the State abbreviation. For instance: A new lead comes in. The state address is California. Need to create new field entry of CA for this lead. How can I do this? FYI: There's another post that is somewhat related, but I couldn't figure out how to execute based on these instructions: Reference: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30396&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer {{ "Alabama"|replace("Alabama", "AL") }} Thanks, Matt ------------------------------ Mathew Crist ------------------------------4Views0likes4CommentsCreating reports that show only the columns where values are present
Hi Everyone, We get bids from vendor on projects (RFPs). For each project we end up having different information submitted.As a result we often end up with an embedded table on the project record where only 10/40 fields have any information Users are annoyed that they have to look at so many empty fields. Is there a way to display only the columns in a report if values are present? For example, if the project has no value for "Rent" in any of the projects related "Bid" records, don't show the "Rent" Field in the project's embedded report. I realize that we could achieve this by having multiple reports, however, we've come to the conclusion this would require maintaining over 200 reports, so we're looking for another solution. Thanks! ------------------------------ Jake R ------------------------------5Views0likes19Comments