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>")
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?
