Hi there. I have a list view layout that gets saved to PDF and print.
On my computer everything looks good. However, on clients computer, the right side is cut off.
I have the margin view showing and everything seems to be within the lines.
I am using windows and client on Apple.
I have been asked to set up something that will send out email automaticly when the date in the "review date" field is 14 days prior to the current date, can someone help me with a script that would be able to perfom this task? I have also created and email field that will hold the email address.
I am using EmailRecipients () , and we have noticed that sometimes duplicate emails are being sent. I had one customer who said they received 10!
any ideas? My script is:
Set Variable [ $result ; Value:EmailConnectSMTP("smtp.gmail.com:465";"info@**********.com";"*********";"ssl=1") ]
If [ $result ≠ 1 ]
Show Custom Dialog [ Message: EmailLastError & ¶ & "Feedback emails failed! Password most likely wrong. Tell Doc."; Default Button: “OK”, Commit: “Yes” ]
Go to Layout [ original layout ]
Exit Script [ ]
#send email to foundset
Go to Record/Request/Page [ First ]
Loop Set Variable [ $first ; Value:patients::first ]
Set Variable [ $email; Value:patients::email ]
Set Variable [ $subject; Value:$first & ", Happy Birthday from Colonial Family Eyecare!" ]
Set Variable [ $msgCreate ; Value:EmailCreate( "info@************.com";patients::email ;$subject ) and EmailSetBody( $$body)
Set Variable [ $setRecipients ; Value:EmailRecipients($email) ]
Set Variable [ $sent; Value:EmailSend ]
If [ $sent ≠ 1 ]
Show Custom Dialog [ Message: EmailLastError; Default Button: “OK”, Commit: “Yes” ; Button 2: “Cancel” , Commit: “No” ]
Go to Record/Request/Page [ Next; Exit after last ]
End Loop Set Variable [ $disconnect ; Value:EmailDisconnect ]
If [ $disconnect="ERROR" ]
Show Custom Dialog [ Message: EmailLastError; Default Button: “OK”, Commit: “Yes” ]
Exit Script [ ]
Good morning everyone I created a database runtime solution with FileMaker Pro 15 advanced. The program must export the contents of a form in PDF format. In a solution that runs under FileMaker I could use the command "Save as PDF" but this command does not work in a runtime solution. Could someone tell me how I could make this function? thank you so much.
I have just downloaded the 360works Email plugin Sample and I am doing some tests to check whether this would solve my problem. I would like to be able to download all emails from my email account into "messages" table and then on each customer record show those emails which are related to that customer via a portal based on a relationship between, but what I can not figure out how to do it is that the portal would show but types of emails those marked as "from" emails and those marketd as "to" emails. So far I have created a relationship between Customers::email ------- Messages::From and the portal would show all "from" messages. If I would set the relationship as Customers:email ------ Messages:To, the portal shows all "to" messages, but what I am trying to make is a join portal that would show by date both "from" and "to" messages, then I plan to make a Conditional Formating saying that if Customers:email = Messages::From then all text in blue, and all text in green when it is TO.
Is this something that can be achieved?
Thanks a lot for any tip,