2 Replies Latest reply on Dec 18, 2013 1:51 AM by SimonAdams

    Email Reminders

    SimonAdams

      Title

      Email Reminders

      Post

           Hello,

           I am aware that this question has already been asked on these forums, but was wondering if anybody could assist me in creating a script that would send an email reminder 2 weeks before a certain date.

           I have attempted to use the advice already given out, but am having trouble in implementing it. As you will be able to see from the image provided, when I have tried to incorporate the 'Set Field' portion of the script I have not been able to input the semi-colon which I had been instructed to use.

           The correct scripting should be: Table::FieldName ; Get ( CurrentDate )

           However, this brings up the error message 'An operator is expected here'.

           Can anybody guide me in getting past this?

      Screen_Shot_2013-12-12_at_10.56.02.png

        • 1. Re: Email Reminders
          philmodjunk

               When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.

          • 2. Re: Email Reminders
            SimonAdams

                 Thank you for your reply, this has answered a lot of questions! :)