Inspection Sheet Possibilities
I am attempting to build an inspection sheet that will state if the dimension entered is within the specified tolerance. I have attached a screenshot of how I would like it to function, however after a week of reading the community pages. I have had little success in making it operational. Current Setup(see attached): Column #1 (Data Entry-Multi Choice or Numeric). Column #2 (output based on Column #1, OK/Green, Out of Tolerance/Red) Column#3 (Section view, visual reference only) I have had varied success with Column #2 as Text-Formula or Rich Text Formula using If statements with Greater Than, Less Than, and Equal to statements. ie. it does something but not the desired outcome. Questions: Is my idea possible? If so, Is Numeric/Multi Choice the correct choice for Column #1? Am I missing a step where I need to change the numeric into text and then apply the formula? Any help or ideas on how to accomplish this would be greatly appreciated. Regards, LandonSolved97Views0likes7CommentsIf/Then Help - Unforeseen number populating
Hello! I've got an API button that when triggered, creates a new record with some preset information pulled in. That all works except in the instances where I need some fields to be blank. I thought I could use an If/Then statement to complete data or stay blank when necessary. for exp, If( [Renewed Parking rent] >0, [Renewed Parking rent] ), [...] I assumed if I left that as the statement, nothing would happen in the even of a $0 amount. The new record's field would be intentionally blank. Instead strangely, when data should be blank (whether the if/then sample above is blank or null), it populates a crazy amount like $25,000... It's always roughly $2#,###. I've attached some of the screenshots of the data output (currency fields) and formula. The text fields populate correctly if for example, [Renewal OutcomeStorage] (currency) =0 so the output for [Storage] = No (row 32) but [Storage Rent] (currency) should be blank but instead reflects $24,302.00. Any ideas about what I'm doing wrong? Thank you for your help, LizSolved123Views2likes11CommentsImage 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>")41Views1like1CommentHelp — Am I doing something wrong? Find() always returns 0 on a Rich Text field
I've been going in circles on this and can't figure out if I'm making a mistake or hitting a platform limitation. Would really appreciate any insight. What I'm trying to do I have a Rich Text field called [Jira ID - Description] that contains HTML like this: <p><b>Tool Link(s):</b> <a href="https://example.com/...">Group 1</a><br/> <b>Request Note:</b> N/A</p> I'm trying to extract the link text ("Group 1") using standard text formula functions. The weird part These two expressions on the same field, same record give me contradictory results: Contains([Jira ID - Description], "Tool Link") → True Find("Oak Link", [Jira ID - Description]) → 0 How can Contains find the text but Find can't? I've tried every capitalization variation, I've triple-checked the record ID in the formula checker, and the field preview clearly shows the content is there. Length() returns 800, so the field isn't empty. What I've already tried Mid() — always returns blank Left() and Right() — same, always blank The formula checker preview shows the correct HTML content in the field My question Is Find() just broken on Rich Text fields? Do I need to use a completely different approach? Is there a ToText() wrapper or something that would make positional functions work? Any help appreciated — this has cost me way more time than it should have!Solved59Views0likes4CommentsPrinting 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. :)251Views2likes6CommentsShow 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.29Views0likes3CommentsBest 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?71Views0likes5CommentsFile 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!62Views0likes2Comments% Complete status bar of check boxes
I have a checklist which is 20 or so checkbox questions across 5 different Sections, to work through a field inspection. I am looking to provide a visual representation of when Section 1s 5 check boxes are not clicked it would show red/ not started, when 1 or more but less than the 5 are checked it would show yellow/ in-progress, and when all 5 check boxes are clicked it would show green/ complete. And I would do this foreach Section. What is the best way to complete this and be able to show it in a Form and on a Report view? Thanks.Solved68Views0likes2CommentsTotal 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?86Views0likes2Comments