ContributionsMost RecentMost LikesSolutionsRe: Color coding formulaThat's perfect! Thank you so much Mark. ------------------------------ Catelyn Atkinson ------------------------------ Re: Color coding formulaHi Mark, No worries, I appreciate your help. correct my logical thinking if it's wrong, but won't that show the record pink if both the fields are blank? we want to set it up to where it shows pink if a field is filled in with a date while the other one to have the record show pink if the date is not filled in. ------------------------------ Catelyn Atkinson ------------------------------ Re: Color coding formulaHi Mark, Thank you for your help on this. I did try that formula, but it's giving me an error due to the = in the formula. if(IsNull([all info task]) = "" It's an operation '=' can't be applied on types bool, text error. Our all info task field is setup as a date type. I originally tried going this route, but I also got this error. ------------------------------ Catelyn Atkinson ------------------------------ Re: Color coding formulaHi Mark, All info task field is a date field. ------------------------------ Catelyn Atkinson ------------------------------ Color coding formulaHi, I'm trying to color code a report depending on a couple different fields. My formula isn't working, but i'm not sure what i'm missing. Any help would be great. Field 1: [All info task] : we want the record to be pink if it has a date. Field 2: [internal due date] : we want the record to be pink if it doesn't have a date Here's my formula if(not isnull([all info task]) or [internal due date]= isnull, "#ff66ff") ) ------------------------------ Catelyn Atkinson ------------------------------ SolvedPreventing date selection for dates before the current dateHi, I have a date field that our users are selecting dates that are in the past and it should always be in the future/today. I didn't see any settings to prevent this from happening. Is there a formula or a setting to prevent a past date for just one field? Thanks! ------------------------------ Catelyn Atkinson ------------------------------ Re: Excel uploads with User Fields Hi Mark, Hope this helps. 1. Is the CSV file a list of Jobs? Yes, we have a list of jobs that are being matched by what we call a notification number as the primary key. 2. And on the file there is an employee name? Yes, we have the employee name as designer responsible which is how we match it when the csv file gets uploaded. 3. On your jobs Table is there a field for Employee Name which is the reference field to a relationship to the the Parent Employe table? Yes, we use the same take designer responsible as that reference field to the parent table. 4. Is that Employee name field the field you are mapping your excel Employee name field into? This is the same field that gets updated in the csv file. Thank you for your help. ------------------------------ Catelyn Atkinson ------------------------------ Re: Excel uploads with User FieldsHi Mark, Could you be more specific on how we would do this? We currently have a table of employees where the full name is the primary key. We have the employee table as the parent relationship, but when we upload to our designer responsible field which is a reference/lookup field to the employee table it shows the name as "Catelyn Atkinson" instead of pulling from the employee table. We are able to edit the record and it then connects to the employee table, but it has to be manipulated manually. ------------------------------ Catelyn Atkinson ------------------------------ Excel uploads with User FieldsHi, I'm having an issue with a user field that someone could shed some light on. We currently upload data through excel csv and one of the fields is designer responsible. Our goal is use this upload data to link back to their employee table so that we can see all their projects or jobs in their employee table. When we upload the data it doesn't connect the name to the user. We've been told it's not possible because Quick Base can't match text name to a user. I've thought about automation, dynamic rules, or even having a field that was a formula that read the name in our designer name text field and selected the appropriate user. Any ideas on how this could work? Thanks! ------------------------------ Catelyn Atkinson ------------------------------ Excel uploads with User FieldsHi, I'm having an issue with a user field that someone could shed some light on. We currently upload data through excel csv and one of the fields is designer responsible. Our goal is use this upload data to link back to their employee table so that we can see all their projects or jobs in their employee table. When we upload the data it doesn't connect the name to the user. We've been told it's not possible because Quick Base can't match text name to a user. I've thought about automation, dynamic rules, or even having a field that was a formula that read the name in our designer name text field and selected the appropriate user. Any ideas on how this could work? Thanks! ------------------------------ Catelyn Atkinson ------------------------------