ContributionsMost RecentMost LikesSolutionsRe: Multiple If Statements in conditional formattingThanks for asking for clarification - this is what I was thinking. If BOM Release Date is before Required BOM release date --> Green IF BOM Release date is after required BOM release date --> Red IF BOM release date is empty and Required BOM release date < Today () --> Red IF BOM release date is empty and Today()-Days(10) < [BOM Yellow Date] ,--> yellow ------------------------------ Andrew Andrew ------------------------------ Multiple If Statements in conditional formattingHello! I am doing a conditional formatting field which I am calling "Visual status". I am using this field to alert me to key issues with records in my system visually. I have developed the following code: var text red = "<img src=https://images.quickbase.com/si/24/221-point_red.png>"; var text yellow = "<img src=https://images.quickbase.com/si/24/223-point_yellow.png>"; var text green = "<img src=https://images.quickbase.com/si/24/222-point_green.png>"; If( [Required BOM Release Date]<Today(),$red, Today()-Days(10) < [BOM Yellow Date] ,$yellow ) What I am looking to do now is add a multiple If statement that looks at 1 more field. The new field I have added is [BOM Release Date]. This is the actual BOM release date. What I am trying to figure out is to take into account the actual BOM release date so that my current formula won't turn yellow or red once I get closer to "Today()". The way my current formula is written once my Required BOM Release Date approaches, the record turns red regardless if my team put a BOM in place or not. Thank you for your assistance! Andrew ------------------------------ Andrew Andrew ------------------------------ Working days left in the monthHello, I am trying to build a report where I look at my teams utilization and show how much they can get done in the remainder of the month and if I have given them enough tasks to fill that time. I currently have a tasks table where I store the amount of effort per task, with start date and end date of those tasks. I am trying to figure out how I: 1. Calculate the remaining work week working days left (i.e. right now in May we have 20 working days left). 2. Leverage my start date and end date + hours to determine if the hours applied will consume this month (OR) subsequent months. 3. Make a graph of utilization for next 3 months accordingly. Any help would be greatly appreciated! Andrew ------------------------------ Andrew Andrew ------------------------------ Working days left in the monthHello, I am trying to build a report where I look at my teams utilization and show how much they can get done in the remainder of the month and if I have given them enough tasks to fill that time. I currently have a tasks table where I store the amount of effort per task, with start date and end date of those tasks. I am trying to figure out how I: 1. Calculate the remaining work week working days left (i.e. right now in May we have 20 working days left). 2. Leverage my start date and end date + hours to determine if the hours applied will consume this month (OR) subsequent months. 3. Make a graph of utilization for next 3 months accordingly. Any help would be greatly appreciated! Andrew ------------------------------ Andrew Andrew ------------------------------ Formula URL Navigate to dashboard What code do I need to put behind this URL formula to make it navigate to a dashboard within my quickbase application? Thank you! Recovering Lost dataHey, I have been working with Q-Base for quite some time, and today I accidentally wiped out all the data I had in a field by changing the field type to a calculation. Is there a way for me to get the data back that I wiped out? I don't have a CSV of my data beforehand unfortunately.... Thanks! Andrew ------------------------------ Andrew Andrew ------------------------------ Using Sharepoint for file storage within QuickbaseHello I currently have a Sharepoint site that my team leverages for file storage. I was thinking I wanted to build a Quickbase app that would serve as our tracker...but I didn't want to store some of our more sensitive data on Quickbase servers and instead host in our work Sharepoint site (IT controlled). Is there a way to link out to a sharepoint for documents in Quickbase?Quickbase form creation wizard Question - AuthenticationHello, I was using the Quickbase form creation wizard to embed a form into one of my websites for a generic data entry portal. http://www.quickbase.com/developer/knowledge-base/whats-easiest-way-create-generic-html-data-entry-form-quickbase-application-i-can-embed-my-w I followed the instructions by adding the application token into my app to allow this to all work. And, when I am already logged into Quickbase it works wonders. Problem: If I am not yet logged into Quickbase and I try using the form, it will not work. I get this error: <?xml version="1.0"?> -<qdbapi> <action>API_AddRecord</action> <errcode>22</errcode> <errtext>Sign-in required</errtext> <errdetail>The page you have requested can be viewed only by users who have signed in. Please sign in to proceed.</errdetail> </qdbapi> Has anyone experienced this / know how to fix it? Thanks for all the help!Re: Notifications not sendingThanks Chris, I will do that.Notifications not sendingIs anyone having issues with notifications not sending out of Quickbase all of a sudden? I had a number of notifications scheduled to take place when statuses are changed, and all of a sudden they stopped working this week. Not sure if Quickbase is having issues or if it is something wrong with my application only. Any help greatly appreciated!