RyanPflederer3
Quickbase Staff
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to Change Multi-select Text (summary) to user field
Hi Michael! If you want to have multiple users displayed then you'll want to change the field type from User to List - User. After doing so the error should be resolved and you'll be all set. ------------------------------ Ryan Pflederer ------------------------------87Views0likes1CommentRe: Color-coding a field based on calculated percent
Hmmm, can you verify that both Count and Number Held are numeric fields? It worked on my side when both are set as numeric fields so I'm not sure what else would be causing the error you're seeing. ------------------------------ Ryan Pflederer ------------------------------25Views1like1CommentRe: Color-coding a field based on calculated percent
Hi Patricia! I believe this is what you're looking for: Round(([Count]/[Number Held])*100,0.01) Also, in an effort to save time and typing, here's the full formula leveraging variables to reduce duplicative work: var number value = Round(([Count]/[Number Held])*100,0.01); var text display = $value & "%"; If( $value > 10, "<div style=background-color:Black>" & $display & "</div>", $value > 2, "<div style=background-color:Red>" & $display & "</div>", $value > 0, "<div style=background-color:Yellow>" & $display & "</div>", $value <= 0, "<div style=background-color:LightGreen>" & $display & "</div>", $display ) ------------------------------ Ryan Pflederer ------------------------------17Views1like3CommentsRe: How to check if record field is empty in API_DoQuery
Hi Charlene! I'd recommend using the RESTful JSON Run Query API instead. It'll provide more clarity on the blank fields you mention, in addition to generally being easier to navigate than XML. ------------------------------ Ryan Pflederer ------------------------------18Views0likes0CommentsRe: Mass edit form fields or dynamic form rules
Hi Bob! There isn't a way to 'mass edit' form rules. Out of curiosity though, is there a reason you're not using a child table? Obviously I don't know the specifics of the use case, but often times this type of scenario can be simplified by leveraging an embedded report. ------------------------------ Ryan Pflederer ------------------------------6Views0likes1CommentRe: How to time stamp a field using a button.
Hi Luis! This is because formulas are evaluated as they change, so Now() gets evaluated when the page is loaded rather than when the button is clicked, meaning if you leave the page open for 5 mins before clicking the button, the time being captured was 5 mins ago. There is a way to capture the time that the button was actually clicked, however you'd need to leverage a Date/Time field rather than a Time of Day field. To do this you'd simply want to set the value of _fid_8=now where now is a text string rather than the function. That way, when the request is made you're telling the server to use the current time rather than the time that the page was loaded. So within your finish button logic go ahead and change this &_fid_8="&ToTimeOfDay(Now()) to this &_fid_8=now" ------------------------------ Ryan Pflederer ------------------------------42Views0likes0CommentsRe: How to write a formula that returns "Task Ovrdue" if a task is beyond (X) days
Hi Bob! You're so close! Give this a try: If( (Today()-[Max Activity Date])<[Activities Due Every (x) Days], "Current", "Activities Due" ) ------------------------------ Ryan Pflederer ------------------------------12Views0likes0CommentsRe: Using Code Pages to Refresh with a Delay
@Mike Tamoush it's probably failing because %%rid%% is within URLEncode() . This fails because the system is looking specifically for %%rid%% but when it's encoded it actually becomes %25%25rid%25%25 . The solve for this would be to wrap everything but %%rid%% in URLEncode(), like this: //This is a redirect link, and therefore needs to be URLEncoded URLEncode(URLRoot() & "db/" & dbid() & "?a=er&rid=") & "%%rid%%" & URLEncode("&_fid_7=" & [Status])116Views0likes0CommentsRe: Virtual Empower: App Library
@E. P in order to be able to run this on a schedule you'd need to create a Pipeline (or other similar server side script) to do all of the processing. I've started working on a Pipeline for this a couple of times since it's been highly requested, however simply don't have the time to complete it. With that said, if someone does create a PL for it and is willingly to share the YAML I'd be happy to add it into the app. In terms of event errors, this app is populated with data extracted via APIs. Currently there aren't any APIs which expose these details, however I do try to keep the app up-to-date with any new APIs that are released. ------------------------------ Ryan Pflederer Implementation Consultant Quick Base ------------------------------29Views0likes0Comments