View query record if single record otherwise view query list
I am creating some buttons in a Formula - Rich Text field. They will allow users to quickly jump from one table to the next using the table to table relationships we have set up. Mainly what they will be seeing is a list of related records based on a query. For example, if I am in the Customers Table and I click on the Invoices button it will take me to the invoices table and I can see all the invoices related to that customer. If there is only one invoice I would like the button to take me directly to that invoice record and not view it in list mode. Is there a way to use the query and set up an if statement that would check the length of the query response and if there is only one then view that record. Below is an example of the query code I am using for one of the buttons. URLRoot() & "db/" & [_DBID_INVOICES] & "?a=q&query=" & "{'6'.TV.'" & [Record ID#] & "'}"
QR 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 ------------------------------
I 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. ------------------------------
I 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?Need 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 ------------------------------Creating 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 ------------------------------Formula URL Form ID Shows Wrong Form
Hi, I'm using the following formula to operate a button. Pressing the button opens a specific form, form 11. URLRoot() & "db/" & [_DBID_TABLEINQUESTION] & "?a=er&dfid=1000011&rid=" & URLEncode ([Record ID#])& "&z=" & Rurl() Every morning I test the button. Although the URL displayed in my browser address bar shows "...dfid=1000011", I am looking at form 2, the default form. If I go to settings/forms and preview each form, the button works properly again until the next day. Please help ------------------------------ J.T. Ogle ------------------------------change the native add record button to go to a certain form instead of using the one this table is set to be used in view mode.
I want to change the native add record button to direct to a certain form. I know I can do tht by changing the entire report to use a certain form but I don't want to do that since I still want for viewing to be able to use the form I currently set to be using for this report. I know with a simple onload technique you can do that. Just need some guidance. Thanks in advanceclass='Vibrant Success' in a different colour to green!
HI, I'm using the 'Vibrant Success' button in my text formula fields (as per the Magic Buttons Sample App), and absolutely love them. However, I'd really like to use a different colour in some instances for contrast. For example, the dark blue with white text 'submit a question' button on this forum would go down a treat! Can this be done without resorting to image onload techniques? David ---- Example of the kind of formula text field I'm talking about from the 'Magic Buttons' app. If([Checkbox] = false, "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eascudwjxs2sesxkjccwgtq9r&_fid_101=1&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>4B. Check a checkbox then display record</a>", "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eascudwjxs2sesxkjccwgtq9r&_fid_101=0&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>4B. Uncheck a checkbox then display record</a>" ) PS Anyone not sure what I'm talking about here - search in the App Exchange for 'Magic Buttons'
