ContributionsMost RecentMost LikesSolutionsEmail All - Pipelines I have a table called "Rapid Notification" I have another table called "Water Systems" Within rapid notification, you have an option that says, "Send to Who?" If the option says "POC" (Point of Contact.) Within water systems, there is an email field for our POC's. What I want: When I add a new Rapid Notification, AND Send to Who? is POC, send an EMAIL to ALL water system POC's. I want to set this up through Pipelines. I cannot figure out how to get it to send it to ALL water systems. There is a relationship between the two. Each water system has many Rapid Notifications. I tried going the other way as well. Each Rapid Notification has many water systems, however, when doing that we have to go to each individual water system and assign the related Rapid Notification to each water system every time we add a new Rapid Notification and its too time consuming so I removed that relationship. We use the rapid notification for many reasons - sometimes we send a rapid notification to all the customers assigned to a water system. (Each Water System having many Rapid Notification relationship comes in handy, assign the water system to the one rapid notification and it sends to all its customers on the water system through pipelines) But sending an email to all water systems at once, has been a challenging task for me. Please help! Re: Legacy Form + Rich Formula Field Thanks for all the information! My goal is, when I create a new employee in our system, certain files are always available without me having to upload a new attachment. I want to upload it once and then have a formula display my uploaded file across all employees as part of the form. This code worked in the old style form and still does when I go to the old form. Legacy Form + Rich Formula Field I want to display a link on my form. It needs to be displayed always. The code I used in the older form was: var text Words = "Core Rules"; var text URL = URLRoot() & "up/" & [_DBID_Documents] & "/a/r" & "5974" & "/e6/v0"; "<a href=" & $URL & ">" & $Words & "</a>" i.e: Name of link, and the url to the document already stored in quickbase from another table. Flipping from the older form, it works, and moving it to the new legacy form, it shows the following error: "400 Error Invalid field type" The specified field was not a File Attachment field If the problem persists, reach out to your app admin, check the Quickbase service page. or open a support case" How can I fix this for the new legacy form? The link works, but clicking on it, I get that error. Below is how it looks on every employee's portal. The links just don't work now. HELP! I created a new field, and typed in the code, and it displays the same behavior. Re: Formula Rich Text / Image / Link To Project Is there anyway to include image width/height to this code? I keep playing with it and it tells me theres an error in my code. Re: New Legacy Forms I knew you can do that; I was just wondering if there was any way to make it HTML like you could on the old form. New Legacy Forms In the classic forms, there was a way to put in a "text" selection, then enable HTML Limited to do special HTML quips. In the new legacy form, I cannot figure out how to do that? Any suggestions? Re: WildCard Search in Tables What if we want to search a term that could be spelled multiple ways? Example: Adam, or maybe Adam is spelled with a silent "J" so we search "Ad*m" because we're unsure how it's spelt but know it's different and it would pull anything that has "ADM" knowing the Asterix could be anything? URL 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 ------------------------------