Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About frankb3

  • Rank

Profile Information

  • Industry
    Media Production/Music
  • Gender
  • Location
    Lincoln, CA
  1. Container Attachments

    Ryan, Thank you. My COPY table only has 1 associated AUDIO file - however I may have more than one copy records (with copy text each) to email. Would the loop end up sending more than 1 email? How would I do this within 1 single email. Here's how I have that part of the script setup currently: and If(IHR_Audio::Audio_File ≠ "";EmailAttachFile(IHR_Audio::Audio_File);"") and EmailSend
  2. In my Production Order database - my main table is (PRODUCTION ORDER) - under it I have a table (COPY) with child table (AUDIO) that I use to store audio files for each piece of copy. I'm set when the order only has 1 copy record and 1 attachment record in audio. I've set up a script to send an email with the copy along with the audio file without an issue. However, I can't figure out how to send multiple child attachments in an email. Since the list function works with text - the copy part is covered, it's the actual container attachments I can't figure out. Thanks for the suggestions.
  3. In-line Attachments under body

    Ryan, I'm a little perplexed with how this might work with what I already have going on in the script. It includes an inline logo graphic and a calculated field - plus options to add attachments if the particular record happens to have them. Would you mind taking a look at the following - could I indeed add your solution to mine? EmailCreate( "IHR.CreativeServices@gmail.com" ; "fscales@IHRadio.com" ; Production Order::Email Subject_ProdAdvisToProducer) and EmailSetBody( "<html><body><img src=\"cid:IHR-CS-Email-Header-Minimal.gif\">" &"<br>" & Production Order::Production Advisory_08 Producer HTML & "<br>" & "</body></html>"; "html" ) and EmailAttachFileInline( Production Order::Header Container ; "IHR-CS-Email-Header-Minimal.gif" ) & "<br>"& ( Production Order::Production Advisory_08 Producer HTML ) & If(IHR_Contracts::Contract_Container05_AA ≠ "";EmailAttachFile(IHR_Contracts::Contract_Container05_AA);"") & If(IHR_Contracts::Contract_Container05_AA Addendum ≠ "";EmailAttachFile(IHR_Contracts::Contract_Container05_AA Addendum);"") & If(Production Order::Document_01 ≠ "";EmailAttachFile(Production Order::Document_01);"")& If(Production Order::Document_02 ≠ "";EmailAttachFile(Production Order::Document_02);"")& If(Production Order::Document_03 ≠ "";EmailAttachFile(Production Order::Document_03);"") and EmailSend
  4. In-line Attachments under body

    Thanks for the suggestion. I failed to mention that I'm using FMPHost for my solution. Under my plan - they control the server side plugins I can use and don't allow adding additional plugins.
  5. Wonder if there if there are some go to tutorials for in-line background image behind the body of an email. Is this even possible? I successfully have scripts in use that already place a logo in-line, also able to include attachments, and I've hand coded HTML formatted text - so I'm good there. Just wanted to have the option of adding a gradient under the body text. Thank you
  6. I think the Get as CSS is what I'm looking for. Seems to be working.
  7. Ben - as part of my calculated text, there is subtext involved that includes a field where the text is a script (as in piece of copy to be read by a voiceover) - containing line breaks. Is there a way to have that field convert to HTML as well.
  8. It worked. Replacing pilcrow with "<br>" in the text calc corrected the issue in this instance. Thank you.
  9. Needing some assistance if possible (and looks like the specific Email forum is not accepting new topics at the moment). I read the documentation on HTML Inline attachments. I'm needing to place an inline picture as a header to my email followed by a calculated text field as the body. Almost there. The picture is showing up as it should at the top of the email, however below the picture - the calculated text is displaying inline without it's scripted ¶ return keys. (It's one run-on line of text currently). Any suggestions on a solution? I've captured a couple screen grabs of the results so far. Thanks for your help.
  10. I have successfully built a one to many relationship between two tables called Orders & Stations, with a 3rd table called order_stationlink where an order may sometimes have more than one station on the order at a time. Now, enter a fourth table called PSA's. It's separate set of data that is processed a little differently - and that will be brought into the main Orders table later. But instead of a field called Station, it is a field called Region, which may include one or many stations at a time. What I'd like to do is be able to pull in all the Stations that belong to that Region, and somehow move that data over into the Order once the PSA is ready for submission. Appreciate your help.
  11. I have a simple parent and one child table relationship built. "Production Order" and "Copy". An Order can have any number of pieces of Copy. I'd like a way to pull the titles of each piece of Copy back into the parent table to be able to email the Production Order data with the Copy titles. I would appreciate any insight.
  12. Good morning. I'm new to self-joining relationships. I'm glad I found this post because I'm trying to do something similar. I have an order entry table that contains thousands of orders. Client data is pulled for each by it's customer number. I want to have a portal on the order entry table that displays a sub-set of all orders by that client. Can anyone help me out with how to best accomplish this? Thanks, Frank

Important Information

By using this site, you agree to our Terms of Use.