Image Preview Formula Not Working
Hi, I'm trying to include a column for a property image preview similar to what is shown under 'Projects' in the Project Hub app. The formula appears to be correct but nothing is coming up. What am I doing wrong? Here it is... If([Building Photo] <> "", "<div style='display:inline-block; width:200px; height:150px; text-align:center; overflow:hidden; border:2px solid #ccc; border-radius:8px;'> \n <img style='width:100%; height:100%; object-fit:cover;' \n src='" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e120/v0' />\n </div>")
Printing to Dymo Label Printer
Hello all, I just wanted to share how I was able to successfully set up a print button to print using a Dymo label. I have been searching online for a solution and I was being pointed to Trinity and that just wasn't an option with my organization. So below is the steps I took to get what I needed. Step 1 Create a Formula Rich Text field with the address information. Below is the formula I used to get it my address in one field. Everywhere you see brackets, those are my field names. I have Name, Organization, Street Address, Street Address-2, City, State/Region and Postal Code. You will need to change those names in my formula to fit your field names. Also, we have some [Organization] that are very long so we I had to add some adjustments to the font if the character length got to a certain size. My formula is attached in the word document labelled "Step 1 Formula". Step 2 Create a form on that table that specifically displays only the formula rich text field you created above. My field is named Address Label. The only thing you need to put on that form is the Address Label field you created in Step 1. Remember to hide your label on the form to remove the name of the field. The picture attached labeled "Step 2" shows what my form looks like. It won't be much since its only one field with a hidden label. Step 3 Make note of the Form Id number for your new form. Mine is '10'. Step 4 Create a formula URL field on your table to execute the print. My field is labeled "Print". I also made it a button for a cleaner look. The formula I used for my button is attached labeled "Step 4 formula and field settings" Replace Realm Name, TableID, [Record ID#] and IDofTheForm with your information. Realm Name Located in your URL browser. Mine is dekalbcountyga https://dekalbcountyga.quickbase.com/ TableID Located in your URL on the table you are wanting to access just before the /table. In this example, mine is kdubsk9v kdubsk9v/table [Record ID#] This is the key field in your table. The default for every table is [Record ID#], however, if you changed the name of your key field like I did, you will need to put that field name there. IDofTheForm Located in your main Form page. Previously I showed mine was 10 Change the settings in that field to display a button, open in a new window, etc. Image attached labeled "Step 4" is a screenshot of all my settings in this fieldOnce you have that done, the only thing you need to do is in the print settings, after you select your Dymo printer, you will need to change your margins to None. I am in now way a Quickbase pro but I will help anyway I can. Hopefully you all find this useful. :)
Show numeric formula total as percent
I am having trouble showing a formula sum as ‘percent’. The following formula returns the value as 73, which is correct. However, I need it to display as 73%. Round( ( ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10 ) If I change the field attribute ‘Display as’ to Percent, then it shows as 7300%. If I add to the formula to divide it by 100 at the end, then it shows the result as 100%. Round( (( ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10)/100 ) Where am I going wrong with my syntax on getting this to work? I have tried as both Numeric-Formula and Numeric-Percent field types.
Best way to have a repository of pre-configured options but also allow users to add/edit
I am building an application that will be used to house business requirements for various outbound call campaigns. One of the aspects of the campaign is a questionnaire that needs to be filled out by the user post-call with the member. Most of the campaigns use the same question/response combinations but there may be times where a response option may change. What is the best way to allow users to choose from pre-configured question/response values (based on historical requirements) but also have the ability to request a change for their purpose?File Manager Plug-in for Add Record Any Creative Solutions?
Hello, I'm wondering if there's any clever solutions to route to the file manage plug-in so end users can add documents to child records when they are also adding a parent record. I know natively that's not available due to lack of RID on the parent. But I was hoping to leverage some other formulas I've used in the past to circumvent this issue, but I'm getting syntax errors when I attempt to combine elements - I'm curious if this is user error or due to the plug-in it's simply not adaptable? general use case: User adds accounting record for invoicing, as a legal requirement in 2026 they have to now add several large documents for which I would like to leverage the file manager plugin. Samples of what I've concocted: The intention is to save before navigating/opening the file manager and/or use the %%rid%% to provide a new RID for the parent record so the user can bulk add documents with the parent form submission - I think I've scrambled somethings: //original plug=in URL. do not tamper var Text realmHostName = NotRight(NotLeft(URLRoot(), 8), "/"); var Text pidRaw = "" & [Record ID#] & ""; var Text pidQueryParam = URLEncode($pidRaw); var Text URL="https://api.plugins.quickbase.com/launch?pluginId=qb-uploader&pid=" & $pidQueryParam & "&configId=#####&appId="&AppID()&"&realmHostname=" & URLEncode($realmHostName); //"var text URL="" and end ";" added when updated to rich text formula. //button colors var text bgcolorone = "#7f81aa"; var text txtcolorone = "white"; var text styleone = "style=\"text-decoration: none; width: 100px; text-align: center; background:" & $bgcolorone & "; border-radius: 5px; padding: 5px 5px; color: " & $txtcolorone & "; display: inline-block; font: normal 700 40px/1 \"Calibri\", sans-serif; text-shadow: none;"; "<a class= 'SaveBeforeNavigating' " & $styleone & " data-replaceRid=true href='/db/abc?a=dr&rid=%%rid%%'" & $URL & "'> Upload Documents </a>" If this isn't possible, are there alternative solutions out there? Thank you for your help!
Total grandchild records in a grandparent with drill down
I have three tables, Audits>Questions>Nonconformities Audits have multiple questions Questions have multiple nonconformities I'd like to display the # of nonconformities related to the audit on the audit table without creating a new relationship between audits and nonconformities. I've got this accomplished currently just doing a summary field from nonconformities to questions and then questions to audits but had to disable drill down since clicking it only took you to the 'parent' question table. Is there a rich text formula that could show # of nonconformities related to an audit with drill down that would go to the 'child' nonconformities table?
