Need help building a Formula–Text field
I’m working in Quickbase and need help building a Formula–Text field based on selections in a Multi-Select Text field. Requirement The formula should return one of three designations based on a strict priority: Tier 1 — highest priority Tier 2 — medium priority Tier 3 — lowest priority When selections from multiple tiers are present, the formula must return the highest-priority tier. Current setup: The source field is a Multi-Select Text field(20 options). I created a helper Formula–Text field using: Lower(ToText([Multi-Select Field])) The helper field correctly displays the selected options as semicolon-separated text. However, formulas using the following methods do not consistently recognize all selected values: Contains, Find, Trim, RegexMatch Even a basic test such as this returns the false result, although the helper field visibly contains the phrase: var text Criteria = Lower(ToText([Multi-Select Field])); If( Contains($Criteria, "example selection"), "MATCHED", "NOT MATCHED" ) I also tried: Adding semicolon boundaries Accounting for spaces around semicolons Matching first, middle, and last list values Removing punctuation from the configured option Recreating the option manually Using Find() instead of Contains() Comparing the converted value directly Using a formula query with the Multi-Select field ID and a HAS operator The formula-query attempt returned blank. Constraints I need a formula-field-only solution I do not want to use Quickbase Pipelines I do not want to replace the Multi-Select field with many individual checkbox fields Exact selection matching is preferred to avoid accidental partial matches The solution must work when one or multiple choices are selected The priority order must be preserved What is the correct supported Quickbase formula syntax for determining whether a specific option is selected in a Multi-Select Text field? Is there a native list-membership function or formula-query method that works reliably for the current record?
URL for current time in Time of Day field
Hey all, Trying to deal with stamping a Time of Day field with the current time when clicking a button. I know about how "now" functions to do this properly when using a Date/Time field, but it doesn't seem to translate properly into Time of Day fields. It errors if I just try to use "now" in the field assignment and returns nothing if I ToTimeofDay("now"). I can't use Now() because this caches the time the page loads and that won't work for how this process needs to function. What's my best option to get this handled?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!
