Jump to content
Sign in to follow this  
mmonsalveg

please help writing body email

Recommended Posts

Hello , i need your help ,

i would like to know how to write a body email that shows me uncompleted task of the whole database ?

complete=0 ( this is uncomplete task)

complete=1 ( this is complete task)

i dont know how to make a search and put the result on the body ,

this send mail script is going to be used in Filemaker server as a schedule script .

please let me know a solution ,

thank you ,

Share this post


Link to post
Share on other sites

Write a script along the lines of


Go to Layout [ MyLayout ; MyTableOccurrence ]

Enter Find Mode

Set Field ( MyTable::status ; 1 )

Set Error Capture [ On ]

Perform Find



Set Variable [ $mailBody ;



Let ( [

all = Get ( TotalRecordCount ) ;

completed = Get ( FoundCount ) ;

noncompleted = all - completed ] ;



all & " records, " & noncompleted & " not completed, (" & completed & " completed)."

)

]



Then use $mailBody as the value for the e-mail message parameter.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jarvphot 
×

Important Information

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