Recent Discussions
If Then Else formula with a multi select field.
Help Please. I have a multi-select field that has the options of Mail, Email and Dept to Initiate. Mail and Email can both be options. In that case, I want it to display "Mail and Email". But if just mail, "Mail, if just email, "email", etc. However I can't seem to get it work correctly. it does show both. Then will show just Mail, but when Email is selected it still shows Mail. I've looked at this so long and tried to refigure it that at this point is probably glaringly obvious, but I just can't see it. This is the current formula I have: var text Receipt=If(Contains(ToText([License Master - Renewals Received via:]),"Mail, Email")=true, "Mail and Email", Contains(ToText([Renewals Received via:]),"Mail, Email")=true,"Mail and Email", Contains(ToText([License Master - Renewals Received via:]),"Mail"), "Mail", Contains(ToText([Renewals Received via:]),"Mail"), "Mail", Contains(ToText([License Master - Renewals Received via:]),"Email"), "Email", Contains(ToText([Renewals Received via:]),"Email"), "Email", Contains(ToText([License Master - Renewals Received via:]),"Dept to initiate"), "Dept. to Initiate", Contains(ToText([Renewals Received via:]),"Dept to initiate"), "Dept. to Initiate"); "<span style='font-size:18px;color:#1E90FF;white-space:nowrap'><b>"&$Receipt&"</b></span><br>";Solved0likes2CommentsAdd button to create record in different app
Hello, I'm trying to create a button that will direct users to a different app to create a new record in the other app. The database ID for the other app is buwc5yqwz The table ID in the other app is bupbavsbm The related field in the other app is 38 I've searched the community and attempted some examples that others tried but converting them from edit a record to adding a record, but I'm not getting anywhere. What I have attempted so far gives a Page unrecognized error. Attempt1: URLRoot() & "/db/buwc9wxmb" & "=API_GenAddRecordForm&_fid_38=" & [Record ID#] &"&z=" & Rurl() Attempt2: "https://xxxxx.quickbase.com/nav/app/buwc5yqwz/table/buwc9wxmb/action/nwr?a=cr&rid=new&field38="& URLEncode() Do I need to add a token? Thank you!Solved0likes2CommentsIssue with Dashboard Gauge: New Style vs Old Style
Hello Quickbase peeps! So I ran into some challenges with the KPI Gauge widget. The KPI Gauge shows the correct percentage when creating it in 'Reports & charts' but the problem arises when I add the widget to dashboards; it shows 0%. After some troubleshooting, I've discovered that while previewing the KPI, it works just fine until you turn off 'New style'. Please see attached pics. Not sure if this is a bug or if there's any workaround/fixes for this. *Calculation is using summary formulas Thanks!0likes9CommentsSorting Combined Text Field by Record ID#
I have a Combined Text summary field titled "Languages Spoken by Admin" that pulls data from a table also named "Languages Spoken by Admin" that I created. I added the combined text field onto a report on my "PSL Survey" table, but the problem is that the data is automatically sorted alphabetically (see 1st screenshot attached) and not how it's entered on the table shown in the 2nd screenshot (see attached). Does anyone know how I can sort the data by it's Record ID#? NOTE: I have read through different posts that suggest creating a formula text field, but I would like better explanation here on this post.Solved0likes4CommentsStacked Column Chart Output
Hello Everyone, I created a SCC where the X Axis shows Supervisor Name and the Y Axis shows a stack of 5 different Formula Fields we'll call CB1, CB2, etc. My Filters are set to Status = Approved AND Eval Date Is During the Current Month. The chart can shows up to 5 columns 1 per Sup. What I want to do is create the chart to show 2 columns for each Sup. where 1 is data from the Prev. Month and the other for Current Month. Any help would be greatly appreciated.0likes1CommentNew Dashboard developer: How to create a single # KPI report?
I am setting up Dashboards (vs Home Pages) for the first time. I have watched University Training on Dashboards, but need a bit more guidance. Problem: HOW do I set up a new KPI report with single number display of Projects that meet certain criteria (e.g. Active). From videos seems like this should be related to the 'old' circle guage charts. I cannot find single # or circle option under gauge charts. Can someone please help me with this simple task? Thanks in advance. ------------------------------ Annetta Coleman ------------------------------1like3Commentsformula help "if statement"
I want to do something like the below but I am unsure of the all the syntax for or that part is yellow. Can someone help me so this I tried "" If([Salesroom]="Playa Grande",[# of people in party]+1*7.81) or([Salesroom])="GS Landsend", "Pacific Dunes",[# of people in party]+1*9.63 Thank youSolved0likes2CommentsCreate a button that gets the UserID for the user in a user field and then write that information to a field in the same record
Hello Quick Base Community. I am wanting to get the UserID for a user with the click of a button. Using the API_GetUserInfo, I can pull the UserID, copy it and then paste it somewhere, but what I would like to do is click a button that will get the UserID and then write it to a field in the record that I am on. Really the question is, is it possible to call an api and then perform an action using data that is returned from the initial api call? I assume that this wouldn't be a problem using scripting but I would like to know if it is possible natively within Quick Base. Thanks!