Formula to Show "Day of Week, XX/XX/XXXX to Day of Week, XX/XX/XXXX"
Hello, Can someone provide any insight into how to create a formula that produces text that will show [event date start] to [event date end], when [event date end] is empty. I need a field that will combine two date fields to show, for example, "Thursday, May 6, 2021 to Friday, May 7, 2021". I have the following formula in a formula - text field set, but it's showing me what I need in a simple "5/6/2021-5/7/2021" format when I need to spell it out more like above. If(not IsNull([event date end]),ToText([event date start])&"-"&ToText([event date end]),ToText([event date start])) Thank you in advance for your help! ------------------------------ Gabriella Tremoglie ------------------------------299Views0likes1CommentCheckbox Formula to give me a 1 or a 0
Hey hey I was trying to figure out the formula so that when I check a checkbox (In another field) it will give me either a one or a zero in this formula field that I'm trying to build. I imagine it will look thing like... If([Checkbox Field]="Checked",1,0) This doesn't seem to work... error message is "the operator = can not be applied to types bool" please advise how I can set this formula field up - Thank you! ------------------------------ Jack Woods ------------------------------100Views0likes4CommentsRich Text Formula Field - Comma for Currency #?
Hey Community, I'm using a Rich Text Formula field called NPV(Color) to show the NPV value in red when it's negative. It's working well but now I just need to format it - I can't seem to add commas to the currency number in the formula field. Could you help? the formula is below. If([NPV]<=0,"<font color=\"red\">$"&[NPV]&"</font>","<font color=\"black\">$"&[NPV]&"</font>") ------------------------------ Jack Woods | Low Code 4 Lyfe ------------------------------83Views0likes6CommentsHow to use another table for Calculated/Formula Fields
Hi, I created Table A which contains the fields(please see attachment for more details): Stem(Text Field) Region(Text Field) Country(Text Field) Date 1(Number Field) Table A is the parent table of Table B. Table B Contains the fields: Date(Date Field) -> User input Stem(Text Field) -> Drop Down Region(Text Field) -> Drop Down Country(Text Field) -> Drop Down Calculated Date(Date Formula field) - Current Formula is "AdjustMonth([Date], )" Basically, the setup is when a user fills data for Date, Stem, Region and Country in Table B, the Calculated Date field should result in the Date based on the formula above. However, I cannot seem to select the correct record in Table A based on the inputs(Stem, Region and Country) of the user. I have used the reference field for Table B, but it just provides a dropdown of all the records in Table A. This should not be the case as the reference field should be filtered based on the fields (Stem, Region and Country in Table B) which would select the respective record in Table A As an example, a user selects the following in Table B: Date = April 1, 2021 Stem = 1 Region = Region A Country = Country A The Calculated Date should result to June 1, 2021 which is 2 months after April 1, 2021 without manually adjusting the reference field in Table B. Hope this makes sense. Thank you for the help! ------------------------------ Paul Tria ------------------------------64Views0likes8CommentsView query record if single record otherwise view query list
I am creating some buttons in a Formula - Rich Text field. They will allow users to quickly jump from one table to the next using the table to table relationships we have set up. Mainly what they will be seeing is a list of related records based on a query. For example, if I am in the Customers Table and I click on the Invoices button it will take me to the invoices table and I can see all the invoices related to that customer. If there is only one invoice I would like the button to take me directly to that invoice record and not view it in list mode. Is there a way to use the query and set up an if statement that would check the length of the query response and if there is only one then view that record. Below is an example of the query code I am using for one of the buttons. URLRoot() & "db/" & [_DBID_INVOICES] & "?a=q&query=" & "{'6'.TV.'" & [Record ID#] & "'}"62Views0likes3CommentsHow to get values from a fields on the form and display them?
I'll have a form with Main Contact(text), Invoicing Contact(text), Second Contact (text) and etc. Need to find a way to store all this information in one field and display it on a form. ------------------------------ Olena Bilinska ------------------------------55Views0likes6CommentsFormula: Color Coding and Dates
Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic information, (I.e. Start date, employee, etc.) but I was wondering of there would be an easier way to automatically calculate how long the employee has worked from when they were hired until the present date. I also need to find out how to code those times in to different sections (green= 0-1 years, blue= 1-5, etc) so I can graph that info. If anyone has any suggestions or can point me in the right direction to go that would be amazing! Thanks54Views0likes3CommentsDisplay Email ID of Current User in a formula field
Hi all, If I create a Formula User field and give User(), it gives me USer Name of the Current Login Screen; What if I want the Current User Email id in a formula field? How Can I get it Say, suppose If I'm logged in, a formula field should show me vivekvishwanath1000@gmail.com ------------------------------ Vivek Vishwanath Hyderabad, India +91 8185868789 ------------------------------50Views0likes1CommentHow to create where clause in quickbase
Hi Everyone! I'm pretty much new to Quickbase so I'm having some issues in creating formulas in Quickbase! Basically the problem here is that I don't know how to create "where clauses" in Quickbase. For instance this formula works fine, but I do not know how to exculde "volunteer time sheet cost" from the calculation If ([Project - ProjID]="AD0014",([Volunteer and Training Time Sheet Cost]+),0) I would like to add following condittion so I can have the correct numbers Where the [Project classification]="Training" ------------------------------ Michael Naser ------------------------------34Views0likes2CommentsFormula for subtracting dates
If I wanted to use a number saying for saying how many days have gone by since a specific date, how would I handle that formula field? So like "3" would mean it's been 3 days (Today) since the scheduled date (March 20th). Any help would be amazing! Thank you! ------------------------------ Michael Brumfield ------------------------------32Views0likes2Comments