ContributionsMost RecentMost LikesSolutionsURL Formula, "mailto:" & I've built a formula that allows us to push a button and it extracts information from quickbase and throws it in an editable email for us to send through our outlook. I was wondering if there is a way to do the same thing, but include a PDF attachment? ------------------------------ Newman, Savi ------------------------------ Re: Conditional Between 2 Tables. Thanks! This worked! ------------------------------ Newman, Savi ------------------------------ Re: Conditional Between 2 Tables. That's a great idea, how do I get the condition to be 30 days? I am new to that area of things. ------------------------------ Newman, Savi ------------------------------ Conditional Between 2 Tables. Hello, I was addressed with something I am not familiar with. My colleague would like to have the following: A red flag to appear when something is not uploaded. The breakdown: We have 1 table, that has all of our information on. It is called "Water Systems". And it has any and all information pertaining to that specific water system. We have another table called "Documents" and this table allows us to display documents on the "Water Systems" pages. I was asked to have a Red Flag displayed when a document is NOT uploaded to the water system, so we can see that we need to take action. We have paper reports we upload each month to the documents for each water system, sometimes, a month will get missed for a specific water system and we miss it too, because we manage so many water systems across the state. Is there a way to make a red flag when a document isnot uploaded to the water system one month? ------------------------------ Newman, Savi ------------------------------ Date Help Hola, My company inputs water samples, for our tasks. There is a relationship between the two. Like, the task name so it connects to the task overview. Within the water sample, is a field to input the date the sample was taken. We need that date, to display on the task labeled "Nitrate Sample Last Taken" and it displays the date from the water sample on the task IF it was a nitrate. Can you help? ------------------------------ Newman, Savi ------------------------------ Complex Formula maybe? I understand what I want to do, and some of what I need to do - I just can't seem to implement it. We have many tables. We have 2 tables in particular that already have a relationship called Water Systems and Samples. Water Samples are input and assigned to water systems. We get a notification whenever a sample fails - which is great. However, when a sample fails, we're required to take another sample some weeks/months later. We would like to be notified when a sample comes back passing again once a sample has already failed. So, take sample>failed>take another sample>passed after recognized failure>send notification. Ideas? ------------------------------ Savi Newman ------------------------------ Re: Multiple rule date formula. Thanks to you both! ------------------------------ Newman, Savi ------------------------------ Re: Multiple rule date formula. Hmm, maybe I don't understand. :/ So, here's the end goal. We go out to our client on a specific date, 4 years later, we need to return to the client (no specific date, just sometime during the year 4 years later on initial visit) , then after the return 4 years later, we need to show back up to our client a year later (no specific date, just sometime during the year) How on earth can I accomplish this? ------------------------------ Newman, Savi ------------------------------ Re: Multiple rule date formula. That didn't work. So they have a date function that returns the year. I just can't figure out how to incorporate it into my current date formula. Year(Date d) Description:Returns the year number of the Date d. Example:Year([Start Date]) returns the year of the date that appears in the Start Date field. Year(ToDate("Jan 10, 2000")) returns 2000 Now adding that information with my current "WeekdayAdd([Last Hazard Survey:], 1305)" Is my problem. :( ------------------------------ Newman, Savi ------------------------------ Multiple rule date formula. Good afternoon, I currently have a formula date named "Sanitary Survey Due" based on a different field: WeekdayAdd([Last Hazard Survey:], 1305) I also need this formula to have it so the date that is displayed for Sanitary Survey Due be ONLY the year, and not a date, but I don't know how to do this. ------------------------------ Newman, Savi ------------------------------