ContributionsMost RecentMost LikesSolutionsRe: Using an email field to copy other field to subject line Wonderful, appreciate you help, works flawlessly Re: Using an email field to copy other field to subject lineYup! that is exactly what I am trying to do. ------------------------------ Matt Melrose ------------------------------ Using an email field to copy other field to subject lineHello, Is it possible to copy values from other fields to the subject line via either a formulated URL or formulated email field? EG Priority - HIGH Address - 123 Fake St Email field - 123fake@email.com Button clicked to launch email client. Populated emai:l via Email Field Subject: Address - HIGH Priority ------------------------------ Matt Melrose ------------------------------ Re: link to file based of related field in parent table Thank you so much! ------------------------------ Matt Melrose ------------------------------ link to file based of related field in parent tableHello, I have two tables Project and Documents Project has a bunch of internal information and the documents are supplied by client / staff Each document has a specific type and related to the project via the job number, all associated files relate correctly in a table report, but it is a lot of steps for the staff using mobile devices. What I am looking to do is basically have a URL field that will look at the related project files and the type of the file and provide a hyperlink for easy download / viewing. I have made a hyperlink inside of the child table that opens the correct file, but when i try to lookup that field on the parent it doesn't populate. EG. Projects tab Project number - 12345 Documents tab - Document report: Related Project Type Name URL 12345 Plan file1 working link 12345 Photo image1 working link I would like to be able to move that "working link" for the most recent project (in this circumstance it will be the only plan associated at this time to the project) to the main project page. Thanks for any help ------------------------------ Matt Melrose ------------------------------ Re: Contains -- Multiple optionsThanks guys, I got the table style up and running ------------------------------ Matt Melrose ------------------------------ Re: Contains -- Multiple optionsHey Don, yes would have a fixed number of locations. ------------------------------ Matt Melrose ------------------------------ Re: Contains -- Multiple options I am good with making a table, it's just something I have never had to build, so it's causing hesitation on my end. Yes, the result is solely based on the two factors (location and work type) Thanks, ------Original Message------ Matt, I agree with Don. You can do this by formula, but really this should be table driven so you don't end up with a formula with 100 conditions in a long IF statement. It's just not a good design and it means that regular users can't make a new entry. If you can describe the parameters which drive the result, we can suggest a table structure. Is the result solely determined by the combination of the Location and Work Type? ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com mark.shnier@gmail.com ------------------------------Contains -- Multiple optionsHey, Basically I have a bunch of locations and different jobs that I would like to be able to Populate the field with one outcome, and I am wondering if its possible to have something like IF(Contains([LOCATION],"Milton","Oakville","Mississauga") AND ([WORKTYPE],"Spill","Containment"), "Emergency Response" Or if I would have to list out all the possible combinations. Which would total about 100 different types. Thanks for any help ------------------------------ Matt Melrose ------------------------------