List fields based on checkbox
Hi, I need a formula field that will list some Years if the corresponding Year checkbox is checked. I'm not sure if this screenshot size is ok or not - it looks super tiny when pasting it. In the field "Funding Years", if the corresponding Year has a checkbox: First year Ask is checked, then List the First Year in the Funding Years. If ANY combination of those "Year ask" checkboxes are checked, then I want to list that Year in the "funding years". I've tried all the formulas I can try, I keep getting a mismatch of boolean and number errors, or all of the years populate. My formula right now is: var bool one = [First Year Ask] = true; var bool two = [Second Year Ask] = true; var bool three = [Third Year Ask] = true; var bool four = [Fourth Year Ask] = true; If( $one or $two or $three or $four, List(", ", ToText([Year 1]), ToText([Year 2]), ToText([Year 3]),ToText([Year 4]))) I tried putting "or" in there, but it doesn't seem to take it.
Format Formula URL field
I have a formula url field that I'd like to show nothing or be blank if fid 6 (Status) = In or if Out show as a red button that says "Clock Out". Below is the current formula url field that I'm trying to modify. var text URL = URLRoot() & "db/" & [_DBID_TIME_IN_OUT] & "?act=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_6=Out"; var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); $URL & "&rdr=" & URLEncode($RefreshPage) I've been looking at various posts that use additional variables to set the formatting, but I'm not sure how to incorporate what I've found into the above. If Status = Out then use: var text red = "<a style=\" text-decoration: none; background: #ff0000; border-radius: 5px; color: #fff; display: inline-block; width: 150px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-seif; text-shadow: none; \">Clock Out"</a>"; If Status - In then use: var text white = "<a style=\" text-decoration: none; background: #ffffff; border-radius: 5px; color: #000000; display: inline-block; width: 150px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-seif; text-shadow: none; \">Clocked Out"</a>";Show Numeric Formula Field as Duration
I am creating a time tracking application. Need to allow for entering actual hours and for the use of a clock in/out option. Here is the set up: Time Entries - table to track/enter specific work tasks performed for each Project. Time worked can either be entered directly into an Hours Worked (numeric field) or it will calculate Total Time (duration summary field). Time In/Out - table to clock in/out for a specific Time Entry. All in/out entries are summarized into the Total Time field in Time Entries. My Time Time Entries table has a field Hours Billed which displays either the Hours Worked or the Total Time. All these fields are visible on the Time Entries form but since they are of different types, they display differently. Example, if the time entry is for 30 min the: Hours Worked (numeric) displays as 0.50 Total Time (duration) displays as 0:30 Hours Billed (numeric) displays as 0.50 How can I get Hours Worked and Hours Billed to display like Total Time?
Formula help
I currently have this If([Tour - Salesroom]= " Solmar-New", [Sales Manager]= "Mark Torontow",[Sale - Purchase Price]*ToNumber([Sales Manager Point])/100 first I am getting a yellow notice at end of 100 thought I needed ) but still yellow but I want to add more to this statement. basically need to say If (Tour-Salesroom]= "Solmar-New" then pick Mark jones name in Sales Manger field (frop down list) and pick 4% in sale point field (drop down list or if salesroom is VIP then pick James Dean in sales manager and pick 1.8% ins salepoint field. I donn't know what all the "fuctions do in writing a formula. thanks inadvance
Url of PDF attachment
Hi all. Am trying to create a formula URL field that creates a link that will be used in an external website so users can download an attached PDF. I have marked the actual attachment field so it can be viewed without login. Current Formula : "ourrealm.quickbase.com/db/relevantinfohere/a/r"&[Record ID]&"/e277/v0" But on click, it just reloads our current dashboard. Any help as to where I am going wrong will be appreciated.
